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.
Such a large and complex organisation generates a significant amount of data, and converting that data into information that is valuable to management, staff and students is critical.
Fast, agile and accurate data transformation had long been identified as crucial to business intelligence and reporting functions, but a rapidly ageing data warehouse and its tooling to extract, transform and load data (ETL) were struggling to deliver. While it had served the University well, it was reaching its end of life and needed replacement. A lack of experienced local support resources made the University largely reliant on a single vendor, which was adding significantly to support costs. The decision was made to retire the old solution (Oracle Warehouse Builder or OWB).
Nicola Jackson, the University’s BI and reporting delivery manager knew that a simpler data warehouse environment was needed that could be supported with more in-house expertise. Not only would this be more cost effective but it would also enable faster, more agile work.
“We’re trying to do more agile delivery and produce the ETL faster. We were running OWB, and urgently needed to find an up-to-date technology.”