Learn Microsoft Office 2019

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 ...