Follow

ID704 - "The Model" in a Power BI Dashboard (ID900)

We now have ID900/Financial Performance Benchmarking "The Model" as a Power BI Dashboard (Beta version still).

Hint.png

Video includes a sneak peek of the mobile version at the end:

 

* * *

Alert Functionality

Alert Functionality

-See here for getting Power BI in place. 

-Click here to download the file ( version 20210416). 

-Real time financial data pulled from eAuto transactions. We do not calculate any data, we are just pulling into report format what eAuto transactions provide.

-Note you must have your Financials mapped (ID893) for this dashboard to populate, CLICK HERE for instructions.

-For ECi Hosted clients: We are working with ECi to open up our access so we can set an ODBC connection for you. If you are interested, then please provide us the public static IP address for your company network so that ECi can whitelist it to allow us access.

 

 *  *

Power BI Reporting

Power BI Reporting

Landing Page:

ID704Home.png

 

Select which Financial Model - Bering McKinley or Tom Johnson:

Image__2_.png

Financial Cockpit:

Benchmark Highlights to show target against "The Model". GL on report refers to eAuto and financial refers to the model. This page is high level overview. GL transactions straight out of eAuto, then we run through our mapping app (ID893)  to blend it together, we are not storing or manipulating any eAuto data.

Image__3_.png

 

 

Can see details, use filters to see by branch, GL, etc.

MonthlyFinancials.png

 

Right click to drill through to see transactions (i.e. confirm sharp credits, etc.) while reviewing real time:

DrillDown.png

 

Your company comparisons against the Model:

Model_Compare.png

How do G/L Branches & Departments score based on Model Mapping?:

Scoring.png

How does my Income Statement Compare to the Model?:

Model_Compare_2.png

 

Using Decomposition Trees to analyze model adjustments compared to e-Auto:

Adjustments.png

Right click on to drill down to see adjustments/changes made per model:

AdjustmentDetails.png

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk