AdventureWorks-Sales-Analysis---Power-BI-Dashboard

This Power BI project analyzes the AdventureWorks dataset to uncover key business insights related to sales performance, customer demographics, and product categories. It simulates a real-world business intelligence dashboard used by decision-makers to track KPIs and optimize strategies.

🔍 Project Objective

🔍 Project Objective

To create an interactive and dynamic Power BI dashboard using the AdventureWorks dataset, focusing on:

• Sales performance by region, product, and time
• Customer segmentation
• Product category trends
• Profitability analysis

📂 Dataset

• Source: Microsoft AdventureWorks (sample database)
• Data Size: Multiple tables (Sales, Customers, Products, Geography, Calendar)
• Data Type: Relational data

🧪 Data Preparation

• Data imported using Power Query
• Relationships defined in the data model
• Created custom columns and measures using DAX
• Cleaned and transformed tables (e.g., formatted dates, handled missing values)

📊 Key Visuals

• 📍 Sales by Country and State (Map)
• 📆 Monthly Revenue Trend (Line Chart)
• 🎯 Top 10 Products by Sales
• 👤 Customer Demographics (Age Group, Gender)
• 📦 Product Category Profitability
• 📈 KPIs: Total Sales, Profit, Orders

⚙️ Tools & Technologies

• Power BI Desktop
• DAX (Data Analysis Expressions)
• Power Query
• Git & GitHub

📁 Files in this Repo

File Name	Description
AdventureWorks1.pbix	Main Power BI report
README.md	Project description

📬 Connect with Me

• 🔗 LinkedIn

📌 Future Improvements (working on it)

• Add forecasting with Power BI's analytics pane
• Integrate with R or Python scripts