This project analyses a retail orders dataset using Python, SQL, and Jupyter Notebook.
It demonstrates essential data analytics skills, including cleaning and SQL querying.
Dataset Name: Retail Orders Dataset
File: orders.csv
Source: Kaggle
The dataset contains fields such as:
- Order ID
- Order Date
- Ship Mode
- Customer Name
- Product Category
- Sub-category
- Sales
- Quantity
- Profit
- Discount
- Region
- City
- Clean and preprocess retail order data
- Explore sales and profit trends
- Analyse product and category performance
- Understand customer behaviour
- Use SQL for structured analysis
retail-orders-data-analysis/
│
|
└── order_data_analysis.py
│
└── retail_queries.sql
└── README.md