Posts by Category

vago

Financial audit dashboards

Each year, VAGO tables reports in Parliament summarizing the results of financial audits for various sectors, including local government and education. These...

Accessibility of Tram Services: Follow-up

Two members of my team collaborated on the follow-up audit by updating and extending the original analysis with new data and a refreshed interactive dashboar...

Planned Surgery in Victoria

A member of my team contributed to this audit by extracting and standardising data from the Elective Surgery Information System and hospital submissions, ena...

Work-related Violence in Government Schools

A member of my team analysed the department’s eduSafe Plus incident-recording system across a ten-year period, cleaning and standardising the data to make it...

Domestic Building Insurance

A data scientist on my team contributed to this report by carrying out descriptive analysis and process flow mapping of the dispute resolution processes. An ...

Recycling Resources from Waste

The main contribution I made to this engagement was the development of interactive visualizations embedded within the audit report. This approach hoped to en...

Major Projects Performance Reporting

The Victorian Auditor‑General’s Office’s Major Projects Performance Reporting review presents attested data from 113 major public-sector projects (with total...

Staff Wellbeing in Fire Rescue Victoria

In this performance audit, we looked at how Fire Rescue Victoria (FRV) supports the wellbeing of its staff, including mental health initiatives and workplace...

Access to Emergency Healthcare

The Department of Health publishes performance data on emergency healthcare services, but it is not disaggregated by demographic factors. The Data Science te...

Contractors and Consultants

For this engagement, I created an interactive dashboard that allows users to explore Victorian public service spending on contractors and consultants from 20...

Cybersecurity: Cloud Computing Products

This is a great example of how data scientists can add value to an engagement without directly carrying out data analysis. As part of the planing phase of th...

Regulating Private Pool and Spa Safety

The data science contribution to this audit focused on designing a council survey that would generate clear, audit-relevant insights. We adopted a reverse-en...

Managing Body-Worn Cameras

I was involved in the design (but not execution) of this piece of analytics that involved fuzzy-joining datasets (police activity and camera metadata), stati...

Government Advertising

This report included a dashboard that allowed the public to explore the publicly reported data on government advertising. The report was tabled by the Victo...

Effectiveness of the Navigator Program

The data analytics in this audit used longitudinal student attendance and academic performance data to measure the effectiveness of the Navigator program usi...

Reducing the Harm Caused by Gambling

Preliminary analysis of the effectiveness of gambling support programs as a demonstration of what the agency could be doing with the rich data they are colle...

Interview on the Auditing with Data podcast

I recently had the pleasure of being interviewed by Conor McGarrity and Yusuf Moolla from Risk Insights on the Auditing with Data podcast. We discussed the u...

Sexual Harassment in Local Government

This audit involved a survey of staff experience of sexual harassment in local government. It was designed to be comparable to the Victorian Public Service P...

Accessibility of Tram Services

This audit includes an interactive dashboard that allows the public to explore and understand the accessibility of Melbourne’s tram network. It allows users ...

Reducing Bushfire Risks

This audit used subject matter data expertise to explore and understand the limitations of bushfire risk modelling undertaken by the Department of Environmen...

Council Libraries

In this audit, we used data envelopment analysis to investigate the efficiencies of council libraries. The inputs included library FTE and collection size, a...

Back to Top ↑

performance audit

Accessibility of Tram Services: Follow-up

Two members of my team collaborated on the follow-up audit by updating and extending the original analysis with new data and a refreshed interactive dashboar...

Planned Surgery in Victoria

A member of my team contributed to this audit by extracting and standardising data from the Elective Surgery Information System and hospital submissions, ena...

Work-related Violence in Government Schools

A member of my team analysed the department’s eduSafe Plus incident-recording system across a ten-year period, cleaning and standardising the data to make it...

Domestic Building Insurance

A data scientist on my team contributed to this report by carrying out descriptive analysis and process flow mapping of the dispute resolution processes. An ...

Recycling Resources from Waste

The main contribution I made to this engagement was the development of interactive visualizations embedded within the audit report. This approach hoped to en...

Staff Wellbeing in Fire Rescue Victoria

In this performance audit, we looked at how Fire Rescue Victoria (FRV) supports the wellbeing of its staff, including mental health initiatives and workplace...

Cybersecurity: Cloud Computing Products

This is a great example of how data scientists can add value to an engagement without directly carrying out data analysis. As part of the planing phase of th...

Regulating Private Pool and Spa Safety

The data science contribution to this audit focused on designing a council survey that would generate clear, audit-relevant insights. We adopted a reverse-en...

Managing Body-Worn Cameras

I was involved in the design (but not execution) of this piece of analytics that involved fuzzy-joining datasets (police activity and camera metadata), stati...

Effectiveness of the Navigator Program

The data analytics in this audit used longitudinal student attendance and academic performance data to measure the effectiveness of the Navigator program usi...

Reducing the Harm Caused by Gambling

Preliminary analysis of the effectiveness of gambling support programs as a demonstration of what the agency could be doing with the rich data they are colle...

Accessibility of Tram Services

This audit includes an interactive dashboard that allows the public to explore and understand the accessibility of Melbourne’s tram network. It allows users ...

Reducing Bushfire Risks

This audit used subject matter data expertise to explore and understand the limitations of bushfire risk modelling undertaken by the Department of Environmen...

Council Libraries

In this audit, we used data envelopment analysis to investigate the efficiencies of council libraries. The inputs included library FTE and collection size, a...

Back to Top ↑

dashboard

Accessibility of Tram Services: Follow-up

Two members of my team collaborated on the follow-up audit by updating and extending the original analysis with new data and a refreshed interactive dashboar...

Major Projects Performance Reporting

The Victorian Auditor‑General’s Office’s Major Projects Performance Reporting review presents attested data from 113 major public-sector projects (with total...

Contractors and Consultants

For this engagement, I created an interactive dashboard that allows users to explore Victorian public service spending on contractors and consultants from 20...

Government Advertising

This report included a dashboard that allowed the public to explore the publicly reported data on government advertising. The report was tabled by the Victo...

Sexual Harassment in Local Government

This audit involved a survey of staff experience of sexual harassment in local government. It was designed to be comparable to the Victorian Public Service P...

Accessibility of Tram Services

This audit includes an interactive dashboard that allows the public to explore and understand the accessibility of Melbourne’s tram network. It allows users ...

Back to Top ↑

personal project

Plane tune

Concept: this project explores a novel sonification technique that combines: Parametric Path - A 2D curve defined as a function of time t, producing coor...

Snooker scoreboard

A problem with being a snooker spectator is keeping track of whether a player has enough of a lead to have won the frame. You need to calulate the difference...

Hex my map up

So I got all inspired by some of the US election data viz, in particular some of the mapping of states as abstract shapes with areas proportional to the numb...

Alien information display

I was watching an episode of Star Trek and some of the alien signage displayed in the background reminded me of the album art on Exai by Autechre. I read som...

Tesseract exploration

An animated projection of a tesseract (a 4D generalizaion of a cube). The idea is that by playing with this and observing the shape as it moves, you might be...

Enhanced AFL ladder

At the time of publication, Essendon are clearly the best side in the AFL. (Perhaps I am displaying a tiny little bit of bias here.) They are the best side f...

Back to Top ↑

note

Bootstrap for finite populations

I find bootstrapping to be one of the most general and useful statistical techniques in my toolbox. In the paper below, the method is extended to finite popu...

Gotcha: SQL ‘between’ predicate

Just a quick note of gotcha that I have fallen into a couple of times. (We are in the SAP HANA dialect of SQL here.) This gotcha is caused by two interacting...

Back to Top ↑

art

Alien information display

I was watching an episode of Star Trek and some of the alien signage displayed in the background reminded me of the album art on Exai by Autechre. I read som...

Tesseract exploration

An animated projection of a tesseract (a 4D generalizaion of a cube). The idea is that by playing with this and observing the shape as it moves, you might be...

Back to Top ↑

report

Portfolio of work with Australia Post

Australia Post is a huge and hugely complicated organisation. They have amazing data (variety, volume, velocity, …) and to be honest, I was still getting my ...

Back to Top ↑

australia post

Portfolio of work with Australia Post

Australia Post is a huge and hugely complicated organisation. They have amazing data (variety, volume, velocity, …) and to be honest, I was still getting my ...

Back to Top ↑

article

Commando python envs

Just a quick note on my approach to environments for data analytics (without undies). Here I’m using Python, Jupyter, and Conda, but the approach could be ad...

Back to Top ↑

conference

Back to Top ↑

interview

Interview on the Auditing with Data podcast

I recently had the pleasure of being interviewed by Conor McGarrity and Yusuf Moolla from Risk Insights on the Auditing with Data podcast. We discussed the u...

Back to Top ↑

linkedin article

So you wanna data science? Permalink

A write-up of my LinkedIn article on the skills needed to get into data science. It is a summary of the skills I look for when hiring data scientists, and th...

Back to Top ↑

pefrormance audit

Access to Emergency Healthcare

The Department of Health publishes performance data on emergency healthcare services, but it is not disaggregated by demographic factors. The Data Science te...

Back to Top ↑

follow-up

Accessibility of Tram Services: Follow-up

Two members of my team collaborated on the follow-up audit by updating and extending the original analysis with new data and a refreshed interactive dashboar...

Back to Top ↑

financial audit

Back to Top ↑

results of financial audits

Financial audit dashboards

Each year, VAGO tables reports in Parliament summarizing the results of financial audits for various sectors, including local government and education. These...

Back to Top ↑