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