# Dashboard Week Day 3-The Hills Shire Library Program Analysis

> 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…
> URL: https://mip.com.au/blogs/dashboard-week-day-3-the-hills-shire-library-program-analysis/
> Last modified: 2026-08-06T04:19:11+00:00

Today is dashboard week day 3 and the data source we got today is [Public Library Statistics (nsw.gov.au)](https://www.sl.nsw.gov.au/public-library-services/advice-and-best-practice/public-library-statistics).

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.

 

 

[](#)
