Project Overview

Designed and developed a comprehensive KPI dashboard in Power BI to track critical business metrics across multiple dimensions including sales performance, product categories, geographic distribution, and channel effectiveness.

Key Features

• Multi-Dimensional Analysis Sales tracking by continent, product category, and sales channel
• Trend Visualization Year-over-year sales trends with interactive timeline
• Cost & Returns Monitoring Real-time tracking of total costs and return quantities
• Dynamic Filtering Year selection and multi-dimensional data exploration

DASHBOARD PREVIEW

KEY INSIGHTS & ANALYSIS

Geographic Performance • North America leads with $4.93bn in sales • Store channel dominates with $3.22bn • Catalog and online channels show significant contribution in Asian markets • Europe maintains balanced distribution across all sales channels

Trends & Product Performance • Sales declined from $3.14bn (2011) to $2.53bn (2013) • Computers lead product categories at 38% of total sales • Cameras and TV/Video represent significant secondary categories • Return rate of 0.88% indicates strong product quality

Action Item: Focus on reversing the downward sales trend through targeted marketing campaigns and channel optimization, particularly in the online segment which shows growth potential.

Project Impact

• Transformed complex multi-dimensional data into actionable insights
• Created an intuitive interface enabling stakeholders to explore $8.34bn in sales data across multiple dimensions
• Identified key trends and performance gaps to drive strategic decision-making