Skip to content

ABH1516/SuperStore_Sales_Dashboard

Repository files navigation

🛒 Super Store Sales & Forecast Dashboard

📍 Repository Description

Power BI dashboard analyzing Super Store sales performance with forecasting insights, KPIs, and interactive visuals to support data-driven business decisions.


📝 Project Overview

The Super Store Sales & Forecast Dashboard provides an analytical and predictive view of sales performance across multiple business dimensions such as regions, categories, segments, shipping modes, and states.
It enables organizations to track year-over-year growth, monitor profitability, and forecast sales for short-term planning.


🎯 Purpose

  • Visualize historical sales, profit, and quantity trends
  • Identify high-performing product categories, states & customer segments
  • Understand shipping performance and payment preferences
  • Forecast sales for upcoming 15 days using analytical trend modeling
  • Support strategic sales decision-making with data insights

🛠 Tech Stack

  • 📊 Power BI Desktop — interactive dashboard development
  • 📂 Power Query — data cleaning, transformation & merging
  • 🧠 DAX (Data Analysis Expressions) — KPIs & time-intelligence calculations
  • 🗃 Data Modeling — star schema & relationships
  • 📁 File Types.pbix, .png preview images

📈 Key Metrics (KPIs)

  • 1.6M — Total Sales
  • 175K — Total Profit
  • 22K — Total Quantity Sold
  • 4 — Total Number of Regions

✨ Features & Highlights

  • Monthly Sales & Profit YoY Comparison (2019 vs 2020)
  • Sales by Ship Mode — Standard Class highest contributor (0.91M)
  • Sales by Region — West (33%) leads followed by East, Central & South
  • Sales by Segment — Consumer segment leads at 48%
  • Payment Mode Distribution — COD (43%), Online (35%), Cards (22%)
  • Sales by Category & Sub-Category
  • Sales Per State Map Visualization
  • 15-Day Sales Forecast Model
  • Interactive Filters — Central, East, South, West

💡 Business Insights

  • Forecast reveals increasing sales trend entering the next 15 days
  • West & East regions dominate revenue share
  • Technology, Furniture & Office Supplies drive major profit
  • Consumer segment is the highest revenue generator
  • COD remains the most preferred payment method
  • Standard shipping is the most profitable mode

🔗 Live Dashboard Link

👉 https://app.powerbi.com/view?r=eyJrIjoiNWI3YzYxZDQtMzE3Ny00YzlkLWJiMTEtY2QxOWNmNjliM2NlIiwidCI6ImFmN2E0MGMwLWE4MWQtNGZkZi05ZTQwLTcwNzNjNzQ1NzI1NCJ9


🖼 Dashboard Preview

Super Store Sales Dashboard

Super Store Forecast Dashboard


📌 Tags

Power BI Sales Analytics Forecasting Business Intelligence Dashboard
Sales Insights Data Analytics DAX Power Query Interactive Reporting
Predictive Analysis Data Visualization

About

Interactive Power BI dashboard for Super Store sales analysis & short-term forecasting with KPIs, YoY trends, regional insights, and predictive modeling.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors