Interactive Lesson: Slowly Changing Dimensions
📊 Slowly Changing Dimensions (Type 2) Simulator
Learn how to track historical changes in customer data using SCD Type 2
Welcome! Let’s Learn SCD Type 2 Step-by-Step
Step 1: Look at the Customer Profile on the left – this shows Sarah’s current information as of Jan 1, 2024.
Next: Click on “Mar 15, 2024” in the timeline above to see what changes happened.
Next: Click on “Mar 15, 2024” in the timeline above to see what changes happened.
Real-World Scenario: Customer Data Management
You’re an analytics engineer at an e-commerce company. Customers frequently update their information (addresses, membership tiers, contact details). The business needs to track these changes for shipping analytics, customer segmentation, and regulatory compliance. Let’s explore how SCD Type 2 helps maintain this history!
📅
Customer Journey Timeline
Jan 1, 2024
🆕
Customer Registered
Mar 15, 2024
📦
Address Change
Jun 1, 2024
⭐
Tier Upgrade
Sep 10, 2024
📧
Email Update
Nov 20, 2024
🏠
Another Move
👤 Customer Profile
Customer ID (Business Key)
CUST-10234
Name
Sarah Johnson
Email
sarah.j@email.com
Address
123 Main St, New York, NY 10001
City
New York
State
NY
Membership Tier
Bronze
Event Date
2024-01-01
📊 Customer Dimension Table
💡 Tip: Scroll horizontally to see all columns → |
Surrogate Key = Unique ID for each version |
Valid From/To = When this version was active
🎮 Interactive Controls
Use these controls after selecting an event from the timeline above
🤔 Quick Check: Why is the surrogate key important in SCD Type 2?