MS Excel: How to Create Relational Data Models, and use them in Pivot Tables and Charts
DescriptionThe 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.
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: https://docs.google.com/spreadsheets/d/14JnTnSlElGJ1TDoZ8H2mPuu6zasJlXmk/edit?usp=share_link&ouid=110287700425339553017&rtpof=true&sd=true
#MicrosoftExcel #DataModeling #RelationalDatabase #PivotTables #PowerQuery #TableRelationships #VLookup #ExcelTips #DataAnalysis #BusinessIntelligence
relational data model,
add to data model,