A dynamic Power BI dashboard analyzing revenue, budget variances, and product trends across regions and time periods—designed for data-driven decision-making.
The Adventure Works Dashboard is an interactive Power BI report that transforms raw sales data into actionable insights. It compares actual sales against budgets, identifies top-performing products and customers, and uncovers regional trends. Built for sales managers, financial analysts, and executives, this tool answers critical questions like:
- Which products drive the most revenue?
- Where are we exceeding or falling short of the budget?
- How do sales trends vary by region or season?
📊 Power BI Desktop: Primary platform for visualization and report design.
🔧 Power Query: Cleaned and reshaped data (e.g., unpivoted budget tables, standardized dates).
🧮 DAX: Measures like Sales Variance %, YTD(Year-To-Date) Growth, and dynamic rankings.
🔗 Data Modeling: Star schema with relationships between Sales, Products, Territories, and Calendar tables.
📁 File Formats: .pbix (Power BI project) + .png (dashboard previews).
Source: Microsoft’s Adventure Works sample database (fictional but realistic retail data).
Datasets:
- Sales: 60K+ transactions (2016–2017) with revenue, quantities, and order dates.
- Products: 500+ items with categories, subcategories, and pricing tiers.
- Budget: Monthly targets by product and region.
- Calendar: Time intelligence for YoY and MoM comparisons.
Adventure Works lacks a unified view of:
- Real-time sales vs. budget performance.
- Regional profitability and product trends.
- Seasonal patterns affecting inventory and staffing.
- Provide at-a-glance KPIs (revenue, variance, top products).
- Enable drill-down analysis by region, time, or product category.
- Highlight anomalies (e.g., underperforming regions).
📊 Key Metrics (Cards)
- Total Sales: $29M | Budget Variance: -$1.2M (4% under)
- Top Category: Bikes (62% of revenue) | Best Region: North America ($12M)
🌍 Sales by Region (Map + Bar Chart)
- Interactive map color-coded by revenue.
- Bar chart ranks territories (e.g., North America > Europe > Pacific).
📈 Monthly Sales vs. Budget (Line + Column Chart)
- Columns: Actual sales. Line: Budget targets.
- Red highlights show months below target.
🏆 Top 10 Products & Customers (Tables)
- Filter by category (e.g., Mountain Bikes generate 35% of revenue).
⏳ Time Intelligence (Slicers)
- Compare YTD, QTD(Quarter-To-Date), or custom date ranges.
- Cost Control: Immediate visibility into budget deviations.
- Inventory Optimization: Focus procurement on top-selling products (e.g., Road Bikes in Q2).
- Strategic Growth: Allocate marketing spend to underperforming regions (e.g., APAC).
