The Sacramento Municipal Utility District (SMUD) comprehensively tracks system outages so they can effectively direct resources to minimize customer disruptions. Leveraging SMUD’s newly built SQL Server back-end, Analytica was able to build a Power BI dashboard that allowed SMUD staff to analyze real-time circuit performance and conduct reliability studies at a moment’s notice.
PROJECT GOAL
- Allow SMUD staff to analyze real-time circuit performance and conduct reliability studies at a moment’s notice in a consistent and repeatable manner
PROJECT RESULTS
- Created dashboard utilizing Power BI as the front-end
- Served data from SQL Server back-end utilizing stored procedures
- Completed within a very short timeline