All Publications
Building a Financial Data Pipeline with Alpha Vantage and ClickHouse
A tutorial on building a complete end-to-end ETL pipeline, extracting financial data from the Alpha Vantage API, transforming it using python and pandas, loading it into Clickhouse's cloud RDBMS, and extracting some useful insights.
How to Create and Manipulate SQL Databases with Python
A tutorial on how to use Python and SQL (specifically MySQL using the MySQL Connector) together. It covers using the MySQL Connector to extract data from a Relational Database for use in projects in Python.
MySQL Tutorial Series
Three part tutorial series covering the fundamentals of Relational Database theory and design, how to implement a Relational Database using MySQL and then going through the most useful queries in SQL.
Creating an interactive map in Python using Bokeh and pandas
This is an introduction to making interactive visualisations in Python using the Bokeh library.
Mapping Avocado Prices in Python
This is a tutorial on doing Data Analysis / Data Visualisation with geodata. I use pandas, GeoPandas, GeoPy, Matplotlib, and a few other libraries to piece it together.
Where to Swim in Berlin
A tutorial Exploratory Data Analysis project using data from Open Data Berlin to answer that most vital of questions - which district of Berlin should you live in if the only criterion you care about is access to outdoor bathing spots?