Sample Projects
In this project, the goal was to find the optimal budget allocation model for multiple campaigns across various channels. First, I organized and modeled the campaign data collected in BigQuery. After preparing the data in the desired format, I used Looker Studio to create a model with various parameters. By selecting our desired criteria, the system identifies the most suitable ad campaigns, advertising channels, and other relevant details. It also provides recommendations on how to adjust the budget, suggesting which campaigns to reduce and where to allocate the savings for an ideal distribution.
In this project, I built a model on a general events table in BigQuery, which was triggered by Firebase. The model provided a framework for comparing all past and future A/B tests. Later, I transformed this table into a dashboard in Looker Studio. Thanks to this work, the entire A/B testing process can now be compared seamlessly without requiring additional effort.
In this project, we delve into the capabilities of the Spotify API to extract, process, and understand music-related data. The project aims to demonstrate key concepts in API usage, authorization mechanisms, and data handling, providing valuable insights for anyone looking to work with RESTful APIs in a real-world context.
This project focuses on leveraging weekly updated data from TransferMarkt to create a dynamic scouting model that facilitates in-depth analysis of players and matches. By combining advanced filtering techniques with comprehensive datasets, the project mimics the capabilities of a professional scout, enabling tailored player recommendations.
