From the course: Learning Power BI Desktop
Join today to access over 24,900 courses taught by industry experts.
Prep to combine multiple tables
From the course: Learning Power BI Desktop
Prep to combine multiple tables
- [Instructor] In this next series of movies, we're going to use the data shaping tools of Power BI Desktop to create a model built from multiple tables. Most of these tables are included in an Excel workbook called CountryPops.xlsx, you'll find in the chapter 4 folder of the exercise files. I want to give you an idea about what we have and what we're trying to accomplish. In our workbook, the very first sheet is population growth rate. It lists countries and their growth rate, it has four columns. And all we get is the name of the country and their growth rate. 233 countries, some of which are territories. Then we have population by country. And this lists a country and its population as of a date of record in column D. That percent of the world population that that country represents, the source. And then there is a key column. And if I scroll to the bottom, we have 244 entries. Then I have a worksheet tab for each continent that lists four columns. A place for a flag, the name of…
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.