Data modeling Validation

Data validation is one of the critical and important points which is neglected by most of the developers. We will look at this point in detail in the next chapter, but I want to discuss briefly about validation of the data model. While developing the data model with best practices, we sometimes mess with the code and make small mistakes, which may not be wrong syntactically but may be wrong from data perspective.

Thus, it becomes important to do a preliminary validation of the data model to make sure that after doing all the calculations and linkage between the tables, the data gets populated correctly, which further helps in avoiding data related queries after entire development is done.

There are couple of things which you should do for data modeling validation. Let us have a look at them.

Row Count

This is a common way of finding if the data loaded in Qlik Sense matches with the source data or not. It is very simple to find the numbers of records loaded after Qlik...