Unifying Multi-State Operations with a Qlik-Powered Operations Scorecard.
Aqua came with a clear ask: help us see how every state is really doing, in one place, at the same time. DI Squared turned that into a living operations scorecard leaders use every month, plus a hurricane response dashboard stood up in just two days.
Operations, unified.
Utilities (Water & Wastewater)
3 Million+
Analytics Strategy, Dashboards & Visualization
Qlik
Daily
Unified operational reporting across multiple states
About the Company
Aqua is one of the largest water and wastewater utilities in the United States, serving more than three million customers across multiple regulated operating companies. Each state manages its own infrastructure, operations, and customer base, making consistent performance measurement both essential and challenging.
As the organization expanded, leadership sought a unified approach to operational reporting that would improve visibility across the enterprise while supporting faster, more informed business decisions.
The Challenge
Although each state operated successfully, reporting practices had evolved independently over time.
Leadership faced several challenges:
Operational reports varied from state to state.
KPI definitions and performance targets were inconsistent.
Monthly reviews focused on validating data instead of improving operations.
Identifying trends and outliers across multiple states was difficult.
During major weather events, leadership lacked a centralized operational view for rapid response.
Aqua needed a single source of truth that would standardize performance measurement while remaining flexible enough to support both everyday operations and critical events.
The Solution
DI Squared designed and implemented a Qlik-powered Operations Scorecard that established a common operating framework across every state.
The solution included:
- Standardized operational KPIs and performance targets
- Daily automated data integration and refresh
- Approximately 30–40 executive KPIs for every operating company
- Interactive dashboards with drill-down capabilities
- Visual performance indicators for rapid issue identification
- Enterprise-wide reporting built around one common operating model
When a hurricane threatened service continuity, DI Squared extended the existing platform by designing and deploying a dedicated hurricane response dashboard in approximately two days, providing leadership with real-time operational visibility during a critical event.
Results Achieved
One Source of Truth
Leadership now views every state’s operational performance using the same trusted metrics and reporting framework.
Better Executive Decision-Making
Monthly operational reviews have shifted from discussions about data accuracy to conversations focused on performance and improvement.
Faster Identification of Operational Issues
Interactive dashboards and standardized KPIs allow leadership to quickly identify trends, risks, and underperforming areas.
Improved Business Context
Visualizations account for differences in system size and operational complexity, helping leadership compare performance more accurately.
Rapid Emergency Response
A hurricane response dashboard was designed and deployed in approximately two days, proving the flexibility and scalability of Aqua’s analytics platform.
Foundation for Future Growth
Aqua now operates from a modern analytics platform capable of supporting future operational reporting, advanced analytics, and AI initiatives.
Client Perspective
“DI Squared didn’t just give us a dashboard. They gave us a new way to run our operations. The Operations Scorecard has become part of how we manage our business every month.”