Tool Used: Microsoft Excel
Date: January 2025
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.
- Identify top-performing regions and products
- Uncover trends in sales, profit, and quantity sold
- Enable quick decision-making through interactive elements
- ✅ 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
Coffee_Chain_Analysis_Dashboard.xlsx– Fully interactive Excel workbook
- West Region leads in overall sales but has lower profit margins
- Espresso beverages show consistent high profitability
- Opportunities found in underperforming Central region stores
- Open the
Coffee_Chain_Analysis_Dashboard.xlsxfile in Excel - Use the slicers to filter data by region, product type, or customer segment
- Hover over charts to view tooltips and data points
- Review KPIs and tables for high-level insights
Tool Used: Power BI
Date: March 2025
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.
- 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
- 📈 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
SalesDashboard.pbix– Power BI Dashboard file- (Optional)
SalesData.csv– Cleaned dataset used for analysis - (Optional) Screenshots/Preview images
- 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.
- Open
SalesDashboard.pbixin Power BI Desktop - Use the slicers on the report to filter by Region, Segment, or Time
- Hover over charts and maps for additional tooltips and breakdowns
- Navigate between report pages for specialized views (e.g., Category Trends, Profitability)
Tool Used: Tableau
Date: November 2025
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.
- 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
- 📍 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
Superstore_Dashboard.twbx– Tableau Workbook (Packaged)- (Optional)
Sample_Superstore_Data.csv– Cleaned dataset
- 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
- Open
Superstore_Dashboard.twbxin Tableau Desktop (or Tableau Public) - Use filters to explore sales by Region, Category, or Segment
- Hover over charts for tooltips and detailed breakdowns
- Switch between dashboard views for Product, Regional, and Time analysis
For questions, feedback, or collaboration, feel free to reach out:
- GitHub: @yourusername
- LinkedIn: linkedin.com/in/yourname


