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 Certified Public Accountant (CPA) and a former Microsoft MVP (2007-2018) for Business Solutions. He is the author or coauthor of 5 books related to Microsoft Dynamics GP.  Mark also maintains the Dynamics GP focused website He speaks and writes regularly about ERP related topics. Mark has been a controller and CFO for a division of a publicly traded company and he has  worked as a consultant implementing ERP solutions. Mark holds additional certifications including Certified Information Technology Professional (CITP), Certified in Financial Forensics (CFF) , Chartered Global Management Accountant (CGMA). Dynamics Credentialed Professional for Dynamics GP 2015 (Core Install and Core Financials), Xero Certified. He holds a bachelor's degree in accounting from the University of Central Florida and an MBA from Rollins College. Mark lives with his family in Florida.

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.