Strategy
Designing a BI Strategy for a Regional Retail Chain
Overview
What this challenge is about.
Your challenge is to design a BI architecture including a data warehouse (conceptual and logical models), an ETL strategy to integrate data from multiple sources (POS, inventory, loyalty program), and a prototype dashboard for a single store that shows daily sales, inventory turnover, and customer loyalty metrics. Deliver a strategic roadmap document and a working prototype. Constraints: use simulated data for one store (provided); the solution must be scalable to 15 stores. Success means presenting a clear plan and a functional dashboard that demonstrates the value of BI.
The Brief
What you'll do, and what you'll demonstrate.
Design a BI strategy and prototype a data warehouse and dashboard to enable data-driven decisions across the retail chain.
Earning criteria — what you'll demonstrate
- Design a comprehensive BI architecture for a multi-source environment
- Develop a data warehouse model supporting retail analytics
- Plan an ETL strategy that ensures data quality and consistency
- Create a prototype dashboard that addresses business needs
- Articulate a BI roadmap with cost-benefit considerations
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.