Profiling using the Data manager

You can access information about every field and table of your model with this step: 

  1. Go to Data manager, select the Orders table, and click the small pencil that lies at the bottom, entering the table editor mode that shows a preview of your data, which shows some information about the table:

In the preceding example, we can see that the Orders table is selected and that the OrderID field is highlighted. Here, Qlik Sense will display information about that field. We can see the following information:

  • The Orders table has 16 fields and 830 rows
  • The data comes from an Excel file (Orders.xlsx)
  • There are 830 distinct values and 830 total values, so we can deduce that there are no duplicate values in the table
  • This field will be considered as a Dimension, so Qlik will not propose aggregations (count, sum, average, max, min, or others) for that field

If we select the EmployeeID , we will see the following:

For this field, we can see that there are some duplicate values, since we have only nine distinct values. Qlik generates a histogram for each value, showing how many values there are for each combination, so that we can check that value distribution makes sense and does not indicate data quality issues.

If we select the Freight field, we are going to see that this field will be considered as a Measure, so Qlik Sense will propose aggregations (count, sum, average, max, min, or others) over this field and Qlik also provides some statistics about it (minimum, median, average, and maximum values):

We will now move on to understanding how to profile with a Data model viewer.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset