MS Excel: How to Create Relational Data Models, and use them in Pivot Tables and Charts
Description
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
https://virtual-school.org/tutorial?v=3gDtcT849Y0
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
Tags
relational data model,
Microsoft Excel,
tables,
relationships,
data model,
vlookup formula,
power query,
add to data model,
pivot tables