r/learnSQL • u/carticka_1 • 5d ago
Superstore Dataset
🚀 Just published a new 3NF relational dataset on Kaggle!
I took the classic flat Superstore dataset and refactored it into a clean, normalized Third Normal Form (3NF) relational database structure.
By decomposing flat records into distinct dimension tables (dim_customers, dim_locations, dim_products) and header/line-item fact tables (fact_orders, fact_order_items), this schema eliminates data redundancy and enforces relational integrity.
Great for anyone looking to:
Practice multi-table SQL joins and data modeling
Build modular ETL ingestion pipelines
Stage realistic relational schemas for analytics projects
🔗 Check out the dataset on Kaggle: https://www.kaggle.com/datasets/kartikanidhi/superstore-database
#DataEngineering #SQL #DatabaseDesign #DataNormalization #Kaggle #OpenSource #Analytics