MIP Logo

Dashboard Week Day 3-The Hills Shire Library Program Analysis

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here. 

Today is dashboard week day 3 and the data source we got today is Public Library Statistics (nsw.gov.au).

The moment I got this data, I started to look for the data of the council I lived in. And my focus shifted from books to the program they had, as I always felt there wasn’t enough programs for my son in the library.

Cleaning Data

All the data cleaning is done in alteryx. The main cleaning job focus on sample the row I needed and clean the council so the tables can join together.

Dashboard

In the dashboard, there’re two questions I want to explain: “How’s the performance of Library Program in The Hills Shire Council?” and “Why this happened?”.

In the “How” part, I display the program number and attendance number in 2022-2023. I also analyze the age group of the program targeted audience and topics.

In the “Why” part, I focus on the correlation between staff number, staff salary, expenditure, funding and program number.

Below is my dashboard. If you like it, take a look and leave a comment.

 

 

Share this post