Data Analysis

Hatfield JCR Treasury

Data collection, cleaning & evaluation on a range of unstructured financial data. Public facing visualizations in Tableau.

A number of projects were undertaken such as an accurate evaluation and projection of formal dining event attendance, which helped to guide budget projections.

In most cases this data was sparse and unstructured, for example extracting formal attendance figures from email records. Cleaning and modelling of this data was performed in Python.

Alongside this evaluation public facing visualizations such as the one below, were made for the benefit of JCR members. With the aim of increasing financial transparency.