Provides overview on meter readings in a Power BI report
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Power BI Reporting | Related Alerts | Webinar
Click to Subscribe and Download Template
Overview
Overview
Provides overview on meter reading statistics in a Power BI report. Includes billed, estimates, consecutive readings
More information to come
Type of Output: On Demand Report Power BI Report
* * *
Sample
Sample
* * *
Variables
Variables
NONE
* * *
Alert Functionality
Alert Functionality
-See here for getting Power BI in place.
-Click here to download the file
For ECi Hosted clients: We work 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.
1. Meter Reading Summary
KPIs:
# Meter Readings (used for billing)
# Consecutive Estimates (used for billing)
# Meter Readings
# Estimated Meter Readings (used for billing)
% Estimated Meter Readings (used for billing)
# Invalid Meter Readings (used for billing)
% Invalid Meter Readings (used for billing)
Visuals: # Meter Readings (used for billing) over time by Reading Type (Automated, Estimated, Other, Web etc.)
# Meter Readings (used for billing) over time by Reading Type ( Automated, Estimated, Other, Web etc. )
# Estimated Meter Readings (used for billing) over time
% Estimated Meter Readings (used for billing) over time
% Invalid Meter Readings (used for billing)
Filtering:
KPIs:
# Meter Readings (used for billing)
# Estimated Meter Readings (used for billing)
% Estimated Meter Readings (used for billing)
KPIs:
# Meter Readings (used for billing)
# Invalid Meter Readings (used for billing)
% Invalid Meter Readings (used for billing)
Visuals: Analysis by Creator, Account, Contract Number and Over time
Drill-throughs: Meter Readings used for billing *** same as above
KPIs:
# Invoices
# Invoices with Estimated meters
% Invoices with Estimated meters
% Invoices with Estimated meters RT (RT =Cumulative Running Total)
Visuals: Analysis by Creator, Account, Contract Number and Over time
Drill-throughs: Invoices with Estimates
KPIs:
MG Allocated Revenue: # Meter Readings (used for billing)
MG Allocated Revenue RT (RT =Cumulative Running Total): # Meter Readings (used for billing) RT (RT =Cumulative Running Total)
* * *
Power BI Reporting
Power BI Reporting
* * *
Related Alerts
Related Alerts
See full list of all Power BI reports that we currently have available
https://support.ceojuice.com/hc/en-us/sections/360011259132-Power-BI-Reports
* * *
Webinar
Webinar
**COMING SOON**
0 Comments