📊 Sales & Profit Analytics Dashboard – Superstore Dataset

Exploratory Data Analysis (EDA) and Business Intelligence project analyzing sales, profit, and shipping performance across U.S. regions using Python and Tableau.

📌 Project Overview

Retail companies require clear visibility into:

• Regional revenue performance
• Profit margins across product categories
• Shipping efficiency
• Discount impact on profitability

This project performs comprehensive exploratory data analysis on the Superstore dataset and develops business-driven insights to support strategic pricing and operational decisions.

🎯 Business Objectives

• Identify high-performing and underperforming regions
• Analyze profit margins by category and sub-category
• Detect revenue gaps across geographic locations
• Evaluate the relationship between discounts and profit
• Assess shipping patterns and their operational impact

📂 Dataset Information

Dataset: Superstore Dataset

Key Features:

• Order Date
• Ship Date
• Ship Mode
• Region
• State
• Category
• Sub-Category
• Sales
• Profit
• Discount
• Quantity

🔎 Exploratory Data Analysis (EDA)

1️⃣ Regional Performance Analysis

• Compared total revenue across U.S. regions.
• Identified a 12% revenue gap between East and West regions, supporting potential pricing and marketing adjustments.

2️⃣ Profit Margin Evaluation

• Calculated profit ratios by category and sub-category.
• Detected high-revenue categories with low profitability.
• Highlighted negative-profit cases linked to excessive discounting.

3️⃣ Discount Impact Analysis

• Analyzed the correlation between discount percentage and profit.
• Found that higher discounts often lead to margin erosion in specific product segments.

4️⃣ Shipping Performance

• Evaluated distribution of shipping modes.
• Analyzed operational implications of shipping choices.
• Identified patterns affecting delivery performance and cost.

5️⃣ Time-Based Trend Analysis

• Monthly and yearly sales trends.
• Seasonal demand patterns.
• Profit fluctuations over time.

📊 Dashboard Development (Tableau)

Built interactive Tableau dashboards to:

• Visualize regional sales distribution
• Highlight top-performing categories
• Detect low-margin product segments
• Support executive-level decision-making

The dashboard enables dynamic filtering by:

• Region
• Category
• Ship Mode
• Time period

🤖 Automated Reporting (Python)

Implemented automated monthly reporting using:

• Pandas for aggregation
• Matplotlib for visualization
• Summary KPI extraction

This reduces manual reporting effort and enables faster monthly reviews.

📈 Key Insights

• 📉 12% revenue gap between East and West regions
• ⚠ Certain categories generate high sales but low profit margins
• 💸 Excessive discounts negatively impact profitability
• 🚚 Standard shipping dominates usage patterns
• 📅 Clear seasonal patterns in revenue performance

🛠 Tech Stack

• Python
• Pandas
• NumPy
• Matplotlib
• Seaborn
• Tableau