1. Overview of Superstore Sales Dataset:

• Total number of orders
• Total sales
• Average profit

2.Sales Performance Analysis:

• Identify top-selling products and categories
• Analyze sales trends and highlight significant patterns over the years

3.Customer Segmentation:

• Segment customers based on purchasing behaviour
• Understand which segments contribute most to sales

4. Shipping and Order Management:

• Evaluate the efficiency of different shipping modes
• Analyze shipping costs and their impact on overall profitability
• Assess order processing times and identify areas for improvement

5.Profitability and Cost Analysis:

• Analyze profit margins for different product categories and sub-categories
• Evaluate the impact of discounts on overall profitability
• Identify products or regions requiring cost optimization

6.Global Sales/Product Quantity Overview:

• Analyze the distribution of sales across different countries

7.State-Level Category Exploration:

• Understand the most-used product categories in different states

8.Regional Sub-Category Analysis:

• Analyze the popularity of sub-categories in different regions

Tools Used

• SQL for analyzing business problem statement
• Power BI for visualization of business problem statement
• Word document for documentation