Skip to content

Latest commit

 

History

5 Commits

Folders and files

Repository files navigation

📊 Python Based Sales Performance Analysis System

📌 Project Overview

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.

🎯 Problem Statement

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.

🎯 Objectives

  • 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.

🛠️ Technologies Used

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

📂 Dataset Description

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

⚙️ Project Workflow

  1. Import Libraries: Import the required Python libraries.
  2. Load Dataset: Load the sales dataset using Pandas.
  3. Data Inspection: Examine dataset structure, columns, data types, and descriptive statistics.
  4. Data Quality Checks: Check missing values and duplicate records.
  5. Data Cleaning: Convert dates, handle numeric values, and remove duplicate records.
  6. Overall Sales Analysis: Calculate total revenue, profit, and quantity sold.
  7. Category-Wise Analysis: Compare revenue, profit, and quantity across product categories.
  8. Region-Wise Analysis: Identify regions contributing the highest revenue.
  9. Monthly Sales Analysis: Understand monthly revenue trends.
  10. Transaction Distribution: Visualize the number of sales records in each category.
  11. Top-Selling Products: Identify the top 10 products based on revenue.
  12. Key Findings: Generate important business insights and recommendations.

📈 Visualizations

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

🔍 Key Findings

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

Important Insights

  • 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.

💡 Business Recommendations

  1. Focus on high-performing categories and products to understand their sales contribution.
  2. Investigate lower-performing categories and regions to identify improvement opportunities.
  3. Use monthly sales trends to plan inventory and promotional activities.
  4. Consider both revenue and profit when making business decisions.
  5. Regularly update the analysis with new sales records to monitor business performance.

📌 Conclusion

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.

👩‍💻 Author

H S Ashritha

Releases

Packages

Contributors

Languages