Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles of Auditing and Other Assurance Services

Authors: Ray Whittington, Kurt Pany

20th edition

77729145, 978-1259295430, 1259295435, 978-0077729141

More Books

Students also viewed these Accounting questions