Data Warehouse Interactive Simulator
Experience enterprise data warehousing concepts hands-on
ๅผ็ไบบ้ ยท Benefit All Humanity
โญ Star Schema Designer
Design a star schema with fact and dimension tables
Available Tables
๐ Sales Fact
๐
Time Dimension
๐ช Store Dimension
๐ฆ Product Dimension
๐ค Customer Dimension
Schema Canvas
Click tables on the left to add them to your star schema
๐ ETL Pipeline Builder
Build and test ETL pipelines for data transformation
โ
๐
Transform
Clean & Format
โ
๐ค
Load
Target Warehouse
๐ Dimensional Modeling
Design dimensions using Kimball or Inmon methodologies
๐ Slowly Changing Dimensions Manager
Handle dimension changes with SCD Type 0, 1, 2, 3, 4, or 6
โก Query Optimizer
Analyze and optimize OLAP queries for performance