Data Challenge

Welcome RXP Group and AFG data challenge participants! Use this forum to collaborate, ask questions, and get support from Alteryx experts.

Predictive Modelling - Support needed

5 - Atom

Hi all,


I am quite new to Alteryx and need some help in building a suitable predictive model. 

My dataset has 1222 records (dataset included) In the data, my target variable is the Food Relief Amount in Column A. Other columns are predictor variables. Big question is to build a model that can predict the Food Relief Amount based on other predictor variables. 


I have tried using linear regression model but the accuracy point is quite low.


What other models should I use?

Any hep will be much appreciated. Thanks








Alteryx Community Team
Alteryx Community Team



You can try other models and use the model comparison tool (available on the Alteryx Analytics Gallery) to compare the effectiveness of the different models, see attached workflow example. Here i've tried Boosted model and Random Forest - neither appear to outperform linear regression.




5 - Atom

Thanks for your kind support. Is there any way I can transform my linear function to get a better result in Alteryx? Like using exponential or logarithmic relationships?

14 - Magnetar
14 - Magnetar

Hey @Lucyyy 


I know it's been a while but maybe a few things that will help you. 


An example of log transformation


A feature scaler!app/FeatureScaler/5e342b880462d70decb5e915


Hope this helps! If it does please mark as solved so others can find it!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks