Loading chart
Loading chart
Loading chart
Loading chart
Electric Utility
Enterprise
Mendril Utilities
Utility billing, outages, field service, and asset reliability
50% OFF
$12.00$6.00USD, plus applicable tax
19 tables8.7M rowsParquet + CSV
About Mendril Utilities
Industry
Electric utility
Company size
Large regional regulated distribution utility
Operating scale represented
185,000 fictional customer accounts, 155,000 premises, 170,000 installed meters, 32,000 grid assets, 3.08 million monthly bills, 2.94 million bill settlements, 1.18 million sampled daily meter reads, 18,000 outage events, 360,000 service orders, and 95,000 maintenance work records
Planning note
Enterprise-tier BI kit focused on meter-to-cash performance, outage reliability, field service workload, meter-read quality, and asset condition
Mendril Utilities is a fictional electric distribution utility built for BI teams that want credible customer, billing, collections, outage, field-service, sampled meter-read, and asset-maintenance analysis without exposing real account holders, municipalities, grid equipment, or operational records. The kit is intentionally shaped around a large regulated distribution operator, so customers can model meter-to-cash performance, arrears exposure, restoration burden, crew workload, and condition-driven maintenance tradeoffs in one coherent utility story.
Operating Profile
- Serves residential, commercial, industrial, municipal, and public-service customers across eight fictional electric-distribution territories.
- Owns and maintains substations, feeders, transformer banks, switchgear, and service-line groups with territory-based operating districts and crew coverage.
- Manages billing, collections, outage restoration, reconnects, meter programs, and field service through a mix of internal crews and contractor support.
- Keeps the scope on electric distribution operations rather than wholesale markets, generation dispatch, or SCADA telemetry.
Recent Business Events
- 1Mendril unified outage-cause coding and restoration reporting so reliability teams compare districts on one scorecard.
- 2Billing expanded paperless and autopay enrollment while adding clearer tracking for delinquent and collections balances.
- 3Field operations split service orders into five work families to surface backlog drivers more clearly.
- 4Asset teams began scoring condition and criticality explicitly, putting outage-prone equipment in one planning view.
KPI Focus Areas
These are the operating questions this kit is optimized to answer first.
01Focus
Billed kWh, billed revenue, balance due, and arrears mix by class and territory
02Focus
Meter-read actual versus estimated mix, exceptions, and sampled daily usage
03Focus
Outage count, affected customers, restoration minutes, and cause mix
04Focus
Service-order backlog, timeliness, reconnect workload, and crew utilization
05Focus
Asset condition, risk score, maintenance cost, and outage association
Embedded Analytical Stories
Meter to cash
Follow usage into monthly bills, then settle each bill against its payment so cash collected, open balance and billed amount tie out.
Storm to restoration
Compare outage severity, cause, and restoration duration by service territory, municipality, and asset hierarchy.
Premise to field work
Track how meter issues, move/connect requests, reconnects, and vegetation work create service-order workload by district and crew.
Condition to failure risk
Connect asset condition bands and maintenance activity back to outage-prone equipment and customer interruption burden.
Sampled reads to billing trust
Show read quality, estimated-bill exposure, and customer-class seasonality from sampled reads.
Mendril Utilities
Buy Now$6.00USD, plus applicable tax