City of Insights

Published on the 29/06/2017 | Written by Qrious

Auckland City of Sails




  • Local Government


  • Create analytics platform for performance monitoring, management and statutory reporting, ad hoc analysis and reporting, and rates modelling.


  • WhereScape Red data warehouse automation, consulting expertise, training, implementation and support from Qrious


  • Improved analytics platform structure
  • Best practice delivery framework for planning, creating, testing, and deploying analytics system
  • Internal developers up-skilled through Qrious’s mentoring
  • Access to data science expertise
  • Analytics drives performance reporting and dashboards, ad hoc business data interrogation and reporting
  • System creates Local Board reports, supports the creation of Unitary Plan, valuations and consenting, and asset and financial management reports
  • Self-service access to reporting capabilities for data-driven decision-making.


T: 0800 500 331

How Auckland Council leverages data to drive daily business…

Along with the rollout of its SAP enterprise resource planning solution, known as ‘Newcore’, Auckland Council is seeking to improve its ability to serve the citizens of New Zealand’s biggest city through the targeted use of analytics. For this, it has worked with WhereScape and Qrious for several years to create a substantial analytics system which provides the foundation to help improve the Council’s operations.

The Auckland Council is the local government organisation for the Auckland region. The governing body consists of a mayor and 20 councillors, elected from 13 wards. There are also 149 members of 21 local boards who make decisions on matters local to their communities. It is the largest council in Australasia, with a $3 billion annual budget, $29 billion of ratepayer equity, and 9,870 full time staff as of 30 June 2016. The council began operating on 1 November 2010, combining the functions of the previous regional council and the region’s seven city and district councils into one ‘super city’.

Stephen Wearing, Business Intelligence Manager at Auckland Council, says there are multiple requirements for analytics within a modern council. “This includes performance monitoring, and both management and statutory reporting to meet the requirements of the Local Government Official Information and Meetings Act. We also use our analytics platform for ad hoc analysis and reporting, to categorise council activities by value streams, and for rates modelling.”

Data analytics, he points out, is a crucial component in equipping the Council to perform multiple functions effectively. With limited budgets and ratepayers expecting value for their contributions to the Super City, analytics provides the ability for the Council to operate efficiently.

With much at stake, the selection of an appropriate partner to create an analytics platform which can be accessed and used by multiple people and job roles within Council was essential, Wearing confirms. “Within Council, we have managers, analysts, data scientists and even the public who access and use our analytics services,” he says, noting that the platform therefore must be flexible and capable of meeting the requirements of diverse user groups.

“Within Council, we have managers, analysts, data scientists and even the public who access and use our analytics services.”
Stephen Wearing, Business Intelligence Manager, Auckland Council

The selection of Qrious to create and maintain Auckland Council’s analytics platform has its historical roots in the Council’s use of WhereScape’s RED data warehouse automation software for the creation of an enterprise data warehouse. The success of that project led to a master service agreement, with WhereScape’s professional services division – Qrious – providing the necessary expertise to maximise value from Council’s analytics investments.

Wearing explains that Qrious was selected based on its demonstrated expertise in data, as the raw material for analytics, as well as how information can be used to create business advantages. “Over the course of a multi-year engagement, Qrious has delivered numerous projects which, together, have resulted in the analytics platform and services which are widely used throughout Council,” he says.

In addition to the ‘mechanics’ of data analytics, including requirements gathering, data models and ‘ETL’ (extract, transform and load) activity, the engagement has also seen Auckland Council look to Qrious for thought leadership and mentoring in its quest for best practice analytics. Other services which have been provided include advisory services, architectural design for analytics systems, a best practice delivery framework, and project management of an end to end delivery.

Wearing adds that Qrious participates on the Council’s Business Intelligence and Analytics Panels, while the professional services firm provides access to additional experienced personnel to augment internal Enterprise Data Warehouse and BusinessObjects resources (the SAP business intelligence software used by Council).

He says that the quality of the interactions between the business users and that of Qrious has been an essential factor in the ongoing success of the project; it is a common challenge for business users and BI consultants to ‘talk past one another’. “The Qrious team, however, has proven accessible and exceptionally helpful in assisting our people to understand, learn and use analytics for business advantage.”

Probably the biggest challenges faced by Council over the course of the engagement, Wearing notes, was the difficulty in gathering business requirements, and building capability around BusinessObjects.

Thanks to its engagement with Qrious, Auckland Council has an improved structure for its analytics platform, which Wearing says is the result of the implementation of the best practice delivery framework for planning, creating, testing, and deploying the information system. “Furthermore, our internal developers have been up-skilled through working with and receiving mentoring from Qrious’s people, who have also provided the additional capacity we have needed to get this large and complex system operational,” says Wearing, also singling out Qrious for its consistent application of best practice throughout the engagement.

But it is what the data analytics platform does for Council which is most important. It sits behind a wide range of essential functions including performance reporting and dashboards, ad hoc business data interrogation and reporting, through self-service, with further options for ‘power users’ to flexibly access the system and develop their own reports.

Wearing says the benefits of this system flow directly down to ratepayers. “This system stands behind democracy services and elected members. It is instrumental in creating Local Board reports, it supports the creation of the Unitary Plan by processing information from Geographical Information Systems and Rating Information Databases. The analytics platform has a role in creating valuations, and it supports the various consenting activities carried out daily by Council; finally, it is also used for the creation of asset and financial management reports.

With the value of analytics firmly established for Auckland Council, Wearing says there are future intentions for deeper and broader use of data insights. “We’re looking to create more business targeted insights, empowering various units within Council with accurate insights. We’ll be trialling and evaluating additional products in due course.”

Qrious acquired NOW Consulting, the New Zealand-based data consulting division of WhereScape Software, in September 2019. This case studyrefers to work done by NOW Consulting prior to this acquisition.

Source: This article was originally sourced from Qrious


About This Vendor

More Case Studies

NZ Cricket player data and analytics solution

A game-changing data solution for New Zealand Cricket

October 10, 2019 | Qrious

Implementation of an innovative data and analytics solution to improve player performance and gain an edge over the competition…

Video_Nathan Griffiths_Xero_NOW Consulting

The data secrets behind Xero’s cloud migration

November 28, 2018 | Qrious

Moving 59 billion records to AWS Redshift no job for a forklift…

Abano Health Microsoft Azure video

Drilling for value: Dental group does ‘Datability’

October 25, 2018 | Qrious

Abano Healthcare migrates data warehouse to Azure, achieves cost savings, accelerates innovation and data value…


How data insights contribute to a healthier population

March 7, 2018 | Qrious

East Health pioneers data culture for information-driven healthcare decisions…


How data analysis underpins Lotto NZ’s operations

July 5, 2017 | Qrious

Visual reporting tools are delivering insights to senior execs and local dairy owners alike…

Follow iStart to keep up to date with the latest news and views...