MDM for Utilities: Data Revives a 100 Year-Old Business Model
In both Europe and North America, there’s something profoundly different about today’s Utility Bill. Today’s bill goes well beyond the amount of money you owe for service that month. Today your Utility Bill is full of DATA. Perhaps it contains baseline analytics around usage and temperature, over a twelve month span. Perhaps it contains additional warranties for the power lines that go from the street to your property (typically not covered for repairs by the utility). In fact, recently, even 3rd party companies have been sending me mail, offering to engage in a fixed-rate payment plan to smooth out my cash flow from the customary projected (from last year) vs actual (read) usage readings. Since smart readers are cropping up everywhere, I was wondering why this “actual vs plan” was still practice, even in the most urban of environments.
In fact, a modern utility company has far more intricate data than a consumer sees on a bill. Behind the scenes, utilities leverage a plethora of data pools. Utility companies now have robust asset management, job order and scheduling systems. In addition, they use advanced analytics that monitor sensor data to predict maintenance needs. Mostly importantly, utilities run monthly analytics to prepare rate case requests with local regulators. These are then used to lock in new cost-plus structures for local and business billing in the years ahead.
Unfortunately, most of these applications sit in geographical or departmental silos, and only connect with each other in batch mode, if at all. These data silos make utilities susceptible to frequent, costly data clean-up projects. These Data clean-up projects always surface the Utility’s shortcomings with regard to data standardization, duplication, linkage and hierarchical structuring. However, until recently, few Utilities were willing to invest to ensure that the newly cleaned data pools remained clean.
Enter MDM for Utilities
Master Data Management is the lynch pin for resolving Utility data issues. Without a clean, enriched, truthful picture of substation, breaker, valve, pump and line information, how can an operator adequately document the need for a rate hike? MDM can help answer questions like:
- Was that breaker really installed in back in 1900?
- Or is the year 1900 simply the default date for this data field?
- Does the substation design mirror what was actually installed?
- Is the breaker physically located where it is supposed to be?
- Am I paying maintenance for a breaker that is actually owned by another operator?
- Why am I sending a crew to inspect equipment that was deemed in-working-order one month earlier?
- Is the housing development meter really located where the installing contractor claims it was installed?
Without MDM, utilities face all sorts of potential problems:
- Maintenance budgets can be either underfunded or overfunded
- Job vs bill requests can fail to align with local county delineations
- New housing construction can be significantly underbid
When a Utility operator uses the wealth of data they possess to optimize their operations, they inevitably reap financial benefits. The Utility company of the future invests in the maintained integrity of their data pool, rather than continually wasting cycles bodies on quarterly data cleansing. To learn how your company can do the same, please register for our Utility Industry MDM webinar on April 1 at 10 AM PST. In the webinar, Informatica and Noah Consulting will address the use cases and financial value MDM can bring to the utility industry.
Disclaimer: Recommendations and illustrations contained in this post are estimates only and are based entirely upon information provided by the prospective customer and on our observations and benchmarks. While we believe our recommendations and estimates to be sound, the degree of success achieved by the prospective customer is dependent upon a variety of factors, many of which are not under Informatica’s control and nothing in this post shall be relied upon as representative of the degree of success that may, in fact, be realized and no warranty or representation of success, either express or implied, is made.