Analytics and Collaboration Success Story

Data Warehouse Assessment for a Major Gas Utility in the Southeast

Business Situation

• The client is the second largest natural gas utility in the Southeast
• The information technology (IT) department launched a number of creative solutions to support the information management needs of the business

Key Issues

• The client felt they could benefit from an assessment of their initial efforts related to data warehousing and data marts with a focus on effectively providing customer information for reporting and analysis

Outcomes

• The recommendations contained in the final report became a guide to additional data warehouse initiatives for the client
• Recommended a revised and enhanced data model for the data mart design
• Provided an analysis of the additional information that needs to be collected and integrated