- Problem Statement
- Objective
- Tools Used
- Dataset Overview
- Key Findings
- Recommendations
- Project Presentation
- Project Learnings
- Installation and Usage
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, recognizing top-performing regions, and identifying top customers. Additionally, we need to understand the financial impact of discounts to enhance our profit margins.
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, we aim to:
- Identify best-selling products and high-revenue generators.
- Assess total revenue and profit margins to gauge financial health.
- Understand the impact of shipping methods, category, customer segments, and discounts on sales.
- Develop targeted strategies to reduce losses and enhance customer satisfaction.
- Data source: Internet
- Time period: 2014-2017
- Data size: Orders Table (5009,22), Returns Table (296,2)
- Data set Link
- Total sales: $9.79M
- Profit margin: 2.88%
- Best-selling product: Canon image CLASS 2200 Advanced Copier
- Preferred shipping mode: Standard class
- Regional performance: East and West regions outperform others
- Product categories: Technology leads in sales
- Customer segments: Consumer segment accounts for half of total sales
- Top customers: Adrian Barton, Tamara Chand, Kelly Collister, and Sean Miller
- 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
- Most profitable product: Xerox 20 leads in profit margin
- Optimize inventory and marketing for top-performing products
- Focus on expanding in high-performing regions (East and West) while developing strategies for underperforming areas
- Reevaluate the discounting strategy to minimize losses and maximize profitability
- Capitalize on the strong performance during the last quarter with targeted marketing campaigns and adequate inventory
- Maintain the success of non-discounted products while gradually adjusting strategies for other items
- Enhance the performance of other shipping modes to balance out the heavy reliance on Standard class
- Create tailored loyalty programs and personalized marketing for top customers in each segment
The detailed presentation slides for this project can be found here
- Creating new schema and table.
- Data cleaning (fixing date).
- Group by.
- Common Table Expressions (CTE).
- Window function.
- Data storytelling.
- Sharpened analytical and problem-solving abilities.
- Strengthened strategic planning and presentation skill.
- Enhanced communication skills.
- Actionable Insights Generation.
- Open MySQL Workbench
- Create new schema
- Create new table
- Import CSV into the table