Rich data meets reliable cloud analytics

At a glance

Formerly known as the Queensland Government Chief Information Office (QGCIO), the Queensland Government Customer and Digital Group (QGCDG) is responsible for ensuring the state Government’s ICT investments are reliable, support policy outcomes, focused on service delivery, and represent good value for money.

QGCDG have been collecting and managing significant data sets across the Queensland Government for decades, and over time found their existing processes to be ineffective and costly.

We helped QGCDG seamlessly migrate and manage their data within a secure cloud environment, and continue to manage and upgrade their analytics environment to take advantage of the latest cloud technologies.

Services provided

  • Data analytics
  • Data visualisation
  • ETL development
  • Data migration
  • Database management
  • Managed Services

Technology used

Solutions and products involved

  • Amazon_Relational Database Service

    Amazon Relational Database Service (RDS)

  • Amazon_Lambda_architecture_logo

    Amazon Lambda - Serverless Compute

  • Amazon_Elastic Compute Cloud_EC2

    Amazon Elastic Compute Cloud (EC2)

  • Amazon_Simple Storage Service_S3 (2)

    Amazon Simple Storage Service (S3)

  • Amazon_Elastic Load Balancing

    Amazon Elastic Load Balancing (ELB)

  • Amazon_Virtual Private Cloud

    Amazon Virtual Private Cloud (VPC)

The challenge

Ineffective data management creating unreliable decisions

The QGCDG provides advice to Queensland Government agencies and executive Government on setting ICT strategy, adopting better practice for ICT investment management, identifying and managing risks, identifying and managing strategic workforce capability issues, facilitating strategic relationships with industry partners, and more.

Collating from a rich data source over the years means having to securely manage as well as cleverly visualise that data to create informed decision-making opportunities. Over time, the existing legacy system became ineffective, unreliable, and costly.

In 2014, the QGCDG launched a tender process to find the right partner to help migrate their system to the cloud and expertly manage their data sets.

Brisbane cars lights
office building with cloudy sky

The solution

Creating clarity with the cloud

From winning the tender in 2014, we underwent a thorough discovery session with the QGCDG team to establish a formal and strategic transition plan, which included generating a change control document to ensure that the migration to the cloud will be successful.

A key piece of the solution was to develop a managed service for the Analytics Platform. This gives the QGCDG team a secure and private analytics environment to view and manipulate existing visualisations and models.

We then migrated and upgraded an existing Microsoft database to store, collate and transform the base data sets, followed by upgrading the environment with multi-factor authentication (MFA) as well as more advanced user administration and system logging.

This project leveraged AWS technologies including Amazon Relational Database Service (RDS), AWS Lambda – Serverless Compute, Amazon Elastic Compute Cloud (EC2), Amazon Simple Storage Service (S3) Buckets, Amazon Elastic Load Balancing (ELB), and Amazon Virtual Private Cloud (VPC).

dots squared pattern

"Strategenics offer a very responsive service for an affordable price. The service they have provided us for the past 5 years has been reliable with almost no outages.

They shield us from having to understand the nuances of AWS configuration and allow us to focus on our business activities."

We've helped hundreds of organisations exceed their digital transformation ambitions

Let's talk about your next project

No matter what stage your project is in, or what in-house expertise you currently have, we'll help develop a plan that works for you and your team.

Book a meeting to chat with one of our consultants. Alternatively, click here to leave us a message about your project.