Portfolio
Portfolio

Real work. Real data.

Case studies across e-commerce analytics, BI reporting, and data pipeline engineering. Each project links to a full write-up.

Marketing Performance & Campaign ROI Analysis dashboard screenshot 01
BI Analysis · E-Commerce 2025
Marketing Performance & Campaign ROI Analysis

Built an end-to-end ETL pipeline using Python and SQL to consolidate raw marketing spend, impression, and revenue data into a single Power BI model. The final dashboard gave stakeholders a clear view of which campaigns were generating profitable returns and which were burning budget without conversion.

Python SQL Power BI ETL Data Warehousing Excel
Engineered ETL pipeline converting raw multi-source data into a clean analytical model
Identified highest and lowest ROI campaigns across channels, enabling budget reallocation
Delivered interactive Power BI dashboard with drill-through by channel, campaign, and period
Read the Case Study
Netflix global streaming analysis Power BI dashboard screenshot 02
Data Analysis · BI Reporting 2025
Full-Stack Analysis of Netflix's Global Streaming Data

Used Python, SQL, and Power BI to analyse Netflix's global content library and streaming performance data. Automated an ingestion pipeline to surface content survival rates, genre performance by region, and production investment patterns — giving a data-backed framework for programming and acquisition decisions.

Python SQL Power BI ETL Data Warehousing Excel
Automated data pipeline ingesting and cleaning multi-year global streaming records
Surfaced content survival rates and genre performance patterns across regions
Delivered strategic programming recommendations backed by quantitative trend analysis
Read the Case Study
Café sales analysis Tableau dashboard screenshot 03
BI Analysis · Retail Analytics 2025
Café Sales Analysis — Retail Optimisation Case Study

Applied BI tools to transform raw point-of-sale transaction data into a strategic roadmap for a retail café operator. The analysis identified peak trading windows, underperforming SKUs, and inventory inefficiencies — enabling data-backed decisions on staffing, stock management, and menu pricing.

Python SQL Tableau ETL Data Warehousing Excel
Identified top and bottom performing products by margin, not just revenue
Mapped peak trading hours to surface staffing and inventory optimisation opportunities
Built Tableau dashboard enabling ongoing self-serve reporting for the store owner
Read the Case Study
E-Commerce Revenue & Global Reach Power BI dashboard screenshot 04
BI Reporting · E-Commerce Analytics 2026
E-Commerce Revenue & Global Reach — Executive Power BI Dashboard

Built a single-page executive Power BI dashboard on a 100,000-customer e-commerce dataset covering $9.32M in gross revenue across 6 countries and 5 acquisition channels. The dashboard surfaces channel mix distribution, geographic revenue concentration, average order value, and a full-year monthly revenue trend — revealing a Q4 seasonal dependency pattern that signals an off-season demand generation problem for any real e-commerce operator.

Power BI Data Visualisation E-Commerce Analytics Business Intelligence KPI Reporting
Identified Q4 seasonal revenue concentration — flat 9 months, spike 3 months — as a dependency risk
Surfaced near-equal channel mix distribution as a potential lack of dominant acquisition strategy
Delivered executive single-page dashboard with KPI scorecards, geographic breakdown, and trend line
Read the Case Study
Coming soon

GA4 implementation case studies, GTM e-commerce tracking builds, and Looker Studio dashboard projects are being documented and will be added here shortly.

GA4 Implementation GTM E-Commerce Tracking Looker Studio Dashboard

Want results like these for your store?

Every project starts with a free 30-minute discovery call. Tell me what you're working with and I'll tell you what's possible.

Book a Free Discovery Call

Free 30-min call · No commitment · I'll tell you what you actually need, even if it's not me.