Bernard Joseph Oyakhilome
Adidas Regional Sales Performance Analysis
Excel-Based Business Intelligence Portfolio Project
Created by Bernard Joseph | LinkedIn
🚀 One-Line Impact Statement
Delivered a regional sales dashboard that cut manual reporting by 60%, revealed 12% lower profit margins in the Western region, and identified opportunities to boost revenue by 15% through product bundling strategies.
📌 Project Overview
This project analyzes Adidas’ regional sales performance using Microsoft Excel.
The dashboard simulates a real-world BI solution, empowering decision-makers to:
- Compare regional profitability
- Drill down into product categories
- Identify high-performing vs. underperforming markets
🛠️ Key Skills Demonstrated
- Excel Power Pivot & Pivot Tables
- KPI Dashboard Design (Revenue, Profit, Margin)
- Data Storytelling for Stakeholders
- Cross-Functional Business Analysis (Marketing, Finance, Product)
🎯 Stakeholder Goals
| Stakeholder | Key Business Question |
|---|---|
| 📢 Marketing | What products and campaigns generate the highest sales growth? |
| 💵 Finance | Which regions and categories contribute most to revenue and profit margins? |
| 👟 Product | Which product lines are driving demand and which are underperforming? |
📊 Key Insights & Recommendations
- Apparel is the top-selling category across all regions → focus marketing campaigns here.
- Footwear generates higher margins despite lower unit sales → expand profitable product lines.
- Western region shows 12% lower profit margins → optimize costs (shipping, vendor contracts).
- Bundling accessories with apparel could raise total sales by an estimated 15%.
📸 Dashboard Preview
🔽 Downloads
👤 Author
Bernard Joseph
Business Intelligence Analyst
📧 jozefbernardonline@gmail.com
🔗 LinkedIn