Barnet Council Dashboard

Development of Barnet Council financial dashboard

During my team at university I was employed by the Barnet Council to build a financial dashboard that would display the available funds across boroughs in London as a comparative tool. The dashboard was built on Microsoft Excel. The initial stage involved working with the apt departments to acquire the data needed. The data was then cleaned up and organised and was updated using an external API that would automatically input data in the necessary fields. The final stage was to design the dashboard using charts that were relevant to the underlying data. The dashboard is still in use today.