Understanding data models

In a nutshell, data modeling is when you combine data from multiple sources to analyze the data further using various tools in Excel 2019. By multiple sources, we mean all the import options offered under the Get & Transform feature and in the analysis tools used in Excel 2019. In the previous sections, you learned how to use the PivotTable and PivotChart tools and you were introduced to the Data tab of the Excel environment, where you can get and transform data from different sources. Data models are created in a workbook; you can only have one data model per workbook. Any table that exists in Excel can be added to the data model and table relationships can be defined across them. So, essentially, a data model is the loading of tables into Excel's memory. It is important to note that you do not physically see a data model in your worksheet.

...