🏆 Sports Merchandise Analytics Dashboard

📊 Project Overview

The Sports Merchandise Analytics Dashboard is an interactive Power BI solution designed to analyze sales performance, customer behavior, website traffic, conversion effectiveness, and product profitability within a sports merchandise business.

The dashboard transforms raw, disconnected business data into actionable insights, enabling stakeholders to identify key revenue drivers, decode customer purchasing patterns, optimize marketing allocation, and improve overall operational performance.

🎯 Business Objectives

Performance Monitoring

Track overall sales, profit margins, and revenue performance over time.

Behavioral Analysis

Analyze customer purchasing behavior and basket trends.

Inventory Optimization

Identify top-performing product models and merchandise categories.

Digital Auditing

Evaluate website traffic patterns and conversion funnel efficiency.

Margin Assessment

Understand profitability across variable product segments.

Strategic Support

Back executive decision-making with robust, data-driven evidence.

🛠 Tools & Technologies

• Power BI Desktop – Report Engineering & Interface Design

• Power Query – ETL, Data Cleaning, and Attribute Transformation

• DAX (Data Analysis Expressions) – Advanced Business Intelligence Metrics & Time-Series KPIs

• Data Modeling & Visualization – Star Schema optimization and custom interactive layouts

📑 Dashboard Pages

1️⃣ Executive Overview

Provides a high-level, single-pane summary of baseline global business performance.

Key Metrics

• Total Revenue

• Total Orders

• Average Order Value (AOV)

• Conversion Rate

Core Visuals

• Revenue Trend Analysis

• Revenue by Product Category

• High-Impact KPI Cards

• Global Slicers

Business Value
Enables rapid C-suite performance assessments, executive-level health monitoring, and instant trend identification.

2️⃣ Customer & Product Insights

Focuses heavily on downstream customer purchasing patterns and specific product demand vectors.

Core Visuals

• Customer Distribution Analysis

• Product Category Performance

• Product Sales Breakdown

• Profit Contribution Analysis

Business Value
Helps teams deeply understand customer preferences, pinpoint best-selling merchandise, improve inventory planning, and deploy targeted marketing campaigns.

3️⃣ Traffic & Conversion Performance

Analyzes digital storefront engagement metrics and top-of-funnel conversion effectiveness.

Core Visuals

• Website Traffic Trends

• Revenue by Sales Period

• Traffic vs. Conversion Scatter Analysis

• Conversion Funnel Performance Metrics

Key Insights Isolated

• Website traffic exhibits consistent baseline growth over time.

• Targeted promotional campaigns contribute substantial revenue spikes.

• Higher conversion rates directly correlate with stronger bottom-line revenue performance.

• Conversion rate optimization (CRO) remains a major opportunity for digital storefront improvement.

Business Value
Evaluates e-commerce marketing effectiveness, optimizes customer acquisition strategies, and plugs leaks in the conversion funnel.

4️⃣ Product & Profitability Insights

Examines individual product profitability matrices and relative revenue contribution shares.

Core Visuals

• Product Profitability Analysis

• Revenue vs. Net Profit Comparisons

• Product Category Profit Share Breakdown

• High-Value Product Identification

Business Value
Informs product portfolio expansion decisions, isolates high-margin products, guides markdown/pricing strategies, and drives overall profitability.

📈 Key Business Insights

• Steady Scale: Revenue demonstrates steady, predictable Year-over-Year (YoY) growth.

• Pareto Effect: Specific niche product categories contribute disproportionately to total revenue streams.

• Behavioral Variance: Customer purchasing frequency and average transaction sizes vary significantly across product lines.

• Traffic Disconnect: Website traffic growth does not always translate dynamically into higher conversion rates, highlighting user-experience friction.

• Margin Disparity: Profitability varies wildly across products, showcasing clear opportunities for stock optimization.

eyJrIjoiYWMzNzcwOTgtMjA5Mi00ZTRmLWJmYTctYzNkNWM0MzYxYzk2IiwidCI6IjBjM2QwNTc2LTFkOWYtNGM4Ny05OTNjLTg2YjQ0MGE1YjA3OCJ9