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

Provides overview on meter readings in a Power BI report

Jump to a specific section by clicking a link

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

Reviewing KPIs over time (applicable to all visuals showing time) features a dynamic selection between Date, Rolling Days, Week (1^st 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