Skip to content

Architalaxman/Global-Superstore-Sales-Analysis-using-Power-BI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Global-Superstore-Sales-Analysis-using-Power-BI

This project focuses on analyzing the Global Superstore dataset using Power BI to generate meaningful insights about sales, profit, and customer behavior. The dashboard helps in understanding business performance across different regions, categories, and time periods.

📊 Global Superstore Sales Analysis (Power BI)

📌 Project Overview

This project presents an interactive Power BI dashboard built using the Global Superstore dataset. The aim is to analyze sales performance, profit trends, and customer behavior across different regions and categories.

The dashboard helps stakeholders make data-driven decisions by providing clear and interactive visual insights.


📁 Dataset Details

  • Dataset: Global Superstore
  • Includes:
    • Sales, Profit, Quantity
    • Customer Name & Segment
    • Product Category & Sub-category
    • Order Date & Ship Date
    • Region, State, City
    • Shipping Mode

🛠️ Tools & Technologies

  • Power BI
  • Power Query (Data Cleaning & Transformation)
  • DAX (Data Analysis Expressions)

📊 Dashboard Features

  • Interactive slicers (Region, Category, Year)
  • KPI Cards (Total Sales, Total Profit, Total Orders)
  • Sales trend analysis (Line Chart)
  • Category & Sub-category analysis (Bar Chart)
  • Profit distribution (Pie/Donut Chart)
  • Geographic visualization (Map)
  • Top 5 Customers analysis

🔍 Key Insights

  • Identified top-performing regions and products
  • Found most profitable categories
  • Analyzed customer contribution to revenue
  • Observed yearly sales growth trends
  • Compared shipping modes and delivery efficiency

📷 Dashboard Preview

(Add screenshots here)


🎯 Conclusion

This dashboard provides a comprehensive view of business performance and helps in identifying growth opportunities through visual analytics.


📌 How to Use

  1. Download the .pbix file
  2. Open it in Power BI Desktop
  3. Use filters and slicers to explore insights

🚀 Future Improvements

  • Add sales forecasting
  • Implement advanced DAX measures
  • Enhance UI/UX design

About

This project focuses on analyzing the Global Superstore dataset using Power BI to generate meaningful insights about sales, profit, and customer behavior. The dashboard helps in understanding business performance across different regions, categories, and time periods.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors