Power BI Dashboard for GP Admins, Managers & Users
Perform a Dynamics GP System Audit / Assessment & ongoing monitoring through a single location point
With 30 different dashboards and almost 300 Power BI data titles, our Power BI Dashboard for Dynamics GP provides an all-in-one location where users can view the important setups, and document and explore the data in their GP ecosystem!
A Different Twist on Power BI
When getting to know a Dynamics GP environment, it is mandatory to perform a system audit first. This system audit is in essence a series of questions against relevant data sources, as well as reviewing the configurations of each application. The best kind of audit would traverse deeply at both the technical and functional elements of the system. The Power BI Dashboard for GP has been created by incorporating one query or object at a time from an enhanced Dynamics GP audit process into the data model.
The model looks not DEEP, but WIDE instead. This is done by collecting intelligence from 150 SQL objects including:
SQL-Server instance data, The Dynamics GP System, GP Company and Module Setup & Configuration data, Management Reporter data, as well as ISV data
The Current Model: By the Numbers
Current Power BI GP Administrator Model:
- 10 Data Sources
- 30 Dashboards
- 150 Queries
- 348 Tiles
- 3 ISVs
master, model, sp, msdb, tempdb
Intel Points: 14
Company setups, posting setups, multi-currency setup, Doc Attach and Workflow
Intel Points: 42
Intel Points: 10
eOne, Professional Advantage, Mekorma ProFad – Collections, Company Data Archive, Mekorma – MICR for Payables
Intel Points: 6
System setup, activity, user setup, security setup, multi-currency setup, products & upgrade
Intel Points: 41
Financial (GL, Def Rev, Fixed Assets), Bank Reconciliation (incl. eBanking), Payables & Purchasing, Sales, Receivables & Invoicing, Sales Ordering Processing, Inventory, US Payroll
Intel Points: 71
Passwords, Taxes, Last Close, User-Defined Fields, Next Numbers, History, Delete/Void, Module Setup Dates, Pathnames, Master Records
Intel Points: 164
Explore the Dashboards
Take a look below at sample dashboards of our Power BI Dashboard for Dynamics GP
Why Use Power BI as a GP Admin Dashboard?
Because ERP and the GP SQL Tables are complex
Available as part of Office 365
Easy to customize and build upon
Don’t need to be a GP User
Interactive by nature
Don’t need the GP Client Installed
Consistent and repeatable set of queries
Expand or contract the model as-needed
Have a question or looking to use our Power BI Dashboard for GP Admins, Managers & Users? Send us a message below!
More Power BI Solutions:
GP Security Analyzer
The easiest and the most powerfully visual way to understand Dynamics GP Security.
22 dashboards of Dynamics GP Security Analysis Bliss!
There is now a BIGGER, BETTER, FASTER, CHEAPER way to get a handle on your GP user security configurations. Turn big data into a tool that enhances your visibility into user permissions.
GraVoc is a technology-consulting firm located in Peabody, Massachusetts just north of Boston. GraVoc is committed to solving business problems for customers through the development, implementation, and support of technology-based solutions.
"One Company, Many Solutions"