Selected Projects
Five Power BI dashboards — data engineering, star-schema modelling, DAX and visual storytelling. Each card opens an interactive dashboard preview and lays out the problem, the model and the headline numbers. Add a GitHub repo or live demo to any card without changing the layout.
Product · Streaming
12,000 streaming records across 100 tracks, 25 artists and 12 markets — built on a Kimball star schema to show who listens, to what, on which device, and how deeply. Premium listeners skip far less than free users, quantifying the value of conversion.
Retail · Profitability
8,000 orders and $3.68M revenue across 5 regions and 3 categories, with a proper date dimension for time intelligence. It exposes the discount-to-margin relationship — orders discounted above 20% turn unprofitable — so pricing can be fixed with evidence.
Marketing · Multi-channel
10,000 daily campaign records across Google, Meta, Instagram and LinkedIn — $4.55M spend turning into $13.9M revenue. Ratios are DAX measures over additive bases, so ROAS, CPA and CTR aggregate correctly and budget can move to what actually pays back.
Retention · Subscription
7,500 subscribers with a 28.5% churn rate — ranking the drivers (contract, tenure, satisfaction, complaints, payment) and building a risk score that flags who to save first. It quantifies roughly $115K of monthly revenue at risk.
Web · SEO Analytics
Website and SEO analytics built the way GA4 and Search Console feed it — sessions, users, channel mix, organic trend, landing-page conversion and bounce. The standout view finds keywords ranking on pages 2–3 with real impressions: the quickest wins on the board.
