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

Using WhereScape RED and NOW Consulting (now Qrious) Professional Services, they've built and automated their data warehouse and business processes.

Spark Retail Stores engaged NOW Consulting to manage the transition to new infrastructure across several environments. During the delivery of this server migration, several complex challenges arose, which were resolved efficiently by NOW, resulting in the project being delivered on time.

NOW Consulting also showed initiative by up-skilling a key member of Spark Retail Stores’ team who is involved in the daily data warehouse operations. Over a six-month period, NOW provided RED training as well as mentoring in data warehouse best practice and technical skills. This has been particularly valuable to Spark Retail Stores because it increased their autonomy and has reduced costs.

Difficulty of vast, manual data input

Spark Retail Stores asked NOW Consulting to improve their commission reporting for their Door-to-Door business unit, who sell Spark products and services to consumers, businesses and wholesale markets.

Precise reporting is critical for Spark Retail Stores as it enables them to communicate targets to Spark Retail Management as well as make accurate and timely commission payments.

The existing reporting system was extremely manual, labour intensive and prone to errors, so Spark Retail Stores engaged NOW Consulting  to find a solution.

Ease of automated commission reporting

From the ground up, NOW built an automated reporting solution for Door-to-Door commissions and target reporting, using a complex set of business rules and Excel spreadsheets.

By breaking down the problem into simple iterations, NOW were able to reverse engineer the data and rules to create an accurate, automated reporting repository. 

Spark Retail Store’s new commission reporting is now processed and delivered to its users automatically via the Biztrack business reporting hub.  This new solution provides management reporting as well as valuable drill-down functionality, which offers additional data visibility and easier access for business users.