📊 Sales Performance Analysis

📕 Table of Contents

• Problem Statement
• Objective
• Tools Used
• Dataset Overview
• Key Findings
• Recommendations
• Project Presentation
• Project Learnings
• Installation and Usage
• Dashboard

❓ Problem Statement

In a competitive market, understanding the factors driving sales performance, profitability, and customer satisfaction is crucial for sustainable growth. Our organization faces challenges in identifying top performing products, optimizing inventory, managing returns, and ensuring efficient order fulfillment. Additionally, we need to understand the financial impact of discounts and returns to enhance our profit margins.

🎯 Objective

The primary objective of this analysis is to provide actionable insights into our sales performance, identify areas for improvement, and develop strategies to boost revenue and profitability. By examining key performance indicators (KPIs) and detailed sales metrics, aim is to:

1. Identify best-selling products and high-revenue generators.
2. Assess total revenue and profit margins to gauge financial health.
3. Understand the impact of shipping methods, category, customer segments and discounts on sales.
4. Analyze the efficiency of order fulfillment and the financial loss due to returns.
5. Develop targeted strategies to reduce losses and enhance customer satisfaction.

🛠️ Tools Used

• Analytical & Visual: Microsoft Excel
  
• Presentation: Microsoft Power Point
  

📅 Dataset Overview

• Data source: Internet
• Time period: 2014-2017
• Data size: Orders Table (5009,22), Returns Table (296,2)
• Key columns: Order Id, Ship Mode, Segment, City, Region, Category, Sub-Category, Sales, Quantity, Discount, Profit
• Calculated columns: Profit Margin, Average Order Value, Order Completion Rate, Actual Sales, Actual Profit, Amount Lost, Order Complete, Profit on No Discount, Sales on No Discount
• Data set Link
• Data Model

🔎 Key Findings

• Total sales: $4.5M
• Profit margin: 2.88%
• Best-selling product: OFF-BI-10000545
• Order completion rate: 94%
• Loss due to returns: $247K
• Regional performance: East and West regions outperform others
• Shipping: Standard class generates over 60% of revenue
• Product categories: Furniture and Technology lead in sales
• Customer segments: Consumer segment accounts for half of total sales
• Seasonal trends: Last quarter (Oct-Dec) shows significantly higher sales
• City-wise performance: New York City leads in revenue generation
• Discounting strategy: Current approach results in losses for top discounted products
• Non-discounted products: Show higher profits and sales compared to discounted items

💡 Recommendations

1. Optimize inventory and marketing for top-performing products, especially OFF-BI-10000545.
2. Focus on expanding in high-performing regions (East and West) while developing strategies for underperforming areas.
3. Reevaluate the discounting strategy to minimize losses and maximize profitability.
4. Capitalize on strong last quarter performance with targeted marketing campaigns and inventory management.
5. Investigate and address causes of high return rates to minimize associated losses.
6. Maintain success of non-discounted products while adjusting strategies for other items.
7. Enhance performance of other shipping modes to balance reliance on Standard class.

📌 Project Presentation

Video Presentation

Slides

The detailed presentation slides for this project can be found here

🧠 Project Learnings

1. Data Loading and Transformations.
2. Pivot table analysis.
3. Power Query and DAX.
4. Data modeling.
5. Data visualization.
6. Conditional and calculated column.
7. Importance of data quality.
8. Data storytelling.
9. Sharpened analytical and problem-solving abilities.
10. Actionable Insights Generation.
11. Strengthened strategic planning and presentation skill.
12. Enhanced communication skills.

💻 Installation and Usage

• Microsoft Excel

📈 Dashboard