Explanation

Power BI can create a relational Data Model containing multiple related tables.

Example

             Products

                 │

                 │

Customers ─── Sales ─── Employees

                 │

                 │

              Calendar

Example Tables

Sales

  • OrderID
  • Date
  • CustomerID
  • ProductID
  • EmployeeID
  • Quantity
  • SalesAmount

Products

  • ProductID
  • Product
  • Category

Customers

  • CustomerID
  • Customer
  • City

Employees

  • EmployeeID
  • Employee
  • Department

Relationships

Products[ProductID]  → Sales[ProductID]

Customers[CustomerID] → Sales[CustomerID]

Employees[EmployeeID] → Sales[EmployeeID]

Calendar[Date] → Sales[Date]

Practice

Build a Power BI model using Sales, Products, Customers, Employees and Calendar tables.

PreviousNext