Transforming raw telemetry into actionable product strategies. This repository showcases my technical proficiency in modern data stacks and my strategic approach to SaaS metrics, marketing efficiency, and user conversion funnels.
With a background in Aeronautical Engineering (M.Sc. Aviation Transport, Riga Technical University), I approach data analytics the same way I approach aircraft systems: precision, logic, and root-cause resolution. Whether I am optimizing a global spare parts distribution network using Monte Carlo simulations or pinpointing user drop-offs in a SaaS checkout funnel, I build robust, "sensor-first" measurement architectures that executives can trust.
Explore the folders below to see my hands-on applications of SQL, data visualization, and product tracking:
| Project Folder | Core Technologies | Business Focus |
|---|---|---|
| 01_SQL_Database_Analysis | GA4, BigQuery, PostgreSQL |
ROMI, Marketing Efficiency, Funnel Diagnostics |
| 02_SaaS_Funnel_Dashboard | Power BI, Tableau |
User Journey, Drop-off Analysis, Executive Reporting |
| 03_Product_Tracking_Architecture | Excel, Event Taxonomy |
Instrumentation, Time-to-First-Value (TTFV), Metrics Mapping |
| 04_GA4_Ecommerce_Conversion_Funnel | GA4, SQL |
E-commerce Behavior, Landing Page Optimization |
| 05_SaaS_MRR_and_Retention_Analytics | Python, Power BI |
Churn Rate, MRR Growth, Cohort Analysis |
Note: This repository is actively updated as I implement advanced methodologies including A/B Testing and predictive modeling.
- Data Extraction & Manipulation: Advanced SQL (CTEs, Window Functions, JSON unnesting), Python (Pandas, NumPy).
- Business Intelligence & Viz: Tableau, Power BI, building scannable executive dashboards.
- Product & Web Analytics: Amplitude event tracking, Google Analytics 4 (GA4) custom event modeling.
- Strategic Metrics: Customer Acquisition Cost (CAC), Return on Marketing Investment (ROMI), Monthly Recurring Revenue (MRR), Churn, Retention Cohorts.
I am always open to discussing data strategy, product growth, or aviation tech.