Sales Data Analytics Project

This is a beginner-friendly data analysis project using Python, Pandas, Matplotlib, and Excel.
It shows how to clean, analyze, and visualize sales data step by step.

---

📂 Project Structure

• sales_data.csv → Raw sales dataset
• sales_analysis.py → Main Python code for data analysis
• outputs/ → Processed CSV files (Product-wise, Region-wise, Monthly summaries)
• Sales_Analysis_Report.xlsx → Final Excel report (all summaries in one file)
• graphs/ → Visualizations (bar chart, pie chart, line chart)

---

🔑 Key Features

1. Data Cleaning

   • Handle missing values
   • Convert data types
   • Create a new column TotalAmount = Quantity × UnitPrice

2. Analysis Performed

   • Product-wise sales summary
   • Region-wise sales summary
   • Monthly revenue & order trends

3. Visualizations

   • Bar chart → Product-wise revenue
   • Pie chart → Region-wise revenue
   • Line chart → Monthly revenue trends

4. Excel Report

   • All summaries stored in one Excel file with separate sheets:
     • Product Sales
     • Region Sales
     • Monthly Sales

---

🚀 How to Run

1. Install dependencies:

   pip install pandas matplotlib openpyxl