Skip to content

katerinaharana/Superstore

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

6 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Œ Live Dashboard Link

πŸ”—**Click here to view the live report**


πŸ“Š Superstore Sales Dashboard & Forecast Report

This Power BI project analyzes sales data from a Superstore dataset. It provides interactive visuals and insights into business performance across segments, categories, time periods, and geographies β€” plus a 15-day forecast with seasonal trends.


πŸ“Œ Overview of the Report

The dashboard is organized into multiple interactive pages, each accessible via navigation buttons:

Section Description
Overview KPIs and sales by segment, category, and region
Region Sales performance by state, city and region, with profit and growth comparison
Product Insights into sub-categories, best/worst products, and profit contribution
Seasonality Seasonal trend breakdown and top-performing time periods. 15 day forecast

πŸ’‘ Key Metrics

  • Total Sales: 1.34M
  • Total Profit: 174.30K
  • Total Transactions: 3,000
  • Gross Margin: 0.13
  • YoY Sales Growth: 1.20

🎯 Features

  • Interactive slicers for Year, Segment, Category, Ship Mode, Region
  • Reset all filters button on each page
  • Forecast with adjustable seasonality
  • Card metrics for Top 3 Days, Weeks, Months
  • Color-coded charts and dynamic filters
  • Export-ready layout for clean PDF or print view

πŸ›  Tools & Techniques

  • Power BI Desktop
  • DAX for KPIs and ranking (TopN, CONCATENATEX)
  • Power Query for data cleaning
  • Forecasting via analytics pane with custom seasonality

About

Superstore Sales Analysis with PowerBI

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published