Sales Performance Analysis Project
Problem Statement
A business needs to understand its sales and profitability performance across regions, products, categories, and time periods in order to make better data-driven decisions. Raw sales data does not clearly show which regions generate the highest revenue, which products sell the most, which categories are most profitable, or whether any products are causing losses.
Key Findings
1. Total sales and profit performance
The business generated total sales of $12,455 and total profit of $3,150.
This shows that the business is profitable overall and has a positive financial performance.
2. Overall profit margin
The overall profit margin was approximately 25.29%.
This means that for every dollar generated in sales, the business retained about 25 cents as profit.
3. East region had the highest sales
The East region recorded the highest sales with $3,675.
Sales by region were:
| Region | Sales |
| East | $3,675 |
| North | $3,460 |
| West | $2,900 |
| South | $2,420 |
This indicates that the East region is the strongest revenue contributor.
4. South region had the lowest profit
The South region recorded the lowest profit at $610.
This suggests that the South region may need further review to understand whether lower profit is caused by lower sales volume, higher costs, discounting, or product mix.
5. Chair was the best-selling product by quantity
The best-selling product by quantity was Chair, with 12 units sold.
Product quantities were:
| Product | Quantity Sold |
| Chair | 12 |
| Laptop | 6 |
| Desk | 4 |
| Monitor | 4 |
| Phone | 4 |
| Tablet | 4 |
This shows that Chair had the highest demand by volume.
6. Office category had the highest average profit margin
The Office category had the highest average profit margin at approximately 28.09%, compared to Electronics at approximately 23.91%.
This means Office products were more profitable on average than Electronics products.
7. January had the highest sales
The month with the highest sales was January, with $2,725.
Monthly sales were:
| Month | Sales |
| January | $2,725 |
| April | $2,700 |
| February | $2,580 |
| May | $2,450 |
| March | $2,000 |
This shows that January was the strongest sales month, while March had the lowest sales.
8. No loss-making products were found
The analysis showed that there were no products with a negative profit margin.
This means all products in the dataset generated profit.
9. Sales performance varies by region
The bar chart of sales by region showed that sales are not evenly distributed across regions. East and North performed better than West and South.
This suggests that the business may need to study what is working in East and North and apply similar strategies to weaker regions.
10. Sales trend over time shows monthly variation
The line chart of sales over time showed that sales fluctuate across the period analyzed.
This helps the business understand seasonal or monthly performance changes and plan campaigns, stock, and promotions more effectively.
Conclusion
The sales analysis shows that the business is profitable, with total sales of $12,455, total profit of $3,150, and an overall profit margin of 25.29%. The East region is the top-performing region by sales, while the South region has the lowest profit. Chair is the best-selling product by quantity, and the Office category has the strongest average profit margin. Since no products are loss-making, the business should focus on scaling high-performing regions and products while investigating ways to improve weaker areas such as the South region and March sales performance.
Question Answered
1.What are the total sales and total profit?
2.Which region has the highest sales?
3.Which product is the best-selling by quantity?
4.What is the average profit margin per category?
5.Which month had the highest sales?
6.What is the profit per region?
7.Which products are loss-making (negative profit margin)?
8.Create a bar chart of sales by region
9.Create a line chart of sales over time.
10.Create a dashboard with all insights
Download full project on github: https://github.com/ShamimNandawula/Sales-Performance-Analysis-Project.git