Among the best attended presentations at Microsoft Convergence 2013 were a pair of sessions entitled "Building Dashboards with Microsoft Dynamics GP & Microsoft Excel," delivered by Mark Polino and Jared Hall. These were based on Mark Polino's new book with a similar title,
Mark Polino is a Microsoft MVP for Dynamics GP (
The book is a step-by-step walkthrough, and when you've completed that walk, you'll have created a sample dashboard that looks like this:
But the book also covers how to build a dashboard that is unique to a specific user and/or organization's needs.
According to the book's preface, it is intended for "the person that the CFO keeps asking about building a dashboard. It's for the controller, the analyst, or the senior accountant who knows there is a treasure of information hiding in Dynamics GP, if they can just get at it. It's for the Excel power user who is tired of being held back by exporting data from GP and rebuilding information every month."
If that sounds like you, better pick up a copy of the book.