Modern, interactive in-Excel visuals for Planning Analytics and TM1
TM1 Visuals helps users rapidly create visually effective, interactive charts to provide a deeper understanding of the data more quickly. Drawing on the best-practice visualisation approach of IBCS (International Business Communications Standards), our chart library helps communicate key business trends and comparisons clearly, effectively and professionally.
TM1 Visuals can be used alongside PAX (Planning Analytics for Excel) or Perspectives to extend existing reporting capabilities. Organisations can deliver best-practice IBCS-compliant reporting on TM1 data quickly, by extending rather than replacing their existing in-Excel reporting processes.
The charts are straightforward to build, and leverage the hierarchical structure of the TM1 database to provide visual data discovery through different levels of data, and to build final version reports. The Business semantic layer accelerates the chart building process and helps increase clarity by standardisation across a suite of reports.
Excel users have struggled for years to build meaningful waterfall charts, but with TM1 Visuals a waterfall showing Group P&L can be built quickly, and then drilled to a small multiple view showing one chart per entity, or one per product line.
The same principle applies to a range of variance charts which are specifically designed to help with scenario reporting and comparison. When significant Actual to Plan, Forecast to Plan or Current period to Previous period variations are seen these can be further explored as required though the chars themselves, or the charts can be used as selectors to filter DBRW formula based tables in PAfE.
Charts are directly data-connected and so there is no need to maintain complex ranges of data within Excel as the chart source.
Additional Visualisation Components
TM1 Visuals adds a number of charting and visualisation components to address gaps in native Excel, and extend what's possible in Excel reporting.
Explore your data through interactive, drillable charts.
A rich library of charts which add value and context to tabular reporting.
Create professionally formatted drillable tables in seconds.