Testing in Qlik - A guide to testing with NodeGraph's Data Quality Manager | NodeGraph
Testing in Qlik - A guide to testing with NodeGraph's Data Quality Manager
So far, we have discussed what testing is and why you should be doing it. If you missed these pieces, we recommend giving them a quick read before we dive into the "how" of things. You can find them here:
This article will continue the testing discussion and will focus on how you can test your business intelligence solution, specifically in the Qlik environment, and will also shamelessly explore how NodeGraph is able to test your data.
Ensuring consistency, currency, and reasonableness through testing
In general terms, the testing capabilities in our Data Quality Manager allow you to ensure that your business intelligence solution (i.e. your Qlik Solution) is:
Consistent (i.e. is your data and logic harmonious throughout your solution?)
Current (i.e. is your BI solution updated, reloaded, and up-to-date?)
and Reasonable (i.e. is your solution reasonable, accurate, and valid?)
To further simplify the testing process, we have divided our capabilities into three separate parts, i.e. the three different stages of transformation in which NodeGraph is able to analyze your data. These are:
Raw (/Input) Data
Let's begin with the input data. Our tests make sure that your static data remains unchanged and consistent, that your data is properly reloaded and current, and that new data has reasonable values (ex. it's within your defined range or cumulatively larger today than it was yesterday).
Furthermore, NodeGraph enables you to ensure that your business logic and transformations are up to par. For example, is your logic consistent over time and is it compatible with new changes and recently added data?
Last, but certainly not least, our capabilities include testing your Qlik Sense applications (i.e. dimensions, expressions, and values for the entire app). You are also able to test your data source values against values in your presentation layer.
Before we wrap up, we would like to introduce our baseline test. Our baseline test refers to a standardized benchmark test that can be reused as a testing reference point. This allows for effective quality assurance without constantly setting up new tests.
For example, you might use a baseline test to keep track of a particular Qlik Sense application and all of its content. By choosing said Qlik Sense application and selecting a certain date or date range, the baseline test will answer the following:
Have I added any sheets or objects?
Have I removed any sheets or objects?
Have any sheets or objects (or their containing values) changed?
Get started with testing
Do you want to learn more? Then request a personalized demo of our Data Quality Manager today by clicking below.