Connection builds a relationship

The power of Power Pivot is its ability to create relationships between different datasets. This allows you to analyze all your data together, gaining deeper and more valuable insights.

As an analyst at Pivotal Mortgage, you've been tasked with gaining deeper insights into sales performance by team. Therefore, you should create a relationship between sales_team and loan_data.

• sales_team is a dimension table that gives context about each employee. There is only one of each employee.
• In the loan_data table, employees can write many loans, so their employee ID's can be found many times.

Continue working in your current workbook. If you've lost progress, open 1_2_power_pivot.xlsx from the Workbooks folder in the course materials.