AdventureWorks Sales Performance Dashboard (Power BI)

📊 Project Overview

This Power BI dashboard analyzes sales performance for AdventureWorks, providing deep insights into revenue, profit, order trends, product performance, and customer segmentation across regions.

The project was developed as part of the Microsoft Power BI Desktop course by Maven Analytics on Udemy. I independently rebuilt the report from scratch, using the AdventureWorks dataset, to apply and reinforce my learning on data modeling, DAX, and visual storytelling.

💡 Key Insights

• Total Revenue: $24.9M
• Total Profit: $10.5M
• Orders: 25.2K
• Return Rate: 2.2%

🔄 Monthly Highlights

• Revenue Growth: +3.3% month-over-month
• Orders: Slight decline (-0.88%)
• Returns: Small increase (+1.78%)

🛍️ Product Insights

• Most Ordered: Water Bottle - 30 oz. (3,983 orders)
• Top Return Rate: Shorts (4.24%)

👥 Customer Breakdown

• Unique Customers: 17.4K
• Revenue per Customer: $1,431
• Top Segments: Professionals and Skilled Manual workers

🌍 Market Regions

• Sales span across the United States, Canada, UK, Australia, France, and Germany

🧰 Tools & Techniques

• Power BI Desktop
• Power Query for data shaping
• DAX for calculated measures and time intelligence
• Smart Narrative & Key Influencers visuals
• Data modeling with multiple fact and dimension tables

📁 Project Files

• AdventureWorks-Sales-Performance.pbix – Main dashboard file
• AdventureWorks Report.pdf – PDF export of the dashboard
• README.md – Project documentation
• dashboard-preview.png – Visual preview (optional)

📎 Notes

• Data is synthetic (AdventureWorks sample) and used for educational purposes only
• All design, modeling, and calculations were implemented by me during the course project
• Focus areas: Revenue analytics, product insights, customer segmentation, and performance tracking