What are data models? They are just models, which you create, that allow you to combine data from multiple sources.
Why data models? In reality, you do not need to use data models at all. Filters, formulas, and pivot tables are sufficient for all your data needs. Data models, however, give you the ability to work with larger datasets than your typical Excel sheet can handle. They also allow you to combine data from multiple tables without using VLOOKUPS. The following example shows you how this can be done:
Select the pmthistory tab and then select any cell with data in it. Navigate to the INSERT tab and click on the PivotTable button, as we did in Analyzing data section of this chapter. Also, select the location where we want to place the table in cell D1. We will also need to check the Add this data to the Data Model option, as shown in the following screenshot. Finally, click on the OK button.
Click on the ALL tab, and you will be able to see all of your tables. This means that...