True

QTAC logo

A data-first financial model for a new public-facing product, delivering exceptional results

The Queensland Tertiary Admissions Centre (QTAC) is a non-profit organisation and Queensland’s trusted leader in tertiary admissions for more than 40 years. QTAC provides a one-stop shop for 17 higher education providers in Queensland and northern New South Wales, across both undergraduate and postgraduate admissions. 

Vaxa Analytics was engaged to assist QTAC in the development of a financial model regarding a new public-facing product. The Vaxa Analytics team worked to find and integrate a range of third-party datasets and relevant industry benchmarks to build the model under several scenarios.  

The team were able to project the growth of the product under those scenarios, accounting for various revenue stream, growth profiles and sensitivities over time. 

Additionally, Vaxa Analytics provided advice at a strategic level on the analytics and data-driven development of the new product, what QTAC should be looking to integrate into the product to understand which features users are using, and how that impacts long-term product retention. 

“Curtis and the Vaxa Analytics team helped us determine what data we should be accessing and how best to use it to get the most accurate results and insights,” QTAC’S Head of Strategic Growth, Kristie Fankhauser, said. 

“It was great having a specialist external team work on this project rather than impacting our internal team who were extremely busy during a peak time for our business. 

“Vaxa Analytics delivered over and above my expectations, were professional, transparent in everything they did, and easy to work with. I have already recommended them to many people and hope to continue our working relationship on this project and future ones.” 

The outcome 

The financial model was reviewed by QTAC’s engaged forensic accountant who agreed with the assumptions presented in the model and the data used. The model was an important part of the work required to progress further development of the product. Work is continuing. 

A data-first financial model for a new public-facing product, delivering exceptional results Read More »

Driving fundraising growth using analytics

Endeavour Foundation is an independent, for purpose organisation established in 1951 with a vision to support people with an intellectual disability to live their best life. Endeavour Foundation Lotteries fundraising contributes to programs and services that deliver on making possibilities a reality for people with a disability.

Vaxa Analytics was engaged to analyse the performance of their complex lottery product, with an aim to discover and unlock growth opportunities using data-driven decision making. Endeavour Foundation Lotteries chose Vaxa Analytics to undertake this scope of work based on the proven track record in the foundation’s commercial industry arm, Endeavour Foundation Industries.

The outcome

The Vaxa Analytics team delivered critical pieces of data management infrastructure – including the introduction of state-of-the-art marketing automation and behavioural analytics platforms and providing project services on the replacement of the core lottery software system – towards an automatic and unified view of customers and the product. The team designed and operationalised new data sets via self-service reporting and enabled more advanced capabilities like machine learning and multivariate analysis. These capabilities delivered accurate answers on complex questions like customer churn, segmentation, purchase propensity and revenue forecasts. By understanding Endeavour Foundation Lotteries’ long term product strategy and building and delivering an aligned data strategy, Vaxa Analytics unlocked millions in annual revenue improvements and laid the foundations for improved customer experience and product growth moving forward.

Driving fundraising growth using analytics Read More »

Freighter airplane being loaded with cargo.

Securing and managing Australia’s PPE supply chain

In early March 2020, Vaxa Analytics and Vaxa Bureau were contracted by Aspen Medical to provide procurement and logistics advisory support to fulfil their obligations in restocking the National Medical Stockpile with vital Medical PPE.

The mission was clear – to secure supply chains and facilitate the procurement and safe passage of vital medical PPE offshore to Australia in a very short timeframe.

Upon receiving an initial briefing, including an overview of the extent of existing systems, tools and processes, the task and context of the requirement changed rapidly, requiring additional skill sets and personnel, namely data analysis and software design to support the effort.

Our compact, nimble team of data analysts, software developers, procurement, supply chain and logistics personnel worked closely with the Aspen team to develop a robust plan which included the need to build bespoke software to manage the entire process, ensuring goods were Delivered In Full and On Time.

We undertook tasks including modelling, logistics management, contract negotiations, data analysis and management reporting, supplier vetting, supplier management, facilitation of quality control mechanisms, communications to the Commonwealth and more.

Underpinning the overall success of the program were Vaxa Analytics’s data and software capabilities. Our team of specialists evaluated and strategised the software and data required to support project outcomes.

We built a bespoke ERP system to manage and report on logistics and business intelligence to enhance data capture capability which enabled the executive team to make accurate and informed decisions. The system need was analysed, developed, tested and deployed in less than two days to meet ambitious targets set by the Government, and was a vital component in managing the successful program.

The system managed the collection and stewardship of data and, via integration, fed live reporting through to the preferred reporting suite.

In doing so, the program enabled the management of critical components including manufacturing timelines, essential compliance certifications and quality programs, and freight management components to allow for efficient load mastering, air charters, contract management, and delivery of goods into the NMSP across hundreds of stock movements by ground, sea and air from dozens of suppliers. It also served a historical record, demonstrating value-for-money delivered for the National Medical Stockpile.

The outcome

Whilst other governments and commercial organisations were facing challenges to analyse and deliver their critical goods, working in conjunction with the various actors in the program, we delivered all items in full and on time, providing the Commonwealth with confidence in the systems to procure further items through this supply chain.

Securing and managing Australia’s PPE supply chain Read More »