top of page
excelogimage.png

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​​​

Documents

Original Excel File

Dashboard Excel File

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.​​​​

bottom of page