Explore the data to assess which Suppliers aren’t listed on any Purchase Orders.
accounting
Description
1. Connect to the Lab 4-t Alt Data.xlsx dataset through Tableau.
2. Add the Suppliers table to the Data Source.
3. Join in the Purchase_Orders table—first as an Inner join, then edit it to be a Left join. Notice how the number of records changes when you switch to a Left join.
4. Explore the data to assess which Suppliers aren’t listed on any Purchase Orders.
- Take a screenshot of your filtered list of Suppliers without Purchase Orders. Label it “Lab 4-5 Alt Submission 1.jpg.”
- Return to the Data Source window, and take a screenshot of your joined tables. Label it “Lab 4-5 Alt Submission 2.jpg.”
