1️⃣ Small Dataset (Practice Version)
📁 Tables Included:
Customers
Orders
Products
USA Sales
🎯 Purpose:
The Small Dataset is designed for learning and testing data modeling concepts such as:
🔹 Table relationships (1-to-many joins)
🔹 Merge & Append operations
🔹 Data cleaning & transformation
🔹 Creating calculated fields
🔹 Testing star schema design
🔹 Practicing basic Tableau connections
🧠 Use Case:
This dataset is ideal for:
Beginners learning data modeling
Practicing joins between Customers, Orders, and Products
Testing UNION (append) operations
Validating logic before moving to large datasets
📦 Size:
Small file sizes → Fast processing → Easy debugging
2️⃣ Big Dataset (Dashboard / Analytics Version)
📁 Tables Included:
Customers
Orders
Products
USA Sales
(Same structure as small dataset, but with significantly more rows)
🎯 Purpose:
The Big Dataset is built for:
📊 Building interactive dashboards
📈 KPI reporting (Revenue, Profit, Quantity)
📉 Performance analysis
🗺 Regional sales analysis
👥 Customer segmentation
🛒 Product performance insights
🧠 Use Case:
Executive dashboards
Performance tracking
Real-world BI simulation
Stress testing dashboard performance
Advanced Tableau features (LOD, parameters, filters, actions)
📦 Size:
Larger row count → Realistic business environment → Better performance testing
🔁 Key Difference
Feature Small Dataset Big Dataset
Data Volume Low High
Purpose Practice joins & merges Build full dashboard
Performance Very fast Real-world load
Use Stage Development Production / Final reporting
🏗 Recommended Workflow
✅ Start with Small Dataset
Build relationships
Test merge & append
Create calculated fields
🔄 Validate your logic
🚀 Switch to Big Dataset
Connect same model
Build dashboard
Optimize performance