Overview
What this challenge is about.
Designing a Data Warehouse for a Renewable Energy Firm. Expert-level 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 a star schema data warehouse and ETL process to integrate disparate data sources for analytics and reporting.
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
- Design star schemas for data warehousing
- Implement ETL processes using SQL
- Write complex analytical SQL queries (window functions, aggregations)
- Understand trade-offs in dimensional modeling
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Database Systems
Bachelor · Data
Strong alignment
This challenge maps to Database Systems at the Bachelor level. It sharpens the same practical skills your coursework expects — but in a real industry context with actual constraints and deliverables.
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.
- Star Schema
Apply star schema to solve real industry problems and demonstrate production-level capability.
- Etl
Extract, transform, and load data across systems for analytics and reporting.
- Sql
Query, transform, and analyze relational data to extract meaningful business insights.
- Dimensional Modeling
Apply dimensional modeling 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: