Zain The AnalystAvailableCase Study
Data Analysis and Visualization
Pitchside Pro Revenue Performance Dashboard
An executive Power BI dashboard that explains revenue growth, profit, conversion, football moment impact, channel efficiency, and where the business should focus next.
Key Metrics Analyzed
Net Revenue$11.2M
Gross Profit$5.9M
Gross Margin52.8%
Sessions8.8M
Conversion Rate3.24%
Moment Revenue$6.3M
Peak Month$269.4K
Best Growth CategoryKits
Best RegionEMEA
Best Growth ChannelWeb
Growth Runway+$2.6M
Overview & Objectives
This project analyzes football-inspired ecommerce revenue performance using Power BI. It gives executives a clear view of net revenue, gross profit, gross margin, sessions, conversion rate, product category performance, channel efficiency, revenue growth drivers, football moment impact, seasonality, and growth opportunities.
The dashboard includes three executive report pages. The first page focuses on revenue performance overview with KPI cards, product category ranking, revenue growth drivers, channel performance, and monthly revenue trend. The second page focuses on revenue timing and football moment drivers, including moment revenue, peak month, monthly seasonality, football moment heatmap, moment revenue mix, and yearly revenue rollup. The third page focuses on growth recommendations, including best growth category, best region, best growth channel, best segment, growth runway, product growth matrix, region opportunity, channel efficiency, product and channel heatmap, and strategic one-line recommendations.
Project Goal
Build an executive dashboard that answers what is driving revenue performance over time and where the business should focus next to sustain growth.
The Business Problem
Executives need to understand what is driving revenue growth, which products and channels are performing best, how football moments affect revenue timing, and where the business should focus next. The challenge was to combine revenue, profit, margin, traffic, conversion, region, channel, segment, category, and football event data into one clean executive dashboard.
Methodology
My Approach
- 1I prepared the football ecommerce revenue dataset for executive analysis.
- 2I created Power BI measures for revenue, profit, margin, sessions, conversion rate, year-over-year growth, revenue drivers, moment revenue, and growth runway.
- 3I designed three executive pages focused on performance overview, timing drivers, and growth recommendations.
- 4I added filters for year, country, moment type, macro region, and category so users can explore performance dynamically.
Implementation
Roadmap Execution
Data Preparation
Prepared and cleaned revenue, product, channel, region, segment, date, and football moment data for analysis.
Data Modeling
Created the Power BI data model needed to connect revenue performance, customer behavior, football timing, and growth dimensions.
DAX Development
Built executive measures for net revenue, gross profit, margin, sessions, conversion rate, year-over-year growth, moment revenue, volatility, and growth runway.
Revenue Overview
Designed the first page with KPI cards, product category ranking, revenue growth drivers, channel performance, and revenue trend.
Football Moment Analysis
Designed the second page to explain monthly timing, football moment impact, seasonality heatmap, moment revenue mix, and yearly revenue totals.
Growth Recommendations
Designed the third page with growth focus KPIs, product growth matrix, region opportunity, channel efficiency, heatmap, and simple strategy recommendations.
Key Features
Executive revenue KPI overview
Revenue by product category
Revenue growth drivers waterfall
Channel performance analysis
Revenue trend versus previous year
Football moment revenue analysis
Monthly revenue and football moments
Seasonality heatmap by year and month
Moment revenue mix by event type
Year total revenue rollup
Growth focus KPI cards
Product growth matrix
Region opportunity ranking
Channel efficiency comparison
Product and channel revenue heatmap
Executive recommendation cards
Business Impact
Helps executives understand what is driving revenue growth
Identifies the strongest product category, region, channel, and customer segment
Shows how football moments affect revenue timing
Turns performance analysis into clear growth recommendations
Supports better decisions around product focus, regional growth, and channel prioritization
Challenges Overcome
- Combining revenue, profit, traffic, conversion, regions, channels, products, segments, and football moments into one model
- Explaining growth drivers clearly for an executive audience
- Showing both performance and recommended actions without overcrowding the dashboard
- Designing a clean dark executive theme with strong KPI readability
- Connecting football moments to revenue timing and business growth
Outcomes
Final Outcomes & Learnings
- The final dashboard gives a clear executive view of revenue performance, product growth, channel efficiency, football moment impact, and regional opportunity.
- It helps decision-makers identify the strongest revenue drivers, best product-channel combinations, high-potential regions, and clear actions for future growth.
Project Gallery & Screenshots
Technologies Used
Power BIPower QueryDAXData ModelingData VisualizationExecutive ReportingBusiness Intelligence
Data Sources
Football ecommerce sales datasetRevenue and profit dataTraffic and conversion dataProduct category dataChannel dataRegion dataCustomer segment dataFootball moment calendar dataYearly and monthly trend data
Need similar outcomes in your business?
Let's scope your metrics and construct dashboards tailored to your parameters.