Data Warehouse case study PDF Print E-mail
Knoware was instrumental in developing the first major data warehouse in New Zealand, starting in 1996. It is still one of the largest data warehouses in New Zealand. It takes data from multiple source systems, supports over 100 analysts in five different government departments, and provides customised reporting to several thousand users through an Intranet.

It records a full unit record history of all events for all systems. With this history it can recreate reports as at any given point in time, and track all events, for all clients, through any period of time and across all data systems.

Verification processes regularly prove that the data in the warehouse is correct.

Metadata is generated and maintained by the data warehouse system. This supports the work of the analysts. It documents the rules on how to use the data, and guarantees the quality of the information.

Security controls appropriate access to the data: analysts only see the data they need to do their work.

Front line staff around the country can access information without the need to learn complex software, data or systems. They can point and click, slice and dice, drill down, and explore. For the client, this has created a whole new way of managing and operating their business.

Portals provides secure access to case load and case management information for around 4,000 front-line staff in service centres around the country. Staff can generate standard reports when they like; or customize and filter their own information.

Knowledge transfer means that the data warehouse is now fully operated by the client. And like any successful data warehouse project, it continues to grow.

"it is very satisfying to know that this warehouse continues to provide the sound
infrastructure that's so important to high quality information delivery."

Clare Somerville, Knoware Director

 

250 Years' Experience...

Our strong association with SAS Institute, and over 250 years of SAS programming experience (amongst 18 of us), allows us to provide the bulk of SAS training programmes in New Zealand on SAS's behalf.

servers

Design delivery...

and support. We provide services to implement a complete Business Intelligence or Data Warehouse solution, or just a component of a solution, e.g. the ETL component or a web reporting capability. Learn more... [Data Warehouse case study]

Harnessing knowledge...

deepInThought

Decision making based on timely & accurate information.

Design and Implement...

dollarKeyboard

solutions that are effective and enduring.

User requirements...

analysis. To determine and document what all future users of the Business Intelligence solution require from it. Part of this process is enlightening people as to what is possible from a Business Intelligence system