Overview
This project was done as part of McKinsey Digital's first invitation-based hackathon where 4 NGOs pitched their problems to the teams.
I decided to work alone on the Science Museum Group stream. During the Covid pandemic, the Group has invested more into their online offerings such as an online catalogue of its items that can be viewed through images or scanned 3D models. The Group wanted a solution to that enables them to find insights into the new data that they now could collect through linking multiple sources such as Google Analytics and its own database of objects.
My solution was to centralise all the data collected into a Snowflake database using cron jobs to fetch new catalogue objects and export to Google Analytics. With all the data centralised into a scalable database platform, I then could process it to obtain the necessary insights in the data and then report the results through the Grafana dashboard platform.
The project placed 4th in the stream.