Building a cloud-based data warehouse based on a Data Vault design principles

Let's talk

Our client is one of Australia’s largest health insurance providers with more than 3.5 million members. Its strategic drive to increase competitiveness and reduce cost has had direct implications on the organisation’s approach to BI & EDW.

The Challenge

The organisation’s industry model-based enterprise data warehouse, tightly coupled to its legacy operational systems, lacked flexibility and provided challenges to integrate data across the full breadth of the organisation’s brands and channels into one central source of truth. The high cost, complexity and time it was taking to respond to changes prompted the organisation to rethink its approach.

It was concluded that a new strategic platform was required to support enhanced decision-making and cross-functional, insight, and that was both cost effective and fit for purpose.

The Solution

A project was initiated to build a new, cloud-based data warehouse based on a Data Vault design principles, to support both analytics and report delivery use cases. Fast innovation and exploration were to be core design principles.

Analytics8 was engaged for its proven track record of successful EDW implementations with the Data Vault methodology. With the Acceler8 Data Foundation Accelerator A8 provided the software and methodology needed for rapid data integration development to integrate a large number of source systems to achieve the desired 360-degree view of the organisation.

Our consultants provided technical leadership for the EDW implementation team, advised on Data Vault design best practices and provided technical Acceler8 support while the internal team received training in the use of Acceler8.

Results

Acceler8 proved itself in an enterprise scale EDW environment, allowing the development team to generate and regenerate thousands of jobs – over and over again – very quickly. This enabled an iterative prototyping approach to the discovery of rules and requirements and allowed the team to very quickly respond to changes in data, process & concepts, and fine-tune technology and performance on the fly.

Let’s Talk.

Analytics8 is an Australian-based analytics, business intelligence and data warehousing consultancy founded in 2002. Our vendor-agnostic team of 60+ consultants has deep expertise and implementation experience. We specialise in design, development and deployment of effective data solutions. 
Talk to us about how we can improve demand planning accuracy within your business.

[email protected]

Sydney: +61 2 9299 4430

Melbourne: +61 3 8605 4880

  • This field is for validation purposes and should be left unchanged.
Sydney:

Suite 1, Level 5,

350 Kent Street,

Sydney, NSW, 2000

+61 2 9299 4430

Melbourne:

Level 8,

350 Collins Street,

Melbourne, VIC, 3000

+61 3 8605 4880

Not based in Australia? Our team in the UK or the US would be happy to help.