Sales Data Analysis Dashboard (2019–2020)

Analyzed sales data (Sales Export 2019–2020) to generate actionable business insights using Excel.

Key Insights

Top Countries by Revenue: Portugal ($27M), France ($25M), Sweden ($19M)

Highest Profit Margin: Austria (18.78%), outperforming other countries

Top Customers & Preferences: Order counts, loyalty segments, buying patterns

Orders by Device Type: PC / Mobile / Tablet

Product & Category Performance: Best-selling products and categories

Year-over-Year Trends: Revenue growth from 2019 to 2020

Tools Used

Microsoft Excel, Pivot Tables & Charts, Power Pivot, Slicers, Data Cleaning