Adventure Works Sales Data Analysis Dashboard

📊 Advanced Excel Dashboard with PivotTables, Macros & Dynamic Visualizations

🔍 Overview

This project is a fully interactive Excel dashboard built using AdventureWorks dataset from Microsoft. It includes:
✔ Multi-sheet dynamic dashboards with slicers & macros
✔ Deep sales performance analysis (revenue, profit, customer trends)
✔ Time-series forecasting (weekly, quarterly, yearly trends)
✔ Customer segmentation (demographics, top buyers, gender analysis)
✔ Geographic & product-based insights (country performance, pricing categories)

---

📊 Key Insights from Analysis

1️⃣ Annual Sales Performance

📈 Total Revenue: $307.09M
💰 Profit Margin: 41.1%
🛒 Transaction Growth: 1.01K (2005) → 32.27K (2008)

2️⃣ Customer Segmentation

👥 Top 5 Customers: $351K (0.3% of total profit)
⚖️ Gender Split: 50.4% Female | 49.6% Male
🎂 Highest-Spending Age Group: 35-39 years ($16.93M)

3️⃣ Geographic Performance

🌎 Top Countries:

• United States ($41M)
• Australia ($39M)
• United Kingdom ($15M)

4️⃣ Product Profitability

💎 Expensive Products: $120.52M (95.4% of profits)
🛍️ Budget Products: $5.77M (4.6%)

---

🛠️ Technical Features

✅ PivotTables & PivotCharts – Dynamic data aggregation
✅ Excel Macros – Automated filtering & interactivity
✅ Slicers & Timelines – User-friendly navigation
✅ Conditional Formatting – Highlight key trends
✅ Data Model Relationships – Efficient analysis

---