This was the final exam of a 3 months long data science course at JDS Academy (from February to May, 2023).
The objective of the course was to prepare participants to become junior data scientists; its learning materials included Bash, PostgreSQL and Python.
The final assignment involved a fictitious online business known as Dilan's blog.
Dilan travels around the world, writes a blog about it and sells two products related to his global travels: an e-book and a video course.
His blog covers the six main continents of the world, is accessible from eight countries, and has readers from three different sources. His current marketing budget is allocated to these three sources.
The question was how Dilan could invest more work, time and money into his blog in the most effective way possible to make it bigger, better and more profitable.
The tools that I used for the analysis:
- Bash for initial data wrangling and discovery
- PostgreSQL for most of the analysis
- Looker Studio for data visualisation
- Python for regression analysis (and for cohort analysis)