Portfolio
Cost Analysis of Medicare services in Australia
Medicare, Australia's national public health insurance scheme provides subsidised healthcare to all Australians and permanent residents.
This project uses Python and Tableau to analyse rising non-hospital primary healthcare costs through machine learning and geographic analysis, assessing financial impacts across different regions and demographics.
Click the button below to view the methodology and insights.
Staffing Analysis for Influenza Season Readiness
In the US, the annual influenza season leads to a rise in flu cases and hospitalisations, causing medical facilities to rely on temporary staff from medical staffing agencies.
This project uses Excel and Tableau to perform geographical and demographic analysis to determine the optimal timing, location, and quantity of staff deployments required across the US.
Click the button below to view the methodology and the staffing plan.
Global Expansion Market Strategy
Rockbuster, a fictional movie rental company, is launching an online video rental service using its existing movie licenses to compete with other streaming platforms.
The project uses SQL, Excel and Tableau to tackle key questions from Rockbuster’s management and to develop a launch strategy for the online store.
Click the button below to view the methodology and recommendations for the launch strategy.
Customer Segmentation and Purchase Behaviour Analysis
Instacart, an online grocery store accessed through a mobile app, aims to refine its marketing with targeted campaigns.
The project uses Python libraries such as Pandas to analyse sales patterns, customer segments, and consumer behaviours to improve marketing strategies.
Click the button below to view the methodology and behaviour patterns.
Marketing Budget Optimisation Strategy
GameCo is a fictional video gaming company, planning its 2017 marketing budget with the assumption that regional sales are consistent.
The project uses Excel to validate the assumptions, offer insights into regional markets, and suggest how to allocate the marketing budget effectively.
Click the button below to see the methodology and marketing budget recommendations.
