Portfolio

This contains some projects that make up part of my portfolio. Enjoy!

CoinCap API Pipeline

Python | PostgreSQL | Docker | cron | Metabase | AWS

This is a personal project I've been working on. The aim was to build a simple data pipeline, extracting real-time currency data, loading to a database, and visualising with Metabase.

Reddit API Pipeline

Python | SQL | Docker | Airflow | AWS | Google Data Studio | DBT | Terraform

This is a personal project I've been working on. The aim was to build a data pipeline, and develop basic skills across a range of technologies.

Data Engineering Bootcamp

Python | PostgreSQL | Docker | Terraform | Google Cloud Platform | Kafka

This is an online zoomcamp/bootcamp I recently completed. This was a great opportunity for me to develop my skills, and learn new technologies and tools. I tracked most of my progress here.

SQL Twitter Tutorials

SQL

This contains a series of basic SQL tutorials I've been publishing on Twitter.

Flask Mega Tutorial

Python | Flask | Unit Testing | SQLite | SQLAlchemy | HTML | CSS

This is a mega tutorial I am completing on Flask. Still in progress...

Psychology Experiment

Python | PsychoPy

The files here allow one to run a Stroop Task on multiple participants, before running a basic analysis on the results. This was one of the first Python projects I worked on with minimal tutorials or assistance. It was here that I learned how to program, and began to develop some proficiency with Python.

Mock Media App

Python | Object Orientated Programming | Event Driven Programming | Tkinter

This is a basic Python application developed using Tkinter. It's not a real media app, as the project was more intended to act as practice. This helped me gain an appreciation of event driven and object orientated programming.

Cheatsheets

This is where I store various cheatsheets that I've created to help my followers on Twitter and LinkedIn.

File Search

Python | Event Driven Programming | Tkinter

This is a python application developed using Tkinter. This apps allows one to search all text files within a specified directory for a specified string. This saves results to a listbox, as well as a CSV. This is very basic, but may be built upon in the future.

ASCII Art

Python | PIL

This is a python script which can convert a normal image into ASCII-Art. It was completed as a guided project to help develop my skills in Python.