Can I improve my chess skills using data?

In this project I wanted to see if I could find a way to improve my chess rating by analysing my past games. Although I could achieve this goal by studing chess theory, or playing more, I was curious to see if there were trends hidden in my games tht could pinpoint my weaknesses. Luckily for me, Chess.com provides a handy API to obtain all kinds of data. Built around this API, I deployed an automated solution on Google Cloud Platform to ingest my game data, apply data transformations, and finally display the analytics using Google Looker Studio.
Explore the dashboard below to see the final result or

See on Github!

Project Details

Extract, Transform, Load

Extract data using python and the Chess.com API. Pandas is used to manipulate the data. The data is saved to a CSV file.

Google Cloud Platform

The solution is orchestrated on GCP. The python script is run using cloud functions, triggered using a pubsub message and a cloud scheduler. Once a day the scraper ingests all the game data and saves a csv in cloud storage.

Looker Studio

A Looker studio dashboard is connected to the data in GCS, and set up to display a range of analytics.