PitchSide Pro Sales Analytics Dashboard Project Overview

The PitchSide Pro Sales Analytics Dashboard is an interactive Power BI solution designed to analyze revenue performance, product demand, customer behavior, and digital channel efficiency within a global football merchandise retailer.

The dashboard transforms five years of sales and traffic data into actionable insights, helping executives identify growth drivers, decode seasonal demand patterns, and optimize marketing allocation to sustain profitability.

Business Objectives

• Revenue Monitoring – Track total sales, profit margins, and growth trends over time.

• Seasonal Analysis – Highlight peaks around tournaments, finals, and major football events.

• Product Demand – Identify top‑performing kits, boots, and fan merchandise.

• Channel Efficiency – Evaluate digital traffic sources and conversion effectiveness.

• Regional Insights – Compare performance across geographies and customer segments.

• Strategic Support – Provide leadership with clear, defensible recommendations for sustained growth.

 Tools & Technologies

• Power BI Desktop – Report engineering & executive interface design

• Power Query – ETL, data cleaning, and attribute transformation

• DAX – Advanced KPIs (Revenue Growth %, Conversion Rate, ROAS, Profit Contribution)

• Data Modeling – Star schema optimization with FactSales, FactTraffic, Date, Product, Customer, Region, Channel

 Dashboard Pages

 Executive Overview

• KPIs: Total Revenue, Net Profit, Conversion Rate, Sessions

• Visuals: Revenue trend, revenue by product category, KPI cards

• Value: Rapid C‑suite health monitoring and trend identification

 Product & Customer Insights

• Visuals: Product category performance, profit contribution, customer distribution

• Value: Pinpoints best‑selling merchandise and purchasing behavior patterns

 Traffic & Conversion Performance

• Visuals: Website traffic trends, conversion funnel, traffic vs conversion scatter

• Value: Evaluates marketing effectiveness and CRO opportunities

 Regional & Channel Analysis

• Visuals: Revenue by region, channel efficiency, ROAS by source

• Value: Reveals geographic strengths and digital channel ROI

 Strategic Insights & Recommendations

• Statistical Highlights: • Revenue peaks align with major football tournaments • Mobile channels drive majority of conversions • Email campaigns deliver highest ROAS • Seasonal promotions lift revenue but pressure margins

• Recommendations: • Focus spend on high‑ROI channels • Optimize mobile checkout UX • Balance discounting with margin protection • Expand premium product launches in high‑performing regions

 Key Business Insights

• Seasonal Momentum: Revenue spikes during World Cup and league finals.

• Product Leaders: Kits and boots dominate sales, collectibles drive niche margins.

• Channel ROI: Email and direct traffic outperform paid social in conversion efficiency.

• Regional Variance: Southern Europe shows strongest elasticity for premium launches.

• Conversion Drivers: Mobile is the primary engine of successful transactions.

@World Champs BCN slindsay