How to refine your data and link your tables in Power BI
Power BI Video 2: Refining & Linking Data
In this video, which is the second in an introductory series, we build on what we learned in the first video and learn how to refine our data in Power BI by looking at data types, data formats and data category as well as summarization. We will also learn how view our data table using the model view and see how they are linked together as well as linking them manually if needed. This will set us up nicely for the next video in this series where we will start using the elements in those linked data tables to create visual elements in our Power BI report.
📊 Power BI Series:
Getting Data
Refining and Linking Your Data (this video)
Creating Visual Elements
Using Slicers to Gain Insights
Share Report To Wider Audience
Chapters:
0:00 Introduction & recap
0:44 Data disclaimer
0:56 Switching to table view
1:07 Field properties: data type vs. data category
1:34 Assigning geographic data categories (city, province, country)
2:24 Test scores table & summarization options
3:05 Date hierarchies
3:17 Subject category table
3:41 Linking data in the model view
4:00 Understanding existing relationships
4:22 One-to-many relationships explained
5:04 Manually creating a relationship
5:54 Recap
For more information on basic Power BI skills, see my Power BI Basic Guide at https://lib.unb.ca/guides/power-bi-ba...
Intro and outro music from Stereoalex at https://icons8.com/music/track/synthw...