Look Who it Was Random video

Excel - Excel in Depth 25 - PowerPivot Relationships - Episode 1211.125

2,542 views · Published 14 July 2010 · 1:50 · Indexed 29 September 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel in Depth 25 - PowerPivot Relationships.

Welcome to another chapter of Excel In Depth. In this episode, we will be diving into the world of PowerPivot and exploring the power of relationships. PowerPivot is a fantastic add-in from Microsoft that allows us to combine and analyze data from multiple sources.

In this tutorial, we will be looking at a classic mashup scenario where we want to see how sales are affected by weather conditions. We have two tables, Sales and Weather, and we want to link them together to create a relationship. This will allow us to easily analyze and visualize the data in a pivot table without any hassle.

To create the relationship, we will use the date column as the common key between the two tables. Since both tables have a date column, PowerPivot automatically fills in the necessary information for us. However, we can also explicitly create the relationship by right-clicking on the date header and selecting "Create Relationship". This gives us more control over the relationship and allows us to easily manage and update it in the future.

Once the relationship is established, we can create a pivot table and see the data from both tables linked together seamlessly. This is just one of the many benefits of using PowerPivot in your data analysis. So, if you want to take your Excel skills to the next level, be sure to check out our other Excel In Depth chapters and stay tuned for more netcasts from MrExcel. Thank you for watching and we'll see you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) PowerPivot Relationships
(00:18) Mashup of Sales and Weather data
(00:28) Setting up a relationship between tables
(00:38) Explicitly creating the relationship
(00:49) Creating a pivot table with linked data
(01:20) Benefits of using PowerPivot
(01:35) Clicking Like really helps the algorithm

This video answers these common search terms:
Common key between sheets
Creating relationships between tables
Excel In Depth
Linking tables in PowerPivot
Mashup data sets
MrExcel netcast
MrExcel podcast
Pivot table creation
PowerPivot benefits
PowerPivot Relationships
Sales and Weather tables


Define a relationship between two tables in PowerPivot.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152860/

More from this channel