Description
This dataset represents a high-fidelity synthetic business history for an Egyptian distribution company named Nile Trade Distribution.
It is designed for advanced SQL, Power BI, and Data Analytics workshops and reflects realistic Egyptian market dynamics, including geographic weighting, freight logic, and seasonality effects.
The dataset follows a Northwind-style relational schema and supports complex analytics scenarios such as:
Sales performance analysis
Discount leakage detection
Delivery SLA monitoring
Freight cost allocation
Ramadan and end-of-year seasonality analysis
Customer ranking and segmentation
Operational lead time tracking
📊 Dataset Characteristics
🔢 Volume
5,200 Orders
31,354 OrderDetails
520 Products
450 Customers
140 Suppliers
55 Employees
12 Shippers
24 Categories
🇪🇬 Egyptian Market Logic
65% of orders concentrated in Cairo, Giza, Alexandria
Remaining 35% distributed across Delta and Upper Egypt
Freight cost increases with geographic distance
Sales spikes during Ramadan and year-end seasons
Egyptian mobile phone formats (010, 011, 012, 015)
Prices in EGP
🏗️ Schema Overview
Fact Table
OrderDetail (transaction-level)
Sales amount, discount, quantity, freight allocation logic
Dimensions
Customer
Product
Category
Supplier
Employee
Shipper
Date (to be created in BI layer)
🎯 Ideal Use Cases
✔ SQL Advanced Query Practice
✔ Star Schema Modeling
✔ Power BI Dashboard Development
✔ DAX Time Intelligence
✔ KPI & SLA Analytics
✔ Freight Efficiency Analysis
✔ Seasonality Analysis
✔ Data Cleaning Workshops
📌 Recommended Skills Level
Intermediate → Advanced Data Analysts
BI Developers
Data Engineering Workshops
PL-300 Practice (Advanced Modeling Section)