Skip to main content

Microsoft Dynamics GP Team Seeks Business Intelligence Dashboard Inspiration

by Jason Gumpert

When we asked Microsoft Dynamics GP director of product management Errol Schoenfish about his team's plans beyond the GP 2013 release, he discussed advancing the GP web client and developing new Windows 8 application functionality.  Business Analyzer in Windows 8 has been GP's first foray into the world of apps, with access to SQL Server Reporting Services (SSRS) reports in a modern touch-based interface. 

But what about Office 2013, and specifically, the de facto BI champion, Excel?  GP product management has not ignored the possibilities here, as evidenced by a new blog post by product manager Pam Misialek titled "Business Intelligence Investigation".

The GP team has created some example reporting dashboards that pull GP data to a front end tool like Excel, and they want the community's feedback. 

The example Misialek has posted is a good looking, refreshable financial dashboard designed for Excel 2013.

Dynamics GP Office 2013 Excel Financial Reporting Dashboard

Here's a link to the file, it just needs to be hooked up to your own GP database to give you your own view of various KPIs, financial ratios, cash flow, and checkbook balances.

" This dashboard is intended as an example to help individuals see how Excel functionality can be used to build reporting experiences. But we're also hoping to build out a few more in the future. So we want to get feedback from you on your reporting needs," ...

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Jason Gumpert

As the editor of, Jason oversees all editorial content on the site and at our events, as well as providing site management and strategy. He can be reached at

Prior to co-founding, Jason was a Principal Software Consultant at Parametric Technology Corporation (PTC), where he implemented solutions, trained customers, managed software development, and spent some time in the pre-sales engineering organization. He has also held consulting positions at CSC Consulting and Monitor Group.

More about Jason Gumpert