Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started