You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Building a Meter Analytics Reporting Kit for Orlando Utilities Commission

By Kevin Maroney

Background

Utility providers deal with a lot of data. The volume is large, the variety is vast, and the velocity is in micro-batches all the way to real-time. 

If utility companies can harness the power of their data, it becomes a competitive advantage and differentiator. Given the nature of the services that utility companies provide, these data-driven improvements may have a far greater impact on customers beyond monetary value. 

For utility providers, the business initiatives are significant:

  • Moving to time-of-use billing 

  • Billing customers more accurately

  • Incentivizing times of consumption during dormant periods 

  • Monitoring green initiatives such as public electric vehicles and the impact they have on the network 

The first challenge for Orlando Utilities Commission (OUC) was centralizing huge IoT-style datasets for analysis.

Challenge

Keyrus partnered with the Meter Data Operations (MDO) team at OUC to build a centralized data warehouse to serve as a foundation for their  5-year utilities data analytics roadmap. A centralized data warehouse enables the commission’s downstream teams and technologies to run the right analyses to answer questions they’ve been asking for years but couldn’t previously answer. Questions like:

  • What is the overall reliability of our network?

  • How can I become more proactive and reduce the number of estimated billings due to meters not producing reads?

  • How can I better use voltage profiles to identify mismapped meters?

The utilities commission asked the Keyrus team to capture the output coming from the AMI/AMR meters in the field as the primary data. Subsets of the data existed in different places, including proprietary systems, which made it extremely challenging to address the team’s requirements. 

The only other way to consume the entirety of this information was to parse through the individual XML files produced by the head-end system. XML presents challenges even in small data volumes, and the commission was receiving 2,000 files every day!

Since OUC had never been able to see and analyze all of this data before, there were dozens of business questions to consider. We prioritized the following business use cases to direct the technical development of our centralized data warehouse, or Meter Data Management Platform: 

  • Network Connectivity (electric and water)

  • Voltage Pattern Analysis

  • Data Quality  

  • Negative Reads and No-Reads

Solution

Working closely with the MDO team, Keyrus created an entire Meter Analytics Reporting Kit (MARK) that would answer the questions of today and serve as a bedrock for the questions of tomorrow. With the IoT nature of the business, the platform needed to ingest, transform, store, and consume over 100 million rows per day in a performant, cost-effective way. We selected best-in-class, cloud-friendly technologies including Talend for ETL/ELT, Snowflake as the data warehouse, and Alteryx and Tableau as the downstream consumption tools.

Unless rolled-up and delivered in meaningful visuals, analyzing 15+ billion rows would yield meaningless results. Our platform included user-friendly dashboards to make these analyses accessible to a wider audience. It also aggregated very large sets of detailed information into simple visuals that clearly illustrate outliers or risks (e.g., missing reads, meters mapped to incorrect transformers, etc.). 

With these  visuals, the utilities commission can drill-down and filter their data to the lowest granularity, not only providing the “what” to their business questions, but also the “why.” 

The entirety of the platform was supported and hosted through AWS. With a focus on DevOps and security, the architecture was deployed via CloudFormation templates to ensure standardization and governance around the different services leveraged to support the platform. We ensured data was only accessible to the consumers who had the right permissions by using the principle of least privilege and creating secure routes for the different components to talk to each other (i.e., PrivateLink between Snowflake and the customers’ VPC).

Data Governance

Because this type of information is highly coveted but often misused, the Keyrus team supported data governance alongside the technical solution. This support included: 

  • Defining the ownership and organizational roles within the utilities commission needed to support the platform

  • Conducting impact analysis for end users

  • Formalizing, prioritizing, and capturing requests for the platform 

  • Assuring data quality procedures

Results

The Meter Data Operations team is now using a centralized data platform to heavily expedite the daily ad-hoc requests they get from across the organization. A request for registered reads or intervals used to take weeks to pull together, depending on the requirements, but now only takes minutes. 

The dashboards we built provide proactive views into faulty meters and allow for the MDO team to create field activities for agents to go out and fix the equipment. With more agents proactive in field activities, the reliability of the network improves, which reduces estimated costs, and increases customer satisfaction.  Other dashboards help improve the accuracy of meter-to-transformer mapping by showing distance outliers and mismatched voltage patterns. The MDO team now supports the greater utilities commission mission to reduce outage times and provide exceptional reliability.

With a centralized data warehouse, the utilities commission can now leverage their information for high ROI initiatives such as fraud detection, leak prevention, usage profiles for customer segmentation, transformer overload, and momentary outage analysis. 

The Meter Analytics Reporting Kit empowers the utilities commission along their 5-year strategic data analytics roadmap to positively affect their bottom line, increase customer satisfaction, and improve reliability in providing water and electricity to over 200,000 customers.

Ready to get started with your own Meter Analytics Reporting Kit? Contact us.

Hear from the Team

Watch the video below to hear Kevin Maroney, Senior Director of Delivery, talk through an overview of the work we did with OUC.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Press release

Keyrus named amongst Top B2B Companies on Clutch

December 12, 2022

The Keyrus team is excited to announce that we’ve been named one of the top 1000 companies on Clutch’s platform in 2022! This is the second year that Keyrus has been recognized by Clutch as a top company and B2B leader. 

Webinar

PDF Parsing with Alteryx Intelligence Suite

December 1, 2022

In 20 minutes, we’ll teach you how to use Alteryx Intelligence Suite to eliminate common problems and inefficiencies in accessing data from .pdf files. In the past, you’d need to run custom Python and complex parsing logic to get any usable data from a pdf. Now, you can parse PDFs with out-of-the-box features in Alteryx Intelligence Suite.

Webinar

Modern Cloud Analytics in Action: Keyrus and Red Ventures

November 11, 2022

The cloud offers new opportunities to save you time and money, allowing you to shift focus from maintaining growing servers and upgrading infrastructure to making your data work for you and the success of your business. Watch the webinar and Q&A to learn how AWS, Tableau, and Keyrus worked together to help Red Ventures migrate to a powerful cloud BI tool that created new pathways for success and a modern data culture.

Event

Pharma/Biotech GTN Summit 2022

October 27, 2022

Keyrus & Anaplan Sponsor Life Science Gross-to-Net (GTN) Summit

Press release

Keyrus Achieves AWS Data and Analytics Competency Status

October 6, 2022

Keyrus achieved Amazon Web Services (AWS) Data and Analytics Competency. To receive the designation, AWS Partners must possess deep AWS expertise and deliver solutions seamlessly on AWS.

Webinar

Live Webinar: Lessons on workforce capacity planning and optimization from Optum (UnitedHealthcare)

October 19, 2022

Wednesday, November 9th, 2022 @ 12:00PM Central Time (US and Canada)

Webinar

Tableau Embedded Analytics: Optimizing insights from Salesforce data

September 20, 2022

Want to optimize your visual analytics in Salesforce? You need the right tools. Tableau Embedded Analytics can be used to help you build and visualize reports in Salesforce.

Success story

How C&S Wholesale Grocers maximized ROI with an analytics center of excellence

September 7, 2022

C&S Wholesale Grocers worked with Keyrus and Alteryx to implement an analytics center of excellence to help them efficiently and effectively achieve business objectives, maximize return on investment (ROI), and standardize best practices.

Success story

Implementing a cloud security automation tool at a global consulting firm

September 2, 2022

Keyrus partnered with a consulting firm to build an in-house cloud security solution that would automate their verification processes and keep their information safe.

Success story

Leveraging Salesforce to improve operations at Pajama Program

July 25, 2022

Keyrus partnered with Pajama Program, a nonprofit organization, to review their Salesforce architecture and improve overall operations.

Logo - Keyrus
New York City

252 West 37th st., Suite 1400 New York, NY 10018

Phone:+1 646 664 4872

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection