In the previous sections, we saw what are the common challenges or pain points in data modeling and how to tackle them. With this knowledge set, you can easily start building the data models for Qlik Sense. But there are couple of things which you should know in order to develop the best data model for a Qlik Sense project, which is effective, robust, and flexible in nature.
To do this, there are few points which you should be aware of:
- modeling schema: In data modeling, we had seen that the Star schema is the best suited schema modeling for Qlik Sense projects. Following image shows the comparison of the schemas from Qlik Sense project perspective:
- Avoid joins: At times, there are cases when we need to get fields from different tables into a single table to achieve some calculations or business logic. To do this, the first option which comes...
