Executive Summary

Built a comprehensive interactive sales performance dashboard analyzing 4 years of business data (2020-2023) across 2,000+ products and 10,000+ orders data across multiple geographic regions. The dashboard revealed significant performance volatility and profitability challenges, including a unique 2021 scenario where profit grew 19.6% despite sales declining 2.8%. Identified systemic issues with loss-making product categories and designed dynamic filtering system for stakeholder decision-making.

Key Performance Overview (2020-2023):

2020: $609K sales, $52K profit
2021: $471K sales (-2.8%), $62K profit (+19.6%)
2022: $609K sales, $83K profit
2023: $733K sales (+20.4%), $93K profit (+12.5%)

Problem Statement

The business needed a comprehensive multi-year analysis system to:

Track performance trends across 4 years of operations
Compare year-over-year performance across different time periods
Identify consistent profit margin issues and loss-making products
Enable filtered analysis by geographic regions and product categories
Provide stakeholders with self-service analytics capabilities