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.
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.
An analysis of hotel revenue trends and performance metrics across different hotel types and time periods. The project includes data preparation in MySQL, exploratory data analysis, and an interactive dashboard created in Power BI to visualize key insights and recommendations for the hotel business.
A Python-based ETL tool that automates the process of importing data from various file formats (CSV, JSON, Excel) into PostgreSQL databases. It handles file detection, data cleaning, schema generation, and efficient data loading, making it easy for data analysts and engineers to quickly load datasets without writing custom scripts for each format.
If you'd like to get in touch, feel free to reach out at dorukalkan42@gmail.com and LinkedIn.