Accelerating insights for a public utilities commission

Background

A municipally-owned public utility commission providing water and electric services to a US state was looking to: - increase visibility into the timelines of their sales pipelines regarding lighting contracts. - understand the impact of solar power on the grid - ensure data security & regulatory compliance

Challenge

Their data was stored in disparate systems: CRM data in Salesforce, Customer care & billing data in Oracle & weather & energy management in SQL databases, it was a slow & manual process for teams to perform analysis and error-prone. They needed improved tools, processes, and data literacy was needed to enable users to be more data driven in their day-to-day.

Approach

- Strategic Roadmap: Keyrus conducted a discovery phase to gather insights to the current organizational capabilities and pain points. This allowed Keyrus to cater the implementation roadmap, technology proposals, and data governance recommendations to the organization. - Build on Scalable Cloud Solutions: critical for security, advanced analytics capabilities, and cost-efficiency. - Enable Self Service Analytics Capabilities: implementation of self-service model that enabled end users to perform their own analysis, beyond standard reporting. - Focus on Data Governance: Keyrus developed a data governance organization, including defined policies and processes

Key results

Benefits

A modernized, scalable, pay per usage data warehouse, data lake, and data integration platform was implemented. The move to a data storage on the cloud lead to major cost savings. Users were enabled with data-driven insights and correct data governance practices, giving them more visibility into their sale conversions and forecasts on sale opportunities, in a self-sufficient way.

Share this key play