Analyzed revenue lifecycle using cohort tables and MMR tracking. Visualized user payment behavior, retention shifts, and total revenue dynamics for data-driven growth.
0
16
Comprehensive financial analysis across USA, EMEA, and APAC. Tracks ARPPU, Paid User dynamics, and revenue by software category to drive global growth strategy.
Developed a comprehensive SaaS analytics system to track MRR dynamics and Unit Economics.
Backend: Wrote complex SQL scripts (Window functions, CTEs) to transform raw payment data into monthly cohorts.
Frontend: Built a Tableau dashboard for monitoring LTV, Churn Rate, and Revenue expansion/contraction.
Result: Business can now identify exactly why revenue is changing and track customer lifetime value in real-time.
0
31
GA4 Ecommerce Analysis & Tableau Dashboard
In this project, I transformed raw Google Analytics 4 data into an interactive Tableau dashboard.
Key highlights:
Processed 1.7GB of data in BigQuery using SQL (UNNEST, CTE).
Visualized the full User Purchase Journey and conversion rates.
Analyzed performance by device, OS, and landing pages to identify growth opportunities.