Reporting and Dashboards

XLCubed is an Excel-Addin for accessing Microsoft Analysis Services data, with powerful yet simple web deployment. Business users can leverage their existing Excel skills free from the restrictions of pivot-tables. XLCubed provides flexible and dynamic grids, fully layout flexible formulae, and business effective data visualisations, taking what's possible in Excel to the next level. Once complete in Excel, data-connected web deployment is seconds away.

Powerful Analytics:

Questions in business are often simple to ask, but can prove exceptionally difficult to answer. XLCubed's visual query writer brings more power to the end user, in an intuitive way. In the resulting reports, any number can be further drilled, or quickly decomposed into contributing elements by any hierarchy in the cube. See how some typical business questions can be answered in XLCubed (Analytics Example PDF).

Mobile

Reports, dashboards, and input templates built in the Excel Edition can be published to XLCubed Web, and accessed from any device. Our mobile apps for Apple and Android are available in the respective appstores, and provide an optimised browser experience for XLCubed Web reports.

Flexible, cube aware report slicers:

Fully integrated in-cell charting:

Fully integrated in-cell charting facilitates the type of effective data visualisation techniques espoused by leading figures in the arena such as Edward Tufte and Stephen Few. Where required, in-cell charts can be fully row and column dynamic, adding new depth and insight to data exploration and slicing and dicing. Treemaps, Geospatial mapping and Trellis Charts / Small Multiples are also provided.

Powerful User Defined Calculations:

Most cube deployments will have a number of inbuilt calculations which a user can simply select. In some environments there may be hundreds of readily available calculations, but it’s impossible and impractical to build everything into the cube. XLCubed enables users to easily add their own dynamic custom calculations, or Custom Groupings leveraging existing Excel skills. Calculations can be defined at multiple levels and where required shared centrally with other users.

Report Deployment

Reports, dashboards, and input templates built in Excel can be published to XLCubed Web for wider distribution with a few button clicks. XLCubed Web can be deployed standalone or within SharePoint or other Portals. Web reports are WYSIWYG, and fully data connected. Depending on the report type, and the settings chosen at publication time, web reports can have any level of interactivity from interactive slice and dice to fully static.