From the course: Introduction to Career Skills in Data Analytics
Join today to access over 25,100 courses taught by industry experts.
Modeling data for Power BI
From the course: Introduction to Career Skills in Data Analytics
Modeling data for Power BI
- We will work with different data in different data sets or tables to do analysis and visualization. When we have multiple tables that we're working with, we'll want to model our data to get the most out of it. When you have an entity relationship diagram where the tables and relationships are showing in a model, you're actually seeing the model of the data. Now I've already connected data to my Power BI Desktop and on the right hand side, you see my fields list. I have different tables of information required for my reporting. It appears that I'm ready to go but I need to go one step further. These data sets are meant to be joined together. There are several ways to join and model data in Power Query for Power BI. When we perform merge queries, for example, we're actually establishing a join but we can also go to the modeling section and model this data from the very beginning and this allows the data to communicate through…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.