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

SHARE THIS POST