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:
What is testing? (A closer look at big data testing)
Why test your data? An exploration of the benefits of testing.
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.
Testing in Qlik (Qlik Scalability Tools)
Discounting NodeGraph, there are not many tools available when it comes to testing in Qlik. However, if you are an avid “Qlikkie”, you will probably be aware of the existence of the Qlik Scalability Tools. These tools allow for simple creation, execution, and analysis of load/perform tests. To find out more about these tools, head over to our friend’s Rob Wunderlich’s blog post titled “Running QS Regression Test in Batch“.
And now we have reached the part when we would like to talk about our very own testing capabilities. We’ll keep it brief, and if you would like to find out more, you can request a personalized demo of our Data Quality Manager by clicking here.
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?