Forum Discussion
Analyzing PO Performance
Hi all,
I’m new to the community and new to Power BI. I am truly excited about the capabilities of this program for our company.
My first attempt at using PBI will be to help our Procurement group streamline their reporting of PO performance and find ways of improvement.
I have access to the SQL data tables for all POs created in our procurement system. Each row of the table represents a single PO with all associated data. What id like to do first is look at the date stamps at each milestone of the PO to determine “cycle time”. That is, time needed to progress through all stages of the PO. These are: Requisition to RFQ to PO creation, PO receipt and finally PO delivery. Each of these is represented by a column in the table.
Can Power BI look at these POs over a year for example and calculate this average “cycle time” for all POs made and present this by quarter? I’m thinking horizontal stacked bar chart would do a good job here with each quarter on the Y- axis and “days” along the X-axis. The different portions of each bar would be “average days as Requisition, days as RFQ, days to PO receipt, etc”
Appreciate any help on this one
Rgds,
Rob
I’m new to the community and new to Power BI. I am truly excited about the capabilities of this program for our company.
My first attempt at using PBI will be to help our Procurement group streamline their reporting of PO performance and find ways of improvement.
I have access to the SQL data tables for all POs created in our procurement system. Each row of the table represents a single PO with all associated data. What id like to do first is look at the date stamps at each milestone of the PO to determine “cycle time”. That is, time needed to progress through all stages of the PO. These are: Requisition to RFQ to PO creation, PO receipt and finally PO delivery. Each of these is represented by a column in the table.
Can Power BI look at these POs over a year for example and calculate this average “cycle time” for all POs made and present this by quarter? I’m thinking horizontal stacked bar chart would do a good job here with each quarter on the Y- axis and “days” along the X-axis. The different portions of each bar would be “average days as Requisition, days as RFQ, days to PO receipt, etc”
Appreciate any help on this one
Rgds,
Rob
7 Replies
Anonymous5 - Could you provide some sample data?
Hi Nate,
Here's a sample of my query. Each row represents a PO created in 2019. The milestones occur along the way from it's preceding RFQ creation and approval through PO creation to receipt to delivery. I'd like my visualization to gather up all POs for a given quarter, average out the time spent at each phase and produce a horizontal stacked bar with 4 segments representing the following:
RFQ Creation - RFQ Aproval (days required)
RFQ Approval - PO Fiscal Effective Date (days required)
PO Fiscal Effective - PO Receipt (days required)
PO Receipt - PO Delivery (days required)
Thanks and Regards,
Rob
