Explanation

Relationships tell Power Pivot how tables are connected.

Example:

Products[ProductID]

        1

        │

        │

        ∞

Sales[ProductID]

This is a one-to-many relationship.

One product can appear in many sales transactions.

Steps

1. Add tables to the Data Model.
2. Open Power Pivot → Manage.
3. Switch to Diagram View.
4. Connect matching fields.
5. Verify the relationship.

Example Relationships

Primary Table	Related Table
Products[ProductID]	Sales[ProductID]
Customers[CustomerID]	Sales[CustomerID]
Employees[EmployeeID]	Sales[EmployeeID]
Calendar[Date]	Sales[Date]

Practice

Create all four relationships in the Business Data Model