Optimizing Inventory for a Toronto D2C Cosmetics Brand
Overview
What this challenge is about.
Optimizing Inventory for a Toronto D2C Cosmetics Brand. Intermediate challenge in design. Designing real products under real constraints, earn a blockchain-v...
The Brief
What you'll do, and what you'll demonstrate.
Design and implement a BI system to reduce stock-outs by 20% and decrease excess inventory by 15% within three months.
This is not a design exercise. It is the work a product designer does between a brief and a shipped interface. That distinction matters to every hiring manager who has seen candidates redesign Spotify's homepage and none who have worked under real product constraints.
When you finish, you will have something most graduates do not: a real-world deliverable, verified by Ewance, that you can show to a hiring manager and say "I did this. Here is the proof."
Earning criteria — what you'll demonstrate
- Apply dimensional modeling (star schema) to a business scenario
- Design and implement an ETL process for data integration
- Use OLAP operations (drill-down, slice, dice) to analyze inventory data
- Create a BI dashboard that supports decision-making
- Evaluate inventory performance using key metrics
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Aligned coursework coming soon.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
- Data Warehousing
Apply data warehousing to solve real industry problems and demonstrate production-level capability.
- Etl
Extract, transform, and load data across systems for analytics and reporting.
- Olap
Apply olap to solve real industry problems and demonstrate production-level capability.
- Data Modeling
Apply data modeling to solve real industry problems and demonstrate production-level capability.
- Dashboarding
Apply dashboarding to solve real industry problems and demonstrate production-level capability.
- Inventory Management
Apply inventory management to solve real industry problems and demonstrate production-level capability.
Careers
Career paths this challenge builds toward
Completing this challenge demonstrates skills that transfer directly to these roles: