Alteryx Case Studies LGAQ's Energy Saving Initiative through Alteryx
Edit This Case Study Record
Alteryx Logo

LGAQ's Energy Saving Initiative through Alteryx

Alteryx
Analytics & Modeling - Big Data Analytics
Platform as a Service (PaaS) - Application Development Platforms
Cities & Municipalities
Asset Lifecycle Management
Usage-Based Insurance
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
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
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
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.
The team of four analysts is executing the work of 20 analysts, increasing productivity by 500%
The team discovered major cost savings for the council through the analysis of energy consumption and utilization
The team costs about two-thirds of what the larger team was previously, resulting in significant cost savings
Download PDF Version
test test