Skip to content

A high-level overview designed for decision-makers – capturing key KPIs like total revenue, profit, sales trends, and performance by region at a glance.

License

Notifications You must be signed in to change notification settings

Mudassir-A/AdventureWorks-Bike-Store-Sales-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 

Repository files navigation

🚴 AdventureWorks Bike Store Sales Analysis – Power BI Dashboard

This repository contains my Power BI dashboard project built on the AdventureWorks Bike Store dataset. The dashboard provides a complete sales analysis with interactive visuals, filters, and KPIs tailored for decision-making.

📽️ Demo Video:

Demo Video Link


📊 Dashboard Overview

The dashboard is designed with four interactive pages:

1️⃣ Executive Dashboard

  • High-level overview for decision-makers
  • KPIs: Total Revenue, Profit, Sales Trends, Regional Performance

2️⃣ Map View

  • Store performance visualized geographically
  • Dynamic filtering by continents for spatial sales insights

3️⃣ Product Details

  • Deep dive into product categories and types
  • Sales performance & inventory metrics
  • Identifies top-performing and underperforming products

4️⃣ Customer Details

  • Customer segmentation and behavior analysis
  • Demographics, purchase patterns, income, and occupation filters

🛠️ Features Implemented

✔️ Dynamic Slicers for interactivity
✔️ Custom Visuals for enhanced storytelling
✔️ Responsive layout across all pages
✔️ Drill-down & filtering for detailed insights
✔️ Designed from scratch for real-world business analysis


🚀 Tech Stack

  • Power BI Desktop
  • AdventureWorks Bike Store Dataset

📂 Repository Structure


.
├── assets/
│   └── video.mp4      # Dashboard demo video
├── Dashboard.pbix     # Power BI project file
├── README.md          # Project documentation


🎯 Key Learning Outcomes

  • Hands-on practice with Power BI visualization & reporting
  • Understanding business KPIs and decision-making metrics
  • Creating interactive, responsive, and insight-driven dashboards

🔮 Future Improvements

  • Automating dataset refresh with SQL/Excel integration
  • Adding predictive analytics (e.g., sales forecasting)
  • Deployment to Power BI Service for web sharing

🙌 Acknowledgements

  • Dataset: AdventureWorks Bike Store (Microsoft Sample Data)
  • Tools: Power BI Desktop

Would you like me to also make a shorter, portfolio-style version of this README (just highlights + video + features) so that recruiters scrolling your repo can grasp it in <30 seconds?

About

A high-level overview designed for decision-makers – capturing key KPIs like total revenue, profit, sales trends, and performance by region at a glance.

Resources

License

Stars

Watchers

Forks