The Sales Performance Analysis System is a Python-based data analysis project that analyzes sales transaction data to understand business performance, identify sales trends, and generate meaningful business insights.
This project uses Python libraries such as Pandas, Matplotlib, and Seaborn to clean, process, analyze, and visualize sales data.
Organizations collect large amounts of sales data, but they may not clearly understand overall sales performance, sales trends, or the contribution of different product categories.
This project analyzes sales data using Python to identify useful patterns and present the results through charts and summary statistics.
- Analyze overall sales performance using revenue, profit, and quantity sold.
- Identify high-performing and low-performing product categories.
- Compare sales performance across different regions.
- Analyze monthly sales trends.
- Identify the top 10 products based on revenue.
- Generate meaningful business insights through data visualization.
| Technology | Purpose |
|---|---|
| Python | Programming and data analysis |
| Pandas | Data loading, cleaning, grouping, and analysis |
| Matplotlib | Data visualization |
| Seaborn | Statistical data visualization |
| Jupyter Notebook | Writing and executing Python code |
The project uses a product sales dataset containing 200,000 sales transaction records and 14 columns.
The dataset includes:
- Order ID
- Order Date
- Customer Name
- City
- State
- Region
- Country
- Category
- Sub-Category
- Product Name
- Quantity
- Unit Price
- Revenue
- Profit
- Import Libraries: Import the required Python libraries.
- Load Dataset: Load the sales dataset using Pandas.
- Data Inspection: Examine dataset structure, columns, data types, and descriptive statistics.
- Data Quality Checks: Check missing values and duplicate records.
- Data Cleaning: Convert dates, handle numeric values, and remove duplicate records.
- Overall Sales Analysis: Calculate total revenue, profit, and quantity sold.
- Category-Wise Analysis: Compare revenue, profit, and quantity across product categories.
- Region-Wise Analysis: Identify regions contributing the highest revenue.
- Monthly Sales Analysis: Understand monthly revenue trends.
- Transaction Distribution: Visualize the number of sales records in each category.
- Top-Selling Products: Identify the top 10 products based on revenue.
- Key Findings: Generate important business insights and recommendations.
The project includes the following visualizations:
- Revenue by Product Category – Bar Chart
- Revenue by Region – Bar Chart
- Monthly Sales Trend – Line Chart
- Transaction Distribution by Category – Count Plot
- Top 10 Products by Revenue – Horizontal Bar Chart
Based on the analysis of the dataset:
| Metric | Result |
|---|---|
| Total Sales Revenue | 142,407,744.93 |
| Average Revenue per Record | 712.04 |
| Total Profit | 31,548,608.13 |
| Total Quantity Sold | 370,800 |
| Highest Revenue Category | Electronics |
| Lowest Revenue Category | Accessories |
| Highest Revenue Region | East |
| Highest Revenue Month | November 2024 |
- Electronics generated the highest revenue among all product categories.
- Accessories contributed the lowest revenue.
- The East region recorded the highest total revenue.
- November 2024 was the highest-revenue month.
- The top 10 products analysis identifies products contributing significantly to overall revenue.
- Focus on high-performing categories and products to understand their sales contribution.
- Investigate lower-performing categories and regions to identify improvement opportunities.
- Use monthly sales trends to plan inventory and promotional activities.
- Consider both revenue and profit when making business decisions.
- Regularly update the analysis with new sales records to monitor business performance.
This project demonstrates how Python can be used for sales data analysis and visualization. By analyzing revenue, profit, product categories, regions, and monthly trends, the project provides useful insights that can support better business understanding and decision-making.
H S Ashritha