The Results

The Output from each of the models created is downloaded to a Microsoft SQL Server Database allowing for full analysis and reporting using Microsoft Office Tools, software which should be familiar to all.

These tools include:-

Excel - From within Excel it is possible to access the CPM OLAP cube and perform detailed analysis of various cost and profit scenarios.

Powerpivot - Powerpivot provides the "data in memory" fast access to analyse, sort and filter great amounts of source data from the various models.

SharePoint - For dissemination of dashboard style information across the business, SharePoint can be used to create interactive dashboards and score cards.

This enriched reporting layer allows for powerful and deep analysis of the costs which are driving your business profitability, starting with high level summarised views yet allowing drill down to the lowest level of data.

Please visit www.tringford.co.uk for more information.