Case Studies

Clients I Have Helped

US-based ticket reseller.
We’ve been working together since early 2022 (3 years).
Utilising scraped ticketing data (provided by a specialist contractor)
Created a series of dashboards for detecting “hot tickets” (price going up and availability going down) and manage their current holdings.
Tableau used as the BI Tool. R used as the back end data-wrangling. GCP BigQuery used as the data warehouse.
Took over an existing codebase (from a previous data science developer). Many parts were no longer in use. Parsed out the helpful bits and re-built. Was reluctant to do this but it turned out to be necessary.
Was able to significantly reduce their GCP costs, by simplifying the existing infrastructure (moving from VMs to an on-site machine to run regular scripts).
Was able to keep the team up to date with the latest Tableau product developments (eg. the introduction of 2FA, Tableau Sites and the Table Extension).
Included “data recency” captions on all dashboard to inform users of the “data freshness”.
Utilised Tableau’s alerts functionality to email me when new scrape files had not been delivered (by the external contractor).

Improved discovery of buying options.
Better tracking of holdings
Better predictive understanding of how certain tickets (for certain event types / venues / artists) sold as the event date approached.

Trucking Company based out of Geelong.
Producing dashboards to showcase OH&S incident frequency & the progress of a fleet upgrade.
Replacing manual data-preparation processes
Power BI was the dashboard solution. Data wrangling was done using PowerQuery.
The exception reporting (of OH&S) incidents gave stakeholders an indication for how they were tracking compared to the same time last year and also between business units.
A tricky component to this project was getting the data for the denominator (of the incident rate equation) -how many km’s of travel. We devised a method to generate this automatically and free-up a senior manager from this manual task.

Melbourne based Chiropractic Practices
Used R to pull data from their patient management system via the API.
Produced a series of interactive Tableau dashboards that allowed exec and management to review a variety of complex statistics on individual practices and practitioners.

A powerful dashboard that allowed broad range of key and timely analyses to be conducted.
Minimal introduced overhead work required to update.