Data Lake - Case study

110

Years in Electric Utility Service

5K

Employees

4 MM

Customers

Business Strategy Image

Business Need

System integration & development
Develop program schedule
Develop Data Lake
Extract, Transform, Load (ETL)
Functional Design and Requirements
Data Governance
Proof of Value

Challenge

Multiple operating Utilities across various states
Identification of source systems
Several instances of similar/same systems
Custom and legacy systems
Non-standard information models
Different business use methods of systems
Security zones of critical systems
Confidentiality of customer information
Client with a high volume of emergent operational activities

Business Strategy Image

Business Strategy Image

Solution and
Results

Developed a strong understanding of business requirements and use cases
Identified source systems and necessary data to satisfy use cases
Developed strong vendor and client relationships
Developed functional and data requirements based on use cases
Identified data extraction methods and tools