🧭 Adventure Works Power BI Dashboard 📊 Project Overview
This project showcases an interactive Power BI dashboard built using the Adventure Works dataset, a widely used sample database by Microsoft. The dashboard delivers a comprehensive analysis of sales, profit, and product performance across regions and categories.
It was developed as part of a portfolio project to demonstrate skills in data visualization, business intelligence, and storytelling with Power BI.
🎯 Objectives
Transform raw Adventure Works data into actionable business insights.
Build an executive dashboard summarizing key KPIs.
Use data visuals to reveal performance patterns and growth opportunities.
⚙️ Tools & Technologies
Power BI Desktop – for visualization and data modeling
Power Query – for data transformation and cleaning
DAX (Data Analysis Expressions) – for calculated measures and KPIs
AdventureWorksDW Dataset – as the core data source
🧩 Skills Demonstrated
Data modeling and relationship management
DAX measure creation (YTD, Profit Margin, Return Rate)
Dashboard design and visualization layout
KPI tracking and performance benchmarking
Data storytelling and insight presentation
📈 Key Insights
Total Revenue: $24.91M | Profit: $10.46M | Orders: 25.2K | Return Rate: 2.2%
Revenue Trend: Steady growth from 2020–2022, with a sharp rise after mid-2021.
Top Category: Bikes lead with ~45% of total orders, followed by Clothing (37%) and Accessories (18%).
Best-Selling Products:
Water Bottle – 30 oz and Mountain-200 Black show the strongest sales.
Tires and Tubes have consistent high demand.
Most Returned Product Type: Shorts, suggesting potential quality or sizing issues.
High Return Item: Road-650 Red products have the highest return rate (~11%).
Regional Insights:
North America and Europe generate the highest profit and order volumes.
Pacific region presents growth opportunities.
Monthly Performance:
Revenue exceeded the target by +3.3% ($1.83M vs $1.77M).
Orders slightly below target (-0.9%).
Returns lower than expected (-1.2%).
Customer Behavior: Increased revenue despite fewer orders — indicates higher average order value.
Business Takeaway: Premium bike segments drive profitability; lowering returns and expanding in emerging regions can boost growth further.
Business storytelling through visuals
Data-driven decision analysis