Blooms The Chemist

How Google Cloud Platform’s data capabilities enabled Blooms The Chemist to identify opportunities in real time.

Challenge

Blooms The Chemist is a retail pharmacy network comprising 86 pharmacies across NSW, VIC and QLD. Blooms Management Services provides centralised services to the network, partnering with pharmacy owners to achieve sustainable growth.

Blooms’ key sales transaction data, which the business relied on to understand and respond to customer behaviour, was locked up in an outdated and unreliable reporting tool.

Tech Products

  • Cloud Functions
  • Data Store
  • Compute Engine
  • IAM
  • Stackdriver
  • AppEngine
  • BigQuery

The existing reporting tool was error-prone and just not able to produce critical pharmacy-by-pharmacy sales reports fast enough.

Outcome

3

weeks to deliver data warehouse & reporting application

23

million rows of transaction data available for reporting

15

minute transaction data updates available in the cloud

Idea

The first order of business was to implement a more reliable and robust hosting solution for the raw data. Google Cloud Platform (GCP) was selected primarily for its massive data storage and processing capabilities.

All historical sales data was lifted into Google Cloud Storage, transformed into a relational data structure in BigQuery, and refreshed every 15 minutes. This took a team of 3 GrowthOps specialists just 4 days to complete.

Next we focussed on getting actionable data into the hands of users through a web-based Blooms Reporting Tool. After 3 weeks, the new reporting dashboards were in production, seamlessly delivering the reports that the legacy data application struggled to provide, plus some

No longer hampered by data access issues.

“We now have better visibility of our customer and sales data than we’ve ever had.”

Lee Savage

Business Lead, Blooms

After 3 weeks, new reporting dashboards were in production, seamlessly delivering reports that the legacy data application struggled to provide, and more.

Idea

In that 3 weeks, GrowthOps delivered to Blooms a new data extraction, transformation and load (ETL) process for historical and ongoing POS transaction data.

A streamlined web-based reporting tool was built to replace the legacy application, putting up-to-the-minute data into the hands of Blooms users. Critical sales reports that had previously taken over 6 minutes to generate were now available in a matter of seconds.

No longer hampered by data access issues, Blooms data scientists could now focus on interrogating over 23 million lines of transaction data to identify opportunities for innovation and growth.

Let’s do something incredible together.

Get in touch