Analytics and Collaboration Success Story

Data Warehousing Strategy for Food Processor

Business Situation

• Major food processor with operations throughout the United States, selling to fast food chains and retail outlets
• Growing demand from business units for data marts, but no overall data warehousing strategy or architecture
• Creating their own data marts in some business units, resulting in conflicting numbers reported to senior management

Key Issues

• Lack of IS experience in data warehousing
• Limited IS resources
• No methodologies for planning or delivering data warehousing projects
• No standard tool sets

Outcomes

• Delivered tools which were immediately productive on data warehousing projects:
• Customized methodology based on proven data warehousing methodology from The Revere Group
• Conceptual architecture for data marts and enterprise data warehousing
• Trained IS staff in key data warehousing skills (data warehousing methodology and dimensional data modeling)
• Prioritized list of short-term projects