Procurement Data Visualization Guide
Uploaded by
Mustafa jawedProcurement Data Visualization Guide
Uploaded by
Mustafa jawedCommon questions
Powered by AIThe scatter plot provides insights into pricing strategies and negotiation efficiencies across item categories by illustrating the relationship and potential trends between unit and negotiated prices. On the other hand, the box plot for quantity by item category focuses on distribution and variability, highlighting outliers and central tendencies. The scatter plot is more about identifying negotiation patterns, while the box plot emphasizes distribution metrics in quantities .
Interpreting a pie chart can lead to misconceptions if attention isn't paid to segment sizes. Since small differences in percentage may not be easily discerned visually, precision can be lost, and the chart could oversimplify the distribution. Moreover, detailed nuances like the specific reasons for compliance failures are not captured .
The boxplot for quantity by item category shows the distribution and variability across different categories. It reveals that some categories have a greater spread in quantity, indicating variability. Additionally, any data points outside the whiskers of the boxplot are considered outliers, suggesting unusual quantities ordered for those categories .
The scatter plot, which includes a hue dimension for 'Item_Category', reveals potential patterns in pricing strategies for different categories. For instance, some item categories might show a consistent smaller gap between unit and negotiated prices, indicating less pricing flexibility or tighter negotiation margins .
Insights from the compliance pie chart could be enhanced by integrating additional visualizations like bar charts segmented by supplier or item category. This segmentation can reveal specific areas of non-compliance within suppliers or categories, offering opportunities for targeted process improvements. Time series plots could further show trends in compliance over time .
A bar chart is more suited for visualizing order status because it allows for easy comparison of counts across different statuses; whereas, a pie chart can be less effective in distinguishing between similar-sized segments, especially if there are multiple statuses with close frequencies .
Compliance data is visualized using a pie chart which shows the portion of compliant versus non-compliant orders. The chart suggests a high compliance rate as the 'Yes' segment is significantly larger than the 'No' segment, indicating that most orders meet compliance standards .
A count plot can effectively display the number of compliant versus non-compliant orders but might lack nuance. Unlike tables or more segmented visualizations, it doesn't show why orders failed compliance or specific trends over time. It may also conflate items of varying importance, as it treats all orders equally regardless of size or value .
The order status distribution is represented using a bar chart, which displays the count of each order status. The visualization indicates that the most frequent order status is 'Delivered', as it has the highest bar compared to other statuses like 'Cancelled' .
The bar chart illustrates which suppliers are associated with the highest number of defective units, informing procurement about which partnerships might need reevaluation or improvement. Suppliers with fewer defects might be preferred for future orders to minimize risk and enhance product quality .