For WizardKim-CSW5

Internal control

Test to perform and desired output

What to name query/file with output if asked or print screen for template

Review the data for BioPhirma

Use the same data that was already loaded in from Week 3 Case-Week 3 Analytics Mindset Case Study BioPhirma

1. Only authorized PCard holders may use the cards

Opening the transaction file, join the file with the Authorized PCard Users files (Analysis, Join) and determine if there are any exceptions based on Employee Name by looking for items with no secondary match

Question51

2. PCard holders must only use authorized Vendors

Go back to the transaction file, join the file with the Approved Vendor list and determine if there are any exceptions based on Vendor Name (Question52). Using the Question52 file Summarize by Vendor name (Question52a) and sort by the highest number of records

Question52, Question52a

3. Verify cardholder’s limits

Go back to the Transaction file and join with the Authorization PCard Users file. You are only going to want to view a few of the fields in these 2 files. On the transaction file, select just the fields for employee name and amount (be sure to clear out the other fields listed). On the Authorization file, just the employee name and single transaction limit fields (be to clear out the other fields listed). You are going to match the 2 files based on employee name and select select all records in both files (Question53). Using the file Question53 you just created, extract out the amounts over the employee limit (Question53a).

Question53, Question 53a

4. Run any other 2 test you feel are needed based on the case analysis so far

You must justify the tests you run based on what you found so far in the data. This may include: duplicate items, missing items, gaps, summarization, searches, etc.

Question54, Question55

Display a copy of the IDEA History File for this case

History