eBook Giveaway: Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

April 19 2013

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013Where will Microsoft Dynamics GP solution owners find that next level of value from their ERP investment?  Let's not downplay the important fundamentals

About Jason Gumpert

As the editor of MSDynamicsWorld.com, 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 jgumpert@msdynamicsworld.com.

Prior to co-founding MSDynamicsWorld.com, 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


JRODENCAL's picture

As a partner we are looking for more and more ways to get the information out of systems. Our primary source is GP, but also CRM. Dashboards whether built with Excel, or SSRS are definitely where things are going to go to. You don't want your CEO inside of GP asking all sorts of questions, you want to give them the answers right at their finger tips and in a way that they understand it. Also would love to have a chance to win a copy of this book :), I always enjoy reading the articles and responses from Mark. Joel

MatthewIvey's picture

Having undertaken a full-scale review of all systems and processes before selecting our new ERP platform and BI tools, I am acutely aware of how much time is spent/'wasted' by employees building and running reports on a regular basis just to cobble together some sort of 'state of play' review for an area of the business. Even when the reports are fine-tuned to deliver precisely what you want, there always seems to be a modicum of re-formatting to be done before presentation to senior management/exec for review. By pushing such data through a dashboard, everyone becomes familiar with what is being reported, and how we as a group are performing. It also provides an easy-to-access site for everyone to go to at any point and review. This can remove the need for individuals to find a mutually convenient time to meet and 'present' the information to others. The only caveat to the process is that everyone must have total confidence in the data being presented. Dashboards can transform a business overnight, but only if the ground work is put in beforehand to ensure there are fully robust and consistent systems of work to enter the base data that the dashboard pulls from.

jvmoore13's picture

As I meet with clients, the de facto reporting choice is excel. It is not good enough to provide a beautiful SSRS report or smartlist. Invariably, they want the report in excel so they can explore and analyze the data. Being able to deliver dashboards and reports directly in excel eliminates a lot of effort clients will go to get "get" the report into excel. Between data connections back to GP and powerful new technologies such as Power Pivot, end users have a lot of power at their fingertips. Our challenge will be to deliver the data in a way to facilitate this. I look forward to new insights from Mark's book as we continue this journey. I would love a copy of Mark's book

wetterc's picture

As the main user of GP for our company, I would love to learn more ways to create "snapshots" of high level informational reports to give to our CFO and CEO. I would love to have a chance to win one of the books you are giving away. Thanks for the opportunity.

John Casey's picture

As Director of Business Development at Pivotstream, I would like to thank Mark for the mention of our Cloud PowerPivot solutions. If you would like additional information on Pivotstream or participate in our Free Trial please visit our website, http://www.pivotstream.com. John Casey

sberlin's picture

I am sure this book will be as good or better than his cookbook and will give us great examples and tools to get better data from dynamics. keep up the good work and thanks for all of your contributions to the Dynamics community. Steve Berlin

Eyespi20's picture

We currently do quite a bit of dashboard reporting, so I'm always looking at ways to present data in a dashboard type format. Margaret Norkett DBA Commercial Foodservice Repair

js2012's picture

Our current "snapshot" reporting is all manual input. As the primary analytical accountant, I am always looking for ways to get the data I need in a more efficient way. Looking forward to implementing the use of GP dashboards & Excel! Julie Stewart

tomheldstab's picture

The move to self-service BI using excel is on our roadmap to explore and evaluate as a reporting tool that is closer to the end users and their perspectives. We suspect it will enable them to leverage data/reporting more effeciently. A dashboard utilizing Excel and GP could fit as part of this strategy.

sueconrod's picture

We could really use a dashboard to let us know where all our employees are located, but even more so to be able to see their PTO, carryover, total entitlement, accrual to date and remaining. One of our generalist in HR could use a dashboard to know where she is on each of the employees she is onboarding. We currently use a SmartList that shows what needs to be completed from the onboarding process in HR. Sue