Skip to content

Abhijeet107/Task-4

Repository files navigation

Task-4

Design an interactive dashboard for business stakeholders.

📊 Interactive Sales Dashboard - Tableau

Welcome to the Interactive Sales Dashboard project!
This dashboard was created using Tableau to provide business stakeholders with a comprehensive view of sales performance across various dimensions including time, region, product category, and customer behavior.


📁 Project Overview

This dashboard enables users to:

  • Monitor Total Sales, Quantity Sold, and Average Discount
  • Identify Top Performing Regions and Products
  • Analyze Sales Trends Over Time
  • Visualize Customer & Payment Insights
  • Track Sales by Region and Sales Representatives
  • Apply dynamic filters (Date, Region, Product Category)

🛠️ Tools & Technologies

  • Tableau Desktop
  • Microsoft Excel / CSV (for data source)
  • Data Visualization & Interactive Filters

📸 Dashboard Highlights

Screenshot 2025-04-11 124255

🎯 KPIs

  • Total Sales: ₹5,019,265
  • Quantity Sold: 25,355 Units
  • Average Discount: 15.24%
  • Top Performing Region: North

📈 Visual Components

  • Line Chart – Sales Trend Over Time
  • Pie Chart – Payment Method Breakdown
  • Bar Charts – Product Performance by Region
  • Rep-wise Sales Comparison
  • Interactive Filters for date, region, and product category

🧠 Key Insights

  • North is the highest-performing region.
  • Clothing and Food lead in sales among product categories.
  • Payment methods are diversely distributed between Credit Card, Bank Transfer, and Cash.
  • Sales reps' performance shows regional variation, allowing for targeted team evaluation.

📌 How to Use

  1. Open the .twbx Tableau dashboard file in Tableau Desktop.
  2. Use the slicers to filter by:
    • Sale Date Range
    • Region
    • Product Category
  3. Hover or click on visuals for interactivity and tooltips.
  4. Drill down for granular insights by rep, region, or category.

📥 Data Source


🚀 Future Enhancements

  • Add Profit Margin & Customer Lifetime Value (CLV) analysis
  • Deploy on Tableau Public / Tableau Server
  • Include Top N Region Slicer and forecasting models
  • Add Geospatial Maps for visual regional insights

👨‍💻 Author

Abhijeet Kuanr
📧 [email protected]
🔗 [# 📊 Interactive Sales Dashboard - Tableau - https://public.tableau.com/app/profile/abhijeet.kuanr/viz/InteractiveSalesDashboard_17443552413880/Dashboard1]

Welcome to the Interactive Sales Dashboard project!
This dashboard was created using Tableau to provide business stakeholders with a comprehensive view of sales performance across various dimensions including time, region, product category, and customer behavior.


📁 Project Overview

This dashboard enables users to:

  • Monitor Total Sales, Quantity Sold, and Average Discount
  • Identify Top Performing Regions and Products
  • Analyze Sales Trends Over Time
  • Visualize Customer & Payment Insights
  • Track Sales by Region and Sales Representatives
  • Apply dynamic filters (Date, Region, Product Category)

🛠️ Tools & Technologies

  • Tableau Desktop
  • Microsoft Excel / CSV (for data source)
  • Data Visualization & Interactive Filters

📸 Dashboard Highlights

🎯 KPIs

  • Total Sales: ₹5,019,265
  • Quantity Sold: 25,355 Units
  • Average Discount: 15.24%
  • Top Performing Region: North

📈 Visual Components

  • Line Chart – Sales Trend Over Time
  • Pie Chart – Payment Method Breakdown
  • Bar Charts – Product Performance by Region
  • Rep-wise Sales Comparison
  • Interactive Filters for date, region, and product category

🧠 Key Insights

  • North is the highest-performing region.
  • Clothing and Food lead in sales among product categories.
  • Payment methods are diversely distributed between Credit Card, Bank Transfer, and Cash.
  • Sales reps' performance shows regional variation, allowing for targeted team evaluation.

📌 How to Use

  1. Open the .twbx Tableau dashboard file in Tableau Public.
  2. Use the slicers to filter by:
    • Sale Date Range
    • Region
    • Product Category
  3. Hover or click on visuals for interactivity and tooltips.
  4. Drill down for granular insights by rep, region, or category.

📥 Data Source

  • The dashboard uses a sample sales dataset containing:
    • Order Date
    • Region
    • Product Category
    • Sales Amount
    • Quantity
    • Customer Type
    • Payment Method
    • Sales Rep

🚀 Future Enhancements

  • Add Profit Margin & Customer Lifetime Value (CLV) analysis
  • Deploy on Tableau Public / Tableau Server
  • Include Top N Region Slicer and forecasting models
  • Add Geospatial Maps for visual regional insights

👨‍💻 Author

Abhijeet Kuanr
📧 [email protected]
🔗 www.linkedin.com/in/abhijeet-kuanr-6a2672160


📄 License

This open-source project is available under the MIT License.

Releases

No releases published

Packages

No packages published