New to Predictive tools

Question

I have a database of invoiced orders, including vendor names and On-Time delivery status (Y/N).  Is there a predictive tool I can use to give me percentages of deliveries for each vendor that were on-time (Y's) so it can determine the best vendor to use in the future.

LynnH730 · Answer

Thank you very much for your example.  Seeing the workflow makes it more understandable to me.

I SO appreciate everybody's help.   😊

CathyS_Slalom · Answer

Thanks @LynnH730 for providing your use case. Base on your description, I agree with @Luke_C that instead of using predictive tools. A combination of summarize tools to get the best Vendor Name. And you could build an Analytical App on topic of that to run the report on the particular item # that you entered.

Attached is an example for finding the best Vendor Name to purchase that item from, you could apply the similar logic to generate a list of the best items # to buy from a particular Vendor.

MaxExtSavings.yxwz

LynnH730 · Answer

My use case would be to determine the vendor we should use to purchase an item at it's best savings using our past data.  The columns I have are the following:

Vendor Name

Item #

Qty

Price

Ext Price

Ext Savings

So if I put in a Item #, it would show the best Vendor Name to purchase that item from, probably based on the best Ext Savings numbers?  Or even if I put in a Vendor Name, it could generate a list of the best items # to buy from that Vendor, again based on Ext Savings numbers?

I hope that made sense.  I appreciate any help since using Predictives is so new to me.  Thank you!