Best Practices in Data Modeling
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 to mind is to join those tables and make a single table. Though join is one of the options, but there are few points which...
