Microsoft $|$ Excel $+$ Power Query

Open the Lab $2-2$ Slainte Model.xlsx you created in Part $1.$

Click the Insert tab on the ribbon and choose PivotTable.

In the Create PivotTable window, click Use this workbook's Data Model and click OK$.$ A PivotTable Fields pane appears on the right of your worksheet.

Note: If at any point while working with your PivotTable, your PivotTable Fields list disappears, you can make it reappear by ensuring that your active cell is within the PivotTable itself. If the Field List still doesn't reappeat, navigate to the Analyze tab in the Ribbon, and select Field List.

Click the $>$ next to each table to show the available fields. If you don't see your three tables, click the All option directly below the PivotTable Fields pane title.

Drag Sales$\_$Order.Sales$\_$Order$\_$Date to the Columns pane. Note: When you add a date, Excel will automatically try to group the data by Year, Quarter, and so on$.$

a$.$ Remove Sales$\_$Order$\_$Date $($Quarter$)$ from the Columns pane.

Drag Finished$\_$Good$\_$Products.Product$\_$Description to the Rows pane.

Drag Sales$\_$Order$\_$Lines.Sales$\_$Order$\_$Quantity$\_$Sold to the Values pane. Note: At this point, a warning will appear asking you to create relationships.

Click Auto$-$Detect... to automatically create relationships in the data model.

a$.$ Click Manage Relationships... to verify that the primary key$-$foreign key pairs are correct:

Sales$\_$Order$\_$Lines $($Product$\_$Code$)=$ Finished$\_$Good$\_$Products $($Product$\_$Code$)$