As the company required a better insight into their developers coding workflows and habits, I was responsible for creating an analysis tool that could analyse git code repositories and identify potential ‘hotspots’ in code, which were frequently changed or bug-fixed. In addition, individual developer workflows could be better understood by running more advanced queries. My implementation was used on the cloud service Google BigQuery, which allowed my solution to be highly scalable and deliver complicated analysis results of very large code repositories almost instantly.