Microsoft Moves into Leaders Category on Forrester’s 2010 Enterprise BI Platforms Wave

 

Microsoft has moved into the “Leaders” category for Enterprise BI Platforms according to Forrester. The beauty of the BI offerings for Microsoft Dynamics GP is that the heavy lifting of extracting data, transforming it and preparing it for analysis is all done behind the scenes with Analysis Cubes for Excel for Dynamics GP. This leaves businesses free to concentrate on analyzing their data, not fooling around with loading it.

Installing Analysis Cubes for Excel for Dynamics GP is really 3 basic steps:

1. Run the GP Analysis Cubes Wizard – Answer a few questions like server location and where the analysis cubes should be created.
2. Run the SQL Server Agent job created in SQL Server to populate the cube data. This handles the whole Exchanges/Transform/Load process for Dynamics GP cube data.
3. Explore the data with Excel Pivot Tables

There are more nuances to really get the most out of Analysis Cubes but to get started, it doesn’t take any more than that.

Why aren’t you using Analysis Cubes today?