top of page

Adidas Sales Dashboard
 

About the Project: Adidas Dashboard

This project involves the analysis of Adidas sales and performance data. The goal is to deliver a dynamic and interactive dashboard that provides insights into product performance, regional sales, customer trends, and revenue generation. The dashboard is designed to assist stakeholders in understanding market dynamics and identifying growth opportunities.

Datasets

  1. Adidas Dataset:

    • Includes detailed records of product sales, such as item categories, units sold, revenue, and profit margins.

    • Covers geographic data for sales distribution by region and store.

    • Contains customer demographics, including age, gender, and purchase behavior.

  2. Adidas Dashboard Excel:

    • A structured and automated Excel file containing formulas, pivot tables, and charts to visualize key metrics dynamically.

Dashboards

Sales Performance

  • Top-Selling Products:

    • Lists the best-performing products by sales volume and revenue.

    • Highlights items with the highest profit margins.

  • Sales by Region:

    • Maps sales performance across various regions, showcasing top and underperforming areas.

  • Seasonal Trends:

    • Identifies peak sales periods and trends, helping optimize inventory and marketing efforts.

Customer Insights

  • Demographics:

    • Breaks down sales by customer age and gender to understand buying patterns.

  • Customer Retention:

    • Tracks repeat purchases and customer loyalty metrics.

Financial Overview

  • Revenue vs Profit Analysis:

    • Visualizes overall revenue generation compared to net profit.

  • Store Performance:

    • Compares sales and profitability of individual Adidas stores.

What I Did?

  • Cleaned and validated sales and customer data for accuracy.

  • Built a dynamic dashboard using Excel tools such as slicers, conditional formatting, and pivot charts.

  • Conducted detailed analyses to identify patterns, trends, and actionable insights.

  • Designed visualizations to highlight key performance indicators (KPIs) for easy interpretation by stakeholders.

What I Learned?

  • Data Visualization:

    • Gained expertise in creating clear and interactive charts to represent sales data effectively.

  • Market Analysis:

    • Improved understanding of how demographic and regional factors influence sales performance.

  • Excel Automation:

    • Enhanced skills in Excel automation, including formula creation and dashboard interactivity.

  • Strategic Insights:

    • Learned how to derive actionable business insights from raw sales data.

Highlights of the Project

  1. Dynamic Features:

    • Filters and slicers allow stakeholders to explore data by region, product category, and time period.

    • Interactive visualizations update automatically based on user input.

  2. Key Insights:

    • Identifies high-performing regions and products to allocate resources strategically.

    • Provides customer behavior insights to tailor marketing campaigns.

  3. Business Impact:

    • Supports decision-making in inventory management, marketing strategies, and regional expansions.

bottom of page