Duquesne Light Company (DLC) Case Study
Managed Outages and Assets Needed to Keep DLC Running
Daily volume updates handled seamlessly by the core data warehouse
100,000+
Total compliance analytical reports mapped for the modernization initiative
52
Complex analytical reporting environments fully completed and live
31
Active utility consumers experiencing superior grid reliability
500,000+
About the project
Date
Overview
Building automated data mapping and modern Power BI applications to process massive real-time device updates across southwestern Pennsylvania.
Industry
Technology
Timeline
5 Months
Months
The Challenge
Undocumented modifications, lack of clear logic mapping, and intense weather data spikes.
The utility infrastructure required rapid real-time data ingestion during intense storm events. Previous reporting structures completely lacked documentation, meaning past system alterations left historical records entirely irrelevant.
Our Approach
Transaction log file analysis coupled with a universal data exchange virtualization layer.
Architecting an automated lift-and-shift migration out of SAP Business Objects into a modern, Azure-based cloud data warehouse. Unified complex external analytics across Varasset, ArcGIS, Maximo, and Power Apps.
The Result
Delivered comprehensive device-level visibility across substations, circuits, and storms.
Automated the workflow tracking lifecycle from the initial outage report to final remedial analytics.
Standardized compliance reporting frameworks mandated by the Public Utilities Commission (PUC).
Generated new revenue streams by automated asset performance tracking for cell provider tenants leasing poles.
Built a device-level Call Center Traffic Analytics application to trace spikes right down to specific circuit lines.
“Working with the team gave us clarity and control over our finances. We now make decisions with confidence and scale without uncertainty.”
Explore more results
Discover how we’ve helped businesses across industries improve performance, reduce risk, and scale with confidence.
