MS Excel: How to Create Relational Data Models, and use them in Pivot Tables and Charts


The video is a tutorial on how to create a relational data model using Microsoft Excel. The tutorial begins with an introduction to the concept of a data model and proceeds to show how to convert Excel sheets into tables before defining relationships between the tables to create a data model. The speaker emphasizes the importance of giving tables meaningful names and ensuring that the 'my table has headings' option is checked while creating tables. The video then shows how to add columns to tables and perform calculations, such as using the vlookup formula to import data from one table to another. The tutorial also shows how to add tables to the data model, create relationships between tables by dragging and dropping fields, and create pivot tables from the data model. The tutorial ends with a demonstration of how to create three pivot tables that summarize sales data by product, salesperson, and order type. The video concludes by highlighting the importance of having a well-designed data model in making sense of complex data. Chapters: 00:24 - Creating Tables in MS Excel 03:49 - Creating Relationships in Data Model 04:38 - Creating Pivot Tables using Data Model 07:36 - Adding Slicers and Timelines 10:23 - Adding a Detailed Report 13:11 - Adding Charts Link to the file: #MicrosoftExcel #DataModeling #RelationalDatabase #PivotTables #PowerQuery #TableRelationships #VLookup #ExcelTips #DataAnalysis #BusinessIntelligence


relational data model, Microsoft Excel, tables, relationships, data model, vlookup formula, power query, add to data model, pivot tables
© 2023 - Virtual School of Information Technology