After creating relationships between tables, make use of the data for analysis.
- Click any cell on the worksheet
- Click Insert > Pivot Table
- In the Create PivotTable dialog box, under Choose the data that you want to analyze, click Use an external data source
- Click Choose Connection.
- On the Tables tab, in This Workbook Data Model, select Tables in Workbook Data Model.
- Click Open, and then click OK to show a Field List containing all the tables in the Data Model.