Data Warehouse Requirements

A large Midwestern utility asked Celeritas to assist with analyzing business processes related to their Generation Services business unit. The analysis was initiated so that a data warehouse could be constructed in order to support strategic decision making around all aspects of the Generation Services business.

The initial effort included interviews of all Generation Services groups, including Fuels, Power Marketing, Energy Resource Planning, Risk Management and Energy Accounting. Celeritas also examined how PeopleSoft and regulatory data was used by these groups. Through this process, Celeritas helped the utility document their existing processes, identify inefficiencies and envision how existing data could be leveraged for strategic use by the company.