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