Alteryx > Case Studies > LGAQ's Energy Saving Initiative through Alteryx

LGAQ's Energy Saving Initiative through Alteryx

Alteryx Logo
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
About The 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.
The 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.
The 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.
Operational Impact
  • 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.
Quantitative Benefit
  • 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

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.