This chapter has had a lot of really important information. We started by reviewing what you should already know about associating data. You learned important information about keys and autonumbering and the level of calculations used in QlikView. We also reviewed the different methods of stitching data together—join, concatenate, and mapping.

We then moved on to talk about dimensional data modeling, fact and dimension tables, and best practices from Ralph Kimball. You learned how to handle SCDs and multiple fact tables and how to drill across tables.

The previous chapter dealt with loading data for performance. The next chapter will help us continue our learning of how best to load data, building QVD layers, to support a dimensional modeling approach.