Alteryx Case Studies LGAQ's Energy Saving Initiative through Alteryx

Edit This Case Study Record

	LGAQ's Energy Saving Initiative through Alteryx Alteryx

LGAQ's Energy Saving Initiative through Alteryx

Alteryx

Technology Category	Analytics & Modeling - Big Data Analytics Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries	Cities & Municipalities
Use Cases	Asset Lifecycle Management Usage-Based Insurance
Challenge	The Local Government Association of Queensland (LGAQ) was facing a significant challenge in managing and understanding their energy utilization, particularly in remote indigenous islands off the coast of New Guinea. The team had no clear understanding of their asset management or energy utilization for this area. They were using manual processes in Excel, Java, and MySQL for anomaly detection, which was time-consuming and inefficient. The team of four was doing the work of what twenty analysts should be doing, and they needed to increase their productivity drastically. The lack of a proper blueprint for energy saving and the use of multiple disparate points of data ingestion further complicated the situation. Read More
About Customer	The Local Government Association of Queensland (LGAQ) has been representing local councils since 1896, supporting their operations and strengthening relationships with their communities. The association connects people and places across all councils, supporting their drive to innovate and improve through smart services and sustainable solutions. LGAQ’s data and analytics team, led by Brodie Ruttan, principal of data analytics, is accompanied by data architect and governance officer Sunny Hussey-Smith, and business intelligence specialist Shane Dolley. The team provides solutions to all of their councils through data and analytics, assisting councils in energy, waste management, fleet, mobile, solar, and more. Read More
Solution	The LGAQ's data and analytics team, led by Brodie Ruttan, decided to leverage the Alteryx Analytic Process Automation Platform to automate their processes. They created macros around a single ingestion point to streamline the energy data input, replacing the multiple disparate points of entry. The team combined three technologies for an end-to-end process: Snowflake as the data warehouse to keep everything organized, Alteryx for data extraction, preparation, and blending, and Tableau for visualizing energy consumption and utilization. This solution not only automated their processes but also provided a clear and transparent analysis of energy consumption, leading to the discovery of major cost savings for the council. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Platform as a Service (PaaS) - Application Development Platforms

Applicable Industries

Cities & Municipalities

Use Cases

Asset Lifecycle Management

Usage-Based Insurance

Challenge

The Local Government Association of Queensland (LGAQ) was facing a significant challenge in managing and understanding their energy utilization, particularly in remote indigenous islands off the coast of New Guinea. The team had no clear understanding of their asset management or energy utilization for this area. They were using manual processes in Excel, Java, and MySQL for anomaly detection, which was time-consuming and inefficient. The team of four was doing the work of what twenty analysts should be doing, and they needed to increase their productivity drastically. The lack of a proper blueprint for energy saving and the use of multiple disparate points of data ingestion further complicated the situation.

About Customer

The Local Government Association of Queensland (LGAQ) has been representing local councils since 1896, supporting their operations and strengthening relationships with their communities. The association connects people and places across all councils, supporting their drive to innovate and improve through smart services and sustainable solutions. LGAQ’s data and analytics team, led by Brodie Ruttan, principal of data analytics, is accompanied by data architect and governance officer Sunny Hussey-Smith, and business intelligence specialist Shane Dolley. The team provides solutions to all of their councils through data and analytics, assisting councils in energy, waste management, fleet, mobile, solar, and more.

Solution

The LGAQ's data and analytics team, led by Brodie Ruttan, decided to leverage the Alteryx Analytic Process Automation Platform to automate their processes. They created macros around a single ingestion point to streamline the energy data input, replacing the multiple disparate points of entry. The team combined three technologies for an end-to-end process: Snowflake as the data warehouse to keep everything organized, Alteryx for data extraction, preparation, and blending, and Tableau for visualizing energy consumption and utilization. This solution not only automated their processes but also provided a clear and transparent analysis of energy consumption, leading to the discovery of major cost savings for the council.

Impact #1	The implementation of the Alteryx Analytic Process Automation Platform has empowered the LGAQ team to have confidence in their data and has reduced the need for IT support. The team has been able to do more with less, thanks to the single data ingestion point. Other teams within the organization have started to leverage the team's capability for more opportunities, including tariff analysis. The team is now seen as a subject-matter expert, changing the expectations when people approach them with a question. Looking ahead, the team is planning to analyze health and safety initiatives, rates for land usage and construction, and energy usage within different districts, and is confident about having the right tools at their disposal.

Impact #1

The implementation of the Alteryx Analytic Process Automation Platform has empowered the LGAQ team to have confidence in their data and has reduced the need for IT support. The team has been able to do more with less, thanks to the single data ingestion point. Other teams within the organization have started to leverage the team's capability for more opportunities, including tariff analysis. The team is now seen as a subject-matter expert, changing the expectations when people approach them with a question. Looking ahead, the team is planning to analyze health and safety initiatives, rates for land usage and construction, and energy usage within different districts, and is confident about having the right tools at their disposal.

Benefit #1	The team of four analysts is executing the work of 20 analysts, increasing productivity by 500%
Benefit #2	The team discovered major cost savings for the council through the analysis of energy consumption and utilization
Benefit #3	The team costs about two-thirds of what the larger team was previously, resulting in significant cost savings

Benefit #1

The team of four analysts is executing the work of 20 analysts, increasing productivity by 500%

Benefit #2

The team discovered major cost savings for the council through the analysis of energy consumption and utilization

Benefit #3

The team costs about two-thirds of what the larger team was previously, resulting in significant cost savings

Download PDF Version

Overview

LGAQ's Energy Saving Initiative through Alteryx

Operational Impact

Quantitative Benefit