Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Pacific Air is an airline company. They have implemented an e-procurement system to automate the purchasing and payment processes. You are a reporting analyst,
Pacific Air is an airline company. They have implemented an e-procurement system to automate the purchasing and payment processes. You are a reporting analyst, and the director of procurement has asked you to analyze the purchasing data to get visibility to supplier performance and purchasing internal controls. You extract the purchasing data from the eProcurement system for 2021 and create a dashboard with the following visualizations: 1. 2. 3. 4. Total PO vs Percentage of Returns by Supplier - This is a dual axis chart showing the purchase order by supplier as a bar chart and the percentage of returns per supplier as a line chart. Average Delivery Time vs Invoice Discrepancy % by Supplier - This is a dual axis chart showing the average delivery time by supplier as a bar chart and the invoice discrepancy per supplier as a line chart. The delivery time is calculated as the number of days between the goods received date and the purchase order date. An invoice discrepancy is when the invoice total is greater than the purchase order total. Invoice Total Trend in 2021 This is a stacked area chart showing the invoice totals by supplier for each month. Potential Split Orders Count vs Average PO Total - This is a dual axis chart showing the average purchase order total compared to the count of purchase orders. The results show the purchase orders that potentially have split orders committed. A potential split order is determined if there are two more purchase orders submitted by the same buyer within the same week and the purchase orders total more than $100,000. Hint: Use the WEEK function in Tableau and WEEKNUM function in Power Bl.
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