Follow

ID356 - Meter Readings (Power BI) Overview & Sample:

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

Screenshot 2025-05-28 at 1.27.47 PM.png

 

*  *  *

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
A screenshot of a web page

AI-generated content may be incorrect., Picture 
 
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.)

A graph of numbers and text

AI-generated content may be incorrect., Picture

# Meter Readings (used for billing) over time by Reading Type ( Automated, Estimated, Other, Web etc. )A graph of a graph with text

AI-generated content may be incorrect., Picture

 

 

 

 

# Estimated Meter Readings (used for billing) over time 
% Estimated Meter Readings (used for billing) over time

A graph of a graph

AI-generated content may be incorrect., Picture

# Invalid Meter Readings (used for billing)
% Invalid Meter Readings (used for billing)

Screenshot 2025-06-13 at 4.33.30 PM.png

Functionality: Functionality features apply to all report pages
Filtering:
Filter date range features a dynamic selection between Dates, Rolling Days, Rolling Weeks, Rolling Months
Screenshot 2025-06-13 at 4.41.22 PM.png
Reviewing KPIs over time (applicable to all visuals showing time) features a dynamic selection between Date, Rolling Days, Week (1st day of week), Rolling weeks, Month (YYYY-MM), Rolling months
Drill through to detail pages can be accomplished by right clicking on the desired KPI
2. Estimated Meters used for Billing

KPIs:
# Meter Readings (used for billing)
# Estimated Meter Readings (used for billing)
% Estimated Meter Readings (used for billing)

Visuals: Analysis by Creator, Account, Contract Number and Over time

Drill-throughs: Meter Readings used for billing

Estimated Meter Readings used for billing
3. Invalid Meters 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

Invalid Meter Readings used for billing

 

 

 

4. Invoices with Begin and/or End Meter Estimate

KPIs:
# Invoices
# Invoices with Estimated meters
% Invoices with Estimated meters

# Invoices with Estimated meters RT (RT =Cumulative Running Total)
% Invoices with Estimated meters RT (RT =Cumulative Running Total)
Visuals: Analysis by Creator, Account, Contract Number and Over time

 

Drill-throughs: Invoices with Estimates

5. MG Allocated Revenue

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)

Visuals: Analysis by Bill Group, Account  and over time
6. Consecutive Estimated Reading used for Billing
7. Active Contracts with Meters
Select a contract from the table in order to view Meter Reading History
8. Duplicate Identical Billable Meter Readings
Only Valid for billing meters considered
Set the min. Duplicate Billable Reads threshold to filter the data table
Drill-throughs: Duplicate Meter Reads

*  *  *

Power BI Reporting

Power BI Reporting

Screenshot 2025-05-28 at 1.28.01 PM.png

 

Screenshot 2025-05-28 at 1.28.18 PM.png

 

Screenshot 2025-05-28 at 1.43.57 PM.png

 

Screenshot 2025-05-28 at 1.44.16 PM.png

 

 

 

*  *  *

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**

 

 

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