This AWESOME Power BI tool allows you to “Visualize” your data not only in a map, but as a video over a period of time. It allows you to SEE your data in ways you never even thought amount. Take a tour with me of Elevator Complaints in New York City for Q1, 2014.
I am using this with Microsoft Dynamics GP Sales Order Processing Data in my own system.
This is part 4 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.
In this video, I build an Excel Refreshable Report that shows when I need to reorder Inventory Items based on Item Quantities Maintenance and the Item Resource Planning Maintenance (Order-Up-To Level) in Microsoft Dynamics GP.
Dashboard for Distribution Series:
Part 1: Microsoft Dynamics GP - Excel AR Trial Balance
In this video, I create a Summary Aged Trial Balance for Receivables Management using a custom SQL view created by Microsoft Dynamics GP MVP, Victoria Yudin. The view can be located on her blog posting below:
A GPUG (Microsoft Dynamics GP User Group) member was asking about building a report in Excel that displayed open payables that actually matches GP. There were several great responses to his question, but now I want to add my two cents!
My Friend and fellow Microsoft MVP, Victoria Yudin has made this process a lot easier for you. She has a SQL view that will organize your open payables and age them for you.
This video shows how I use this view to build a quick Microsoft Dynamics GP Payables Management Aged Trial Balance in a few minutes.
MSDynamicsWorld.com held a Google Hangout last month and I was lucky enough to be asked to be on the Panel. If you missed, here's your chance to see it again! (Yes, I copied this right from their channel!)
This panel discussion featured Mark Polino, author of the newly released book "Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013" along with Dynamics GP financial reporting experts Belinda Allen of Smith and Allen Consulting and Jared Hall, Program Manager at Microsoft. Learn more about Mark's new book and related topics around creating, managing, and distributing financial dashboards with Dynamics GP and Excel.
Some of the topics covered in our live conversation included: * Dashboard Basics - who wants dashboards, what elements are a must-have, and what are the must-have skills of a dashboard developer? * Excel 2013 dashboard fundamentals * Running Excel Reports * Managing dashboard requirements * Drilling down: From Excel to GP * Sharing and Collaboration Options
Jason Gumpart and MSDynamicsWorld.com is a great guy with great content. Subscribe to their YouTube channel and to their site: