Question: Lab 5-2 Create a Dashboard Based on a Common Data ModelOklahoma Lab Note: The tools presented in this lab periodically change. Updated instructions, if applicable,

Lab 5-2 Create a Dashboard Based on a Common Data ModelOklahoma 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. Data: Lab 5-2 OK PCard ADS.zip;- 37MB Zip/30MB Excel/;17MB Tableau Lab 5-2 Objective Questions (LO 5-2, 5-3) OQ1. Which three categories received the most purchases? OQ2. Which date of this dataset had the highest total purchase amount? OQ3. How much was spent on the highest spending day? OQ4. Which business unit spent the most? OQ5. How much was spent by the biggest business unit? OQ6. Which user, represented by an actual name, spent the most? Lab 5-2 Analysis Questions (LO 5-2, 5-3) AQ1. What do you think the ePay Cardholder account is used for? AQ2. What would happen if you change the data source to another file that is formatted following the audit data standard for purchase orders? AQ3. How else would you analyze purchase transactions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Lab 52 Create a Dashboard Based on a Common Data Model Oklahoma Lab Case Summary The objective of this lab is to create a dashboard summarizing the purchase card transactions of the State of Oklahoma ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!