Online Retail Analysis Project

Project Structure

online_retail_analysis/
├── data/
│   ├── raw/                  # Original dataset
│   ├── processed/            # Cleaned and processed data
│   └── final/               # Analysis-ready data
├── notebooks/
│   ├── 01_initial_data_exploration.ipynb
│   ├── 02_data_cleaning.ipynb
│   ├── 03_feature_engineering.ipynb
│   └── 04_business_analysis.ipynb
├── sql/
│   ├── create_tables.sql
│   └── analysis_queries.sql
├── scripts/
│   ├── data_processor.py
│   └── analysis_helper.py
├── tableau_workbooks/
│   ├── sales_dashboard.twb
│   ├── customer_analysis.twb
│   └── inventory_insights.twb
└── docs/
    ├── README.md
    ├── data_dictionary.md
    ├── analysis_methodology.md
    └── visualizations.md

Project Overview

This project analyzes online retail data to provide insights into sales patterns, customer behavior, and operational efficiency.

Setup Instructions

1. Clone this repository
2. Install required dependencies
3. Run the notebooks in sequence
4. View the Tableau dashboards for visualizations

Key Features

• Comprehensive data cleaning and preprocessing
• In-depth customer segmentation
• Sales trend analysis
• Interactive Tableau dashboards
• Detailed documentation

Technologies Used

• Python (Pandas, NumPy, Scikit-learn)
• SQL
• Tableau
• Jupyter Notebooks