Sales Data Analysis

Synthetic sales data analysis with Python. Generate realistic sales transactions, clean and validate data, compute KPIs, and visualize revenue trends by day, month, and category. Includes reproducible scripts and charts for portfolio demonstration. Simple end-to-end sales analytics: synthetic data generation, cleaning, KPIs, and charts.

Features

• Generate synthetic daily orders
• Clean and validate data (deduplicate, impute, recompute revenue)
• Compute KPIs: daily/monthly revenue, average basket, growth rate
• Visualize revenue trends with Matplotlib
• Save outputs to the outputs/ directory

Project Structure

sales-data-analysis/
├─ README.md
├─ requirements.txt
├─ data/
│  └─ generate_sales.py
├─ src/
│  ├─ analyze_sales.py
│  └─ utils.py
└─ outputs/
   └─ figures & reports

Setup

python -m venv .venv
# Windows:
.venv\Scripts\activate
# macOS/Linux:
source .venv/bin/activate
pip install -r requirements.txt

Generate Synthetic Data

python data/generate_sales.py --start 2023-01-01 --end 2024-12-31 --seed 42 --out data/sales.csv

Run Analysis

python src/analyze_sales.py --input data/sales.csv --outdir outputs

The script produces KPIs and charts automatically.

Outputs

• outputs/kpis.txt – main KPIs
• outputs/fig_daily_revenue.png
• outputs/fig_monthly_revenue.png
• outputs/fig_category_revenue.png

Sample Results

Daily Revenue

Monthly Revenue

Revenue by Category

Data Schema