A Power BI dashboard that analyzes Superstore sales and profit across years, categories, segments, and regions, with interactive filters and insights for data-driven decisions.
This project presents an interactive Power BI dashboard built using the popular Superstore dataset.
The report provides a complete breakdown of Sales, Profit, and Quantity across different dimensions such as Regions, Categories, Segments, Sub-Categories, and Years.
It is designed to help businesses quickly identify profit-driving areas, underperforming categories, and regional performance patterns.
- Analyze overall Sales, Profit, and Quantity metrics.
- Understand year-over-year profit trends.
- Evaluate profit distribution across:
- Segments (Consumer, Corporate, Home Office)
- Categories & Sub-Categories
- Regions (West, East, Central, South)
- Provide an interactive filtering experience for deeper business insights.
- Microsoft Power BI – Data cleaning, modeling, and visualization
- DAX (Data Analysis Expressions) – Calculations and measures
- Superstore Dataset – Source data for analysis
- 2.30M in Total Sales
- 286.40K Total Profit
- 38K Total Quantity Sold
- Yearly profit showed a steady upward growth from 2016 to 2019.
- Consumer Segment generated the highest profit contribution (~46%).
- Technology category led with the highest profit (~50%).
- Sub-categories like Copiers, Phones, Accessories drove the most profit.
- West Region contributed the largest share of profit (~37%).
- South Region accounted for the lowest share.
- Dynamic Slicers for State-level filtering
- KPIs for Sales, Profit & Quantity
- Bar Charts for Sub-Category Profit
- Donut Charts for Segment, Category, and Regional comparison
- Profit Trend Line across years
- Detailed Tabular View of Sub-Category-wise values across Regions
