From the course: Excel: Working Together with Power Query and Power Pivot
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build relationships
From the course: Excel: Working Together with Power Query and Power Pivot
Build relationships
- With the Excel exercise file for this video open, make sure that you have the Power Pivot data model open by selecting Power Pivot, and then clicking on Manage. Now let's go ahead and click on Diagram View. And you'll see what we have here, two data sources in our data model. But before we can start making the most of Power Pivot's relational database features, we have to link these two tables together. Why, you might be wondering? Well, if we go back to the Data view here, what you'll notice is that we have a field called Type in the Location Type tab, but this field here doesn't appear anywhere in the EV Sales, but we want to include that field here somewhere so that we can do some deeper analysis later on. Luckily, we have a common field that can link the two together. And that's called City in this table called EV Sales. We're going to use this field to link the two tables together. In the Excel world, this is…
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.