Overview
What this challenge is about.
Design a star schema for a renewable energy firm, write SQL scripts, and build analytical queries. Get a verifiable certificate.
The scenario
EcoGrid has 10 wind farms and 5 solar farms, each with dozens of turbines/panels. They report quarterly to regulators and need to optimize maintenance schedules.
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.
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: