In this chapter, we learned about the data modeling techniques. We started with learning about the basics of data modeling. We looked at two types of data modeling: entity relationship modeling and dimensional modeling. We looked at dimensional modeling in detail and learned about the two widely-used data modeling schema: the star schema and the snowflake schema. We learned about which schema works best with Qlik Sense and why.
Moving ahead in chapter, we learned about different types of joins. We learned about what type of join is used for what purpose and what kind of output they generate. Then we looked at the pitfalls of using joins. It is important to keep thses in mind while using joins. Then, we learned about concatenation and the scenarios in which we should use the concatenation option. We also looked at automatic concatenation, forced concatenation, and NoConcatenation...