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

Conducting An Institutional Diversity Audit In Higher Education A Practitioners Guide To Systematic Diversity Transformation

Authors: Edna Chun, Alvin Evans, Benjamin D. Reese

1st Edition

1620368196, 978-1620368190

More Books

Students also viewed these Accounting questions

Question

4. Describe the purpose and audience for a trip report

Answered: 1 week ago

Question

Explain the causes of indiscipline.

Answered: 1 week ago

Question

Use a three-step process to develop effective business messages.

Answered: 1 week ago