Case Study 3

Import the ch06_charges.tsv and ch06_approved_vendors.tsv data sets into your analysis software. These files give a list of purchases and vendors that are approved for use, respectively.

Questions

1. Are any vendors used that are not approved vendors? If so, list the vendor names and the employees who used these vendors. What follow-up steps should be taken on these vendors?
2. Were any vendors unused by the purchasing department? What does this fact tell us about these vendors?