In this chapter, we will cover a series of tasks to load data from several sources such as text files or Excel spreadsheets. We shall find data quality issues (such as null values in a field) with data profiling and create the data model associating the data source using key fields to link the tables.

The following topics will be covered in this chapter:

• Data loading process
• Loading data from data sources
• Table associations
• Data profiling