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 Case Summary The goal of this lab is to prepare a dashboard summarizing purchase card transactions for the State of Oklahoma based on the data tr... View full answer

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!

Lab 8 - 1 Create a Horizontal and Vertical Analysis Using XBRL Data S&P 1 0 0 Lab Note: The tools presented in this lab periodically change. Updated instructions, if applicable, can be found in the...

2 Part 2 of 5 Required Information 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....

Required Information 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:...

Required information Before you begin this part of the project, you should create a new blank Word document or PPT file where you will record your screenshots and save the file and name it: Term...

Required information 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....

Required Information 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....

Required information 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....

Required Information 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....

Suppose two companies acquire a machinery for use in operations. Company A expenses the transaction whereas, company B capitalizes the same transaction. What repercussions will this have on the...

In conducting an internal environmental assessment, why would an MNE want to identify its physical resources and personnel competencies?

An angel investor is defined as a company giving ownership shares to outsiders in return for their financial investments. person borrowing money from another person, a bank, or a financial...

Techniques for enhancing maintenance can include Question 1 2 options: A ) expert systems that aid in problem - solving. B ) simulation of breakdowns from prolonged use. C ) automated sensors that...

3.49 A corporation was concerned with the basic educational skills of its workers and decided to offer a selected group of them separate classes in reading and practical mathematics. Of these...

3.50 A lawn-care service makes telephone solicitations, seeking customers for the coming season. A review of the records indicates that 15% of these solicitations produce new customers and that, of...

3.48 A quality-control manager found that 30% of workrelated problems occurred on Mondays and that 20% occurred in the last hour of a days shift. It was also found that 4% of worker-related problems...