The challenges faced by the utility industry have always been high, but in today’s age these challenges can take gigantic proportions if the companies do not make optimum use of existing technology and also keep the doors open to welcome the new ones. The utility industry has certain unique features and it is mandatory for people associated with this industry to constantly upgrade and transform their business models by investing in smart grid and other technologies. A company’s ability and potential to collect; store; analyze detailed customer and operational data is of utmost importance as it enables the company to increase its potential; strengthen customer relationships; maximise their business operations and give the competitors sleepless nights. Moreover, since in this industry, investors, customers and regulatory bodies tend to keep a sharp eye at the proceedings, the companies have to execute their duties and meet the declared service, safety and social obligations with utmost care.


Yes! The utility industry is demanding to say the least and although the companies try their best to meet all the demands by employing the best technologies and upgrading their systems, they still face obstacles and find it to difficult to incorporate the strategies; modules and models into legacy data warehouse environments. Till date, it continues to be a difficult proposition to extract the right data from the multiple systems; access, analyze, manage and deliver this information and insight to the right people and at the time when they need it the most.  


So, is there a way out? Yes, there is and the answer lies in opting for Oracle Utilities Data Model (OUDM).


About OUDM: It is a pre-built, standards-based data warehouse solution designed and optimized for Oracle database and hardware. It offers a single-vendor solution package that is tightly integrated with the business intelligence platform. These business intelligence solution offerings take advantage of Oracle's scalability and reliability, using Oracle's familiar optimization, parallelism, and performance engineering within the database.


What makes OUDM a great success is that it can be used in any applications environment and it is easily extensible, it facilitates the utility company to build a strong foundation for business and operational analytics across the enterprise, thereby allowing each business domain to leverage a common analytics infrastructure and pre-defined cross-domain relationships, thus driving unprecedented levels of intelligence and discovery.


With pre-built data mining, Oracle Online Analytical Processing (Oracle OLAP) and dimensional models, OUDM delivers industry-specific actionable intelligence that offers industry-specific metrics and insights; enable cross-functional business intelligence and also fasten the deployment of the company’s data warehouse so that the company can work on the design and implementation of enterprise information management strategies to beat the competition; increase business and also boost the company’s return-on-investment (ROI).  


 eBIW with its knowledge and understanding of the demands of the industry has implemented OUDM successfully in the offices of global clientele.  




·         Designed and optimized for Oracle BI and DW technologies, and can be extended to support others. 

·         Support cross-functional business intelligence for utilities and provides the foundation for utility enterprise analytics

·         Easy to extend and customize

·         Conforms to any application environment

·         Expeditious data warehouse implementation with prebuilt components and embedded data warehousing best practices for utilities




·         Third Normal Form (3NF) Data Model with transaction level access; the first data warehouse built based on the IEC Common Information Model (CIM) standards for utilities 


·         Three-layered data warehouse architecture to support a scalable business intelligence solution

·         Comprehensive metadata for business intelligence reporting and ad-hoc query.

·         Physical data model with industry specific measurements; Over 670 tables with over 4,800 columns; and 1,300 industry-specific measurements and 80 KPIs

·         Sample Star Schema, OLAP Cubes and Analytical Models for ease of implementation

·         Industry specific sample use cases for customer extensions