|Task| Transform Data

Steps:

      Make a relationship from Product table to Sales table using the ProductKey from the Product table and SalesProductKey from the Sales table
      Hide the Column labeled SalesProductKey from the Sales Table

      Change the Summarization option of the CustomerKey column from the Sales table to be set to Don't Summarize
      Change the Summarization option of the SalesPerson column from the Sales table to be set to Don't Summarize
      Load the tables Salesperson, Customer and Region found in the Class Data [Data Folder

      Check the relationships and make sure Salesperson, Product and Customer are linked to the Sale table
      Check that there is a relationship between Region and the Customer table
      For each table add a brief description of the table and why it is used
      Hide the following fields:
        Sales[SalesPerson]
        Sales [CustomerKey]
        Customer [Location]
        Customer [CustomerKey]
        Salesperson [SalePerson]
        Product [ProductKey]
        Region [LocationID]

Complete and Continue