Case Study: a utility company improves conservation and customer service with Slalom’s Microsoft Power BI solution

Utility Company - Customer Case Study

A utility company faced a challenge in interpreting the massive amounts of data generated by its new smart meters, which were producing over 35,000 readings per customer annually. The utility needed a way to turn this data overload into actionable insights to improve grid monitoring and conservation efforts. Slalom was engaged to help the utility make sense of this information.

Slalom implemented a solution using Microsoft Power BI and SQL Server 2014 to process and analyze over nine billion rows of smart meter data. The results provided the utility with valuable operational insights, enabling them to drive energy conservation through targeted rate plans, rapidly respond to grid failures, and improve the customer experience with better service. This data-rich approach provided empirical evidence for trends and allowed for more informed decisions on efficiency and investments.