An interactive Power BI dashboard analyzing retail sales performance across the United States, built on the Superstore Sales dataset (2019–2020). It tracks revenue, profit, and quantity trends across regions, categories, and payment modes, and includes a 15-day sales forecast.
This project turns raw retail transaction data into a decision-ready dashboard for tracking sales performance. It highlights KPIs, regional and category trends, and payment behavior, and forecasts short-term sales using Power BI's built-in trend forecasting.
Objective: Transform raw transactional sales data into an interactive dashboard that surfaces performance trends across products, regions, and customer segments — enabling faster, data-driven decisions.
Source: SuperStore_Sales_Dataset.csv
| Detail | Value |
|---|---|
| Records | 5,901 transactions |
| Time period | Jan 2019 – Dec 2020 |
| Customers | 773 unique customers across 49 states |
| Fields | Order ID, Order Date, Ship Date, Ship Mode, Customer, Segment, Region, State, Category, Sub-Category, Sales, Quantity, Profit, Payment Mode |
- Power BI Desktop — dashboard development
- Power Query — data cleaning and transformation
- DAX — custom measures (Sales, Profit, Quantity, Avg. Delivery Days)
- Imported and cleaned the raw CSV data using Power Query
- Built DAX measures for Sales, Profit, Quantity, and Avg. Delivery Days
- Designed KPI cards and visuals for category, region, and payment-mode breakdowns
- Added a geographic map view for sales distribution
- Applied Power BI's built-in forecasting to project a 15-day sales trend
- KPI cards: Total Sales, Quantity, Profit, Avg. Ship Days
- Sales by Category, Sub-Category, and Ship Mode
- Monthly Sales & Profit trend (stacked area charts)
- Geographic sales distribution (map)
- Sales by Payment Mode and Region (donut charts)
- 15-day sales forecast using Power BI's built-in trend forecasting
- Sales by State breakdown
- Total sales of $1.57M with a profit of $175K across 22,317 units sold
- The West region leads in sales ($522K), followed by East ($450K), Central ($341K), and South ($252K)
- Office Supplies is the top-performing category ($644K), ahead of Technology ($471K) and Furniture ($452K)
- Cash on Delivery (COD) is the most-used payment mode by sales value ($667K), followed by Online ($554K) and Cards ($344K)
- Clone this repository
git clone https://github.com/ashgithub0208/Super-Sales-Dashboard.git - Open
SuperSalesDashboard.pbixin Power BI Desktop - If prompted, point the data source to
SuperStore_Sales_Dataset.csvin this repo - Refresh the data model to load the latest values
- Add customer segmentation (RFM analysis)
- Extend forecast horizon with confidence intervals
- Add drill-through pages for product-level detail