Skip to content

About

Created a sales performance dashboard for a company to monitor key metrics such as total sales, profit, and growth over time. Use Tableau to create an interactive dashboard that visualizes the sales data.

Resources

Stars

0 stars

Watchers

1 watching

Forks

Latest commit

 

History

7 Commits

Folders and files

Repository files navigation

☕ Coffee Chain Analysis Dashboard (Excel)

Tool Used: Microsoft Excel
Date: January 2025

📊 Overview

This project presents an interactive Excel dashboard built to analyze sales performance and profitability for a national coffee chain. Using advanced Excel features such as PivotTables, slicers, and dynamic charts, the dashboard provides a comprehensive overview of operations across regions and product categories.

🎯 Objectives

  • Identify top-performing regions and products
  • Uncover trends in sales, profit, and quantity sold
  • Enable quick decision-making through interactive elements

🧰 Features

  • ✅ Interactive slicers (Region, Product Type, Segment)
  • 📊 Dynamic charts for Sales, Profit, and Quantity
  • 🏆 Top 5 and Bottom 5 products by profit
  • 📍 Region-wise performance breakdown
  • 🧮 KPIs with conditional formatting

📁 Files

  • Coffee_Chain_Analysis_Dashboard.xlsx – Fully interactive Excel workbook

📸 Screenshot

image

📈 Sample Insights

  • West Region leads in overall sales but has lower profit margins
  • Espresso beverages show consistent high profitability
  • Opportunities found in underperforming Central region stores

📌 How to Use

  1. Open the Coffee_Chain_Analysis_Dashboard.xlsx file in Excel
  2. Use the slicers to filter data by region, product type, or customer segment
  3. Hover over charts to view tooltips and data points
  4. Review KPIs and tables for high-level insights

📊 Sales Dashboard using Power BI

Tool Used: Power BI
Date: March 2025

🚀 Overview

This project presents a dynamic and interactive sales dashboard built in Power BI to analyze company-wide sales performance. The dashboard enables users to drill down into key metrics, explore regional and product-level trends, and uncover insights that support data-driven decision-making.

🎯 Objectives

  • Monitor key performance indicators (KPIs) across time
  • Identify high and low-performing regions, categories, and segments
  • Enable interactive filtering and visual exploration of the data

🧰 Features

  • 📈 KPI cards for Sales, Profit, and Quantity Sold
  • 🌍 Region-wise and State-wise performance maps
  • 📊 Category & Sub-Category trend analysis
  • ⏳ Time-based filters (Year, Quarter, Month)
  • 🔍 Drill-through pages and tooltips for deeper insights
  • 📌 Dynamic slicers for customer segment, region, and category

📁 Files Included

  • SalesDashboard.pbix – Power BI Dashboard file
  • (Optional) SalesData.csv – Cleaned dataset used for analysis
  • (Optional) Screenshots/Preview images

📸 Dashboard Preview

image

📈 Sample Insights

  • The West region consistently drives the highest revenue.
  • Office Supplies has the lowest profit margins across most segments.
  • Q4 shows peak sales activity, suggesting seasonal trends.
  • High customer churn in the Consumer segment signals room for loyalty programs.

🔍 How to Explore

  1. Open SalesDashboard.pbix in Power BI Desktop
  2. Use the slicers on the report to filter by Region, Segment, or Time
  3. Hover over charts and maps for additional tooltips and breakdowns
  4. Navigate between report pages for specialized views (e.g., Category Trends, Profitability)

📦 Superstore Sales Analysis using Tableau

Tool Used: Tableau
Date: November 2025

🧾 Overview

This project presents a comprehensive and interactive sales analysis dashboard built in Tableau using the Superstore dataset. It provides key insights into profit trends, regional performance, customer demographics, and product-level analysis.

The dashboard is designed to help business stakeholders quickly identify growth opportunities, understand market trends, and make informed, data-driven decisions.

🎯 Objectives

  • Analyze over 5,000 sales transactions
  • Identify 10% profit growth opportunities
  • Understand customer behavior and market trends across regions and categories
  • Visualize performance using intuitive charts and maps

💡 Features

  • 📍 Interactive Filters (Region, Segment, Category, Year)
  • 📈 Dynamic Visuals – Bar charts, line graphs, maps, and KPI cards
  • 🔎 Drill-down Capabilities – Deep dive into Sub-Category and Product-Level insights
  • 🧭 Regional Analysis – Performance heatmap across US states
  • 👥 Customer Demographic View – Segment-level profitability

📁 Files Included

  • Superstore_Dashboard.twbx – Tableau Workbook (Packaged)
  • (Optional) Sample_Superstore_Data.csv – Cleaned dataset

📸 Dashboard Preview

image

📈 Key Insights

  • West Region generated the highest overall sales but had inconsistent profit margins
  • Technology category performed best across all segments
  • Certain Sub-Categories like Tables and Bookcases showed high sales but negative profit
  • Strong seasonal trends identified in Q4 across all regions

🧭 How to Explore

  1. Open Superstore_Dashboard.twbx in Tableau Desktop (or Tableau Public)
  2. Use filters to explore sales by Region, Category, or Segment
  3. Hover over charts for tooltips and detailed breakdowns
  4. Switch between dashboard views for Product, Regional, and Time analysis

📬 Contact

For questions, feedback, or collaboration, feel free to reach out:

About

Created a sales performance dashboard for a company to monitor key metrics such as total sales, profit, and growth over time. Use Tableau to create an interactive dashboard that visualizes the sales data.

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors