1. Project Overview
This project focuses on analyzing customer and sales data using Python to extract meaningful business insights. The main objective is to understand sales performance, customer purchasing behaviour, product demand, and regional sales distribution.
2. Technologies Used - Python - Pandas - NumPy - Matplotlib - Seaborn - Jupyter Notebook
3. Dataset Description
The project uses a structured customer sales dataset containing 100 orders. It includes information about customers, products, quantities, sales amounts, and geographical locations.
4. Data Cleaning and Preprocessing
Pandas and NumPy were used to inspect, organize, and process the dataset. The data was explored to understand its structure and prepare it for further analysis.
5. Exploratory Data Analysis
Exploratory Data Analysis (EDA) was performed to identify patterns and trends in the dataset. Different analyses were conducted, including:
- Total sales and revenue analysis.
- Product-wise sales performance.
- Customer-wise purchasing analysis.
- Region-wise sales distribution.
- Quantity and average order value analysis.
6. Key Business Insights
The analysis generated several useful insights:
- Total revenue generated was 4,982,400.
- A total of 287 product units were sold.
- The average order value was 49,824.
- Laptop sales contributed 2,170,000 in revenue.
- Headphones recorded the highest quantity sold, with 74 units.
- Delhi contributed 1,313,700 in sales.
- A total of 42 unique customers were identified.
7. Data Visualization
Matplotlib and Seaborn were used to create visualizations that make sales patterns and customer behaviour easier to understand. These visualizations help communicate findings effectively.
8. Conclusion
This project provided practical experience in data cleaning, exploratory data analysis, data manipulation, and visualization using Python. It demonstrates how raw sales data can be transformed into meaningful insights that support business decision-making.
The project strengthened my understanding of Python libraries commonly used in data analytics and improved my ability to interpret real-world business data.