Technologies: Enterprise Data Warehouse
Industry: Energy Market Operations
Software/Tools: Informatica, IBM Netezza Platform Software, and Erwin Data Modeler
Solution Type: Consulting
Client Challenge:
The client faced a gap in the trusted and timely information needed to fully guarantee the reliable operation of a major region of the North American power grid. An explosion of big data and an aging data warehouse meant the in-house data experts could not service the rapidly expanding backlog of analytical development projects or support the organization’s desire to harness self-service data analysis.
Solution:
- Helped the client’s team reimagine how to develop and deliver quality analytics with more agility. This kickstarted a stream of projects to solve several business challenges.
- Provided ETL development and data modeling services to expedite the use case backlog.
- Designed and built data warehouse pipelines to feed outage coordination historical and near real-time information.
- Helped replace enterprise data warehouse platform by providing data migration and testing service.
Result:
-
A new trusted source of information allowing the client to interactively evaluate, predict, and coordinate grid outages.
-
A sustainable plan and set of best practices to develop future use cases in the development queue.
-
Initial foundation laid for faster informed decisions by new
-
The client now makes better outage management decisions that directly affect the business. With a new foundation and proven success, the organization continues building new data-driven solutions.