The Easy Way to Get Started with Business Analytics Using Microsoft Dynamics GP

In the analytics portion of the Dynamics GP world, PerformancePoint Server is getting all the attention. But the PPS connectors to Dynamics GP won't be released for another month and PPS has a lot of moving parts that incorporate analytics, dashboards, planning, forecasting and reporting.

If you're looking for advanced analysis for Microsoft Dynamics GP, you'll eventually end up at PerformancePoint, but you may not start there.

Microsoft Dynamics GP10 and Excel 2007 offer a terrific starting point for business analytics, without having to learn much in the way of new stuff. The core needs are SQL Analysis Services, which is included as part of SQL Server 2005, Microsoft Dynamics GP and Microsoft Excel. For companies on Microsoft's Business Ready licensing, the Analysis Cubes for Dynamics GP are included at the Advanced Management licensing level.


Requires FREE Membership to View

Become a Member Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Mark Polino

Mark Polino is a Microsoft MVP for Dynamics GP and the Director of Client Services for Fastpath. He is author or coauthor of five books on Microsoft Dynamics GP. Mark has been working with Dynamics GP and its predecessors since 1999. He is a Florida licensed CPA and holds an MBA from Rollins College.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013Mark's new book, Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013, is available now.





Read full bio...

GP Analysis Cubes

I agree with all the usefule and interesting points you made about GP Analysis Cubes. We've been using them for months and the ease of access to varied information has been well received. I would like to point out, however, that the cubes do lack any reasonable path for customization, IE we would like to have access to multiple budgets/forecasts for a given fiscal year and that's not possible.