r/learnSQL • • 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

6 Upvotes

0 comments sorted by