Fitness & Lifestyle Group Case Study: ETL for Data Migration During Acquisitions

Creating a data wellness strategy that positively impact people’s lives
Fitness Lifestyle Group (FLG) is Asia-pacific’s leading health and wellness group, based in Australia. FLG exists to make a meaningful, positive impact in people’s lives through innovative and diversified health and wellness offerings across
physical and digital platforms. To fulfill its mission FLG modernized its data warehouse and streamlined data operations. Now FLG gains valuable insights, quickly, that help power the business and better serve customers.
Company: Fitness & Lifestyle Group
Location: Queensland, Australia
Industry: Health, Wellness and Fitness
Employees: 6,500+
Product: Matillion ETL for Snowflake
Use Case: Data Warehouse Modernization in the Cloud / Data Warehouse Migration / Reporting Analytics / Data Visualization
Website: https://www.fitlg.com/
FLG quickly realized it needed a new cloud data warehouse (CDW) to standardize data framework and streamline its business operations. FLG also needed a way to quickly and efficiently move data from various source systems into its CDW and to transform that data in order to update its data visualization tools.
The elasticity and scalability afforded by the separation of storage and compute power led FLG to select Snowflake as its CDW. This architecture enabled FLG to build a true data lake with no performance degradation or failure on storage. FLG needed a way to get their disparate data from a myriad of cloud and legacy systems into Snowflake, in a format ready for analysis – all delivered in line with their cloud strategy.
Matillion enables us to be truly cloud-based and data-driven with its approach to data transformation that is purpose-built for Snowflake.
Adam Skinner Chief Data & Technology Officer (FLG)
For Peter Ilic, Head of Analytics at FLG “Matillion and Snowflake are made for each other”; with both solutions in place, FLG has reduced the time it takes to run a 100MB load and transformation job from one hour to under five minutes! Having near instant access to their data enables FLG to serve their customers a personalized journey to health and wellness in near real time. Using Snowflake and Matillion, which really “is reliable and the quickest data transformation solution available”, Ilic, Skinner and the data analytics team are directing user journeys and empowering customers. This is supported by sales, who benefit from up-to-date dashboards and reports. The data in these reports tell sales what information they should provide to prospects making the customer journey more meaningful, resulting in improved conversion and sales completion metrics.
The Business Intelligence team is now able to see near instant dashboard updates. Instead of waiting up to 24hrs to run marketing activities, FLG can act within seconds. FLG’s success in providing hyper-personalized customer journeys with Matillion opens up new opportunities for automation and efficiency throughout the business. Looking to the future, FLG will continue to grow the ‘brain of the organization’, easily plugging in new data sources from newly acquired entities and other departments of the business to serve the entire organization across their various functions. In this way, FLG is creating a data-driven culture for better results.