
Excel Dashboard for Adidas Sales
Transforming Adidas FY20-21 Sales Data into Interactive Dashboards within Excel
Project Role - Creator
​​​​
Project Year - 2025
​​​​
Project Type - Personal Project
​​
Project Location - San Jose, CA​​​
Video & Details

Adidas Sales Dashboard - Excel (FY2020 - FY2021)
Developed an interactive Excel dashboard to analyze over 9,000 rows of Adidas sales data sourced from Kaggle, focusing on business insights and visual storytelling.​​
​
-
Imported raw CSV data into Excel and structured it using formatted tables for ease of analysis.
-
Performed data cleaning and transformation to prepare the dataset for dashboard integration.
-
Identified and defined key performance indicators (KPIs) relevant to business performance.
-
Used pivot tables and pivot charts to create dynamic, filterable views of the data.
-
Designed a dashboard layout that integrated KPIs and visualizations using Excel's built-in design tools.
-
Implemented slicers for regional filtering and focused on Q4 2021 to simulate a recent business scenario.
-
Ensured interactivity and clarity through thoughtful layout, conditional formatting, and visual hierarchy.​​​​