Transforming raw aviation data and product telemetry into actionable insight. This repository showcases my technical proficiency in modern data stacks, combining an aeronautical engineering background with hands-on skills in SQL, Python, and data visualisation.
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 classifying live ADS-B flight data over European airspace or pinpointing user drop-offs in a SaaS checkout funnel, I build robust, "sensor-first" measurement architectures that engineers and executives can trust.
Explore the folders below to see my hands-on applications of SQL, Python, and data visualisation:
| 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 |
| 06_Instagram_Analytics | Python, Pandas, Seaborn |
Audience Growth, Engagement Analysis, Content Strategy |
| 07_Aviation Flight_Analysis | Python, OpenSky API, Pandas |
Live ADS-B Data, Flight Phase Classification, Fleet Behaviour |
🔄 This repository is actively updated. A/B Testing and predictive modelling projects are in progress.
- Data Extraction & Manipulation: Advanced SQL (CTEs, Window Functions, JSON unnesting), Python (Pandas, NumPy), REST API integration.
- Business Intelligence & Viz: Tableau, Power BI, Matplotlib, Seaborn — building scannable dashboards and engineering-grade charts.
- Product & Web Analytics: Amplitude event tracking, Google Analytics 4 (GA4) custom event modelling.
- Aviation Domain: ADS-B data interpretation, flight phase classification, RVSM procedures, MRO systems (AMOS, OASES).
- Strategic Metrics: CAC, ROMI, MRR, Churn, Retention Cohorts, Engagement Rate, Time-to-First-Value (TTFV).
I am always open to discussing data strategy, aviation tech, or product growth.
- Instagram @airfighters — 450K+ aviation community