Required information

Skip to question

Lab Note: The tools presented in this lab periodically change. Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect.

Case Summary: The State of Oklahoma captures purchase card transaction information for each of the state agencies to determine where resources are used. The comptroller has asked you to prepare a dashboard summarizing the purchase card transactions using the data you transformed using the common data model. The Fiscal Year runs from July 1 to June 30.

OQ1. For the month of August, which category received the most purchases?

multiple choice 1

INDUSTRIAL SUPPLIES NOT ESLEWHERE CLASSI

COMPUTERS,COMPUTER PERIPHERAL EQUIPMENT,

LAB/MEDICAL/DENTAL/OPHTHALMIC HOSPITAL E Correct

OTHER FEES

OQ2. For the month of August, which date of this dataset had the highest total purchase amount?

multiple choice 2

2019-08-09

2019-08-01 Correct

2019-08-13

2019-08-05

OQ3. For the month of August, how much was spent on the highest spending day?

Note: Round your answer to the nearest whole dollar.

OQ4. For the month of August, which business unit spent the most?

multiple choice 3

OKLAHOMA STATE UNIVERSITY Correct

UNIV. OF OKLA. HEALTH SCIENCES CENTER

All of these

DEPARTMENT OF TRANSPORTATION

OQ5. How much was spent by the biggest business unit?

Note: Round your answer to the nearest whole dollar.

OQ6. For the month of August, which user spent the most?

multiple choice 4

W Matthews

0 01000

Linda Royal

e Cardholder Correct