The students should successfully import and validate the data, create calculated fields, and join the tables. Table 1 contains calculations that can be used to verify the calculated fields described in Case Requirement 1, i.e., Sales, Net Sales, Returns, and Purchases. Table 1 also contains additional calculated fields that are useful for preparing more in-depth analyses.
Without correctly importing and joining the data, the students will not obtain the correct results. Using the ERD diagram, the students should create the following joins (as depicted in Figure 1):
To create a join between, for example, Transactions and Employee Master, first drag Transactions to the data source canvas. Then also drag Employee Master to the data source canvas and place it next to Transactions (not on top of it). Now select TR Manager from the dropdown list and then Emp EmployeeID from the dropdown list below Employee Master.txt. Next verify that...
