In this chapter, we have been through the process of loading data into a Qlik application. We have looked at how this process works, as well as the concept of Data connections, exploring how they can be created and reused. We also loaded data from different sources (an Excel file and a text file), adding a new field using the Data manager, and discussing that there is a script that is generated when you use the Data manager; this can be edited using the Data load editor. We also learned how to associate two or more tables to create a data model, and to check your data quality, view some metadata from the data you have loaded.

In the next chapter, we are going to discuss some basic data modeling concepts, as well as look at data modeling techniques that will improve our data model.