Projects on data analytics, visualization, and engineering, with writeups on process, implementation, and results.
Currently working on — RFM analysis & forecasting on e-commerce data, using BigQuery and Looker Studio for exploration and Python for modeling.
Analyzed nominal and inflation-adjusted revenue for a Turkish supermarket chain, built BigQuery/dbt analytics models, and created Python forecasts and Power BI reporting for a team analytics project.
A modern ELT pipeline using Dockerized PostgreSQL, dbt for transformations, and Airflow for orchestration. This project demonstrates how to build a scalable data pipeline that extracts raw data, transforms it into analytics-ready tables, and orchestrates the workflow with Airflow.
An A/B test analysis of the Cookie Cats mobile game, evaluating the impact of moving a gate from level 30 to level 40 on player retention and engagement. The analysis includes statistical testing, business impact estimation, and recommendations based on the results.
If you'd like to get in touch, feel free to reach out at dorukalkan42@gmail.com and LinkedIn.