There are various cheat sheets to recommend what predictive model to use in different situations. Here’s a couple to guide you on options for your dataset.
For this first cheat sheet with your example, you would begin with the start icon. For the first question > 50 samples, the answer is yes. For the second question predict category, the answer is no. For the third question predict quantity, the answer is yes. For the fourth question, < 100K samples, the answer is yes . The suggested type of regression analysis to try from this cheat sheet is a SGD Regressor.
For the cheat sheet you example begin with the question what do you want to do. The answer is predict values; so again we see this should be some type of regression analysis. There are a few options on this one that would be appropriate to try, such as a Poisson Regression.
After deciding which model to use the next decision is how to implement the model. Kimball made a statement a good decade ago, In today’s environment, most organizations should use a vendor-supplied ETL tool as a general rule. This was mainly due to maintenance costs. We’ve reached the same level of maturity with data science tools that same logic can be applied for common data science models.