This repository showcases an interactive Power BI dashboard built using the AdventureWorks dataset as part of the Microsoft Power BI Desktop course by Maven Analytics.
The dashboard provides a comprehensive, multi-page analysis of business performance, enabling users to explore revenue trends, customer insights, product profitability, and regional performance through dynamic, data-driven visuals.
The goal of this project is to analyze AdventureWorks' sales and profitability performance using Power BI. Through calculated DAX measures and visual storytelling, the dashboard helps identify key business trends, track KPIs, and support data-driven decision-making.
- Microsoft Power BI Desktop
- DAX (Data Analysis Expressions)
- AdventureWorks Sample Dataset
- Data Modeling and Relationship Building
- Interactive Visualizations and Drill-Throughs
This Power BI dashboard provides a comprehensive overview of AdventureWorks' key business metrics, enabling stakeholders to monitor performance, identify trends, and explore product-level insights.
- Top-Level KPIs
- Revenue: $24.9M
- Profit: $10.5M
- Orders: 25.2K
- Return Rate: 2.2%
- Revenue & Profit Trend – Dual-line chart showing monthly revenue and profit (Jan–Dec 2022), highlighting consistent growth.
- Orders by Category – Bar chart displaying order distribution:
- Accessories (13.7K)
- Bikes (7.3K)
- Clothing (4.1K)
(Hover to see details via tooltip.)
- Monthly Metrics Comparison
- Revenue: $1.83M (↑ from $1.77M)
- Orders: 2.15K (↓ from 2.81K)
- Return Rate: 166% (↓ from 176%)
- Top 10 Products Matrix – Interactive product-level data with order count, revenue, and return rate. Drill-through enabled by right-clicking on Product Name.
- Product Type Highlights – Most Ordered: Tires and Tubes | Most Returned: Tires and Tubes
To support data-driven decision-making by surfacing high-impact KPIs and enabling granular product-level exploration for profitability, return analysis, and category insights.
An interactive Power BI map visual showcasing AdventureWorks' regional business performance across key markets. It provides a geographic breakdown of orders, customers, profit, returns, and revenue.
- Dark-themed world map with turquoise data points sized by metric magnitude.
- Regional segmentation via slicers: Select All, Europe, North America, Pacific.
- Example (United States):
- Total Orders: 8,700
- Customers: 7,235
- Profit: $3.45M
- Returns: 624
- Revenue: $7.84M
- Additional regions: Canada, UK, France, and Australia.
- Azure-powered visual layer for cloud scalability.
- Hover to reveal detailed metrics by country.
- Region-based filters for focused analysis.
To enable stakeholders to assess performance by country, identify high-performing regions, and prioritize strategic initiatives globally.
This page offers a focused view of a single product’s performance, enabling granular analysis of sales, profitability, and returns.
- Selected Product: Example – Water Bottle – 30 oz
- Monthly KPIs vs Targets
- Orders: 404
- Revenue: $4,067
- Profit: $2,546
- Visuals:
- Line chart: Total Profit vs Adjusted Profit
- Return % Over Time
- Interactive Price Adjustment Simulation (−10% to +10%)
- Metric Selector: Toggle between Orders, Revenue, Profit, and Returns
- Tooltip Summary: Highlights peak return dates and profit changes
- Change the product via filter pane
- Drill through from the Executive Summary matrix for direct access
Empowers product managers and analysts to evaluate product performance, test pricing strategies, and monitor return behavior for informed decision-making.
This dashboard explores customer behavior and revenue generation patterns to help identify high-value customers and guide engagement strategies.
- Top-Level Metrics
- Revenue per Customer: $1.4K
- Unique Customers: 17.4K
- Customer Revenue Trend: Line chart (July 2020–July 2022)
- Demographic Insights:
- Orders by Income Level (High, Medium, Low)
- Orders by Occupation (Skilled Manual, Management, Clerical)
- Top 100 Customers Table:
- Columns: Customer Key, Full Name, Orders, Revenue
- Highlights:
- Mr. Maurice Shan: 6 Orders, $12,408 Revenue
- Ruben Suarez: $4,680 Revenue (Skilled Manual)
- Filters: Quick year selection between (2020 - 2022)
- Explore customer-level data via slicers and filters
- Complements other dashboards with a customer-centric focus
Supports marketing and sales teams by revealing top customers, revenue sources, and behavioral trends for segmentation and strategic planning.
This project uses over 30 custom DAX measures to calculate and visualize KPIs including:
- Sales & Returns:
[Quantity Sold],[Quantity Returned],[Total Returns] - Financials:
[Total Revenue],[Total Profit],[Average Retail Price],[Revenue Target] - Rolling Metrics:
[10 Day Rolling Revenue],[90 Day Rolling Profit] - Performance Indicators:
[Order Target],[Profit Target],[Target Gaps] - Adjustments:
[Adjusted Price],[Adjusted Profit],[Adjusted Revenue]
(Full list of DAX formulas included in this repository.)
| File | Description |
|---|---|
Crystal_Maven_AdventureWorks_PBI_DB.pdf |
Dashboard overview (PDF export) |
Maven_AdventureWorks_PBI_Course.pbix |
Power BI Dashboard (.pbix) |
DAX_Measures_List.xlsx |
DAX calculations used in the model |
Crystal Maven PBI Course - Consolidated |
Consolidated PDF of My Certificate, Badge and Score |
README.md |
Documentation file (this file) |
This Power BI project demonstrates how data modeling, DAX, and visual design can transform raw sales data into actionable insights. The dashboard highlights AdventureWorks’ performance story through clear, interactive visuals that help drive strategic business decisions.
