Design Analytics Data Model
Build a scalable dimensional model for a new business metrics use case
Scenario
You need to design a data warehouse schema for tracking user engagement metrics across multiple product features
4
Steps
50
Points
~90
Min saved
What You'll Practice
4 steps with hands-on AI practice using synthetic data.
Define business questions
List the key business questions stakeholders need answered. Focus on metrics, dimensions, and grain.
Identify fact and dimension tables
Design the star schema with fact table at transaction grain and conforming dimensions.
Define data types and constraints
Specify column definitions, primary keys, foreign keys, and indexing strategy.
Plan ETL and refresh strategy
Design how data flows from source to warehouse, including refresh frequency and transformation logic.
Ready to practice?
Sign up for free and start this workflow with AI-powered feedback.
Get Started FreeExpected Outcome
Complete dimensional model with DDL, documented business logic, and ETL specification ready for implementation
Build AI fluency, one workflow at a time
Join professionals who are building practical AI skills for their actual job. Start free, no credit card needed.