Predictive Modelling - Support needed

[Lucyyy]

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

[NeilR]

@Lucyyy,

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.

[Lucyyy]

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?

[joshuaburkhow · Accepted solution]

Hey @Lucyyy 

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

An example of log transformation 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Log-Transformation/m-p/43576#M16739

A feature scaler 

https://gallery.alteryx.com/#!app/FeatureScaler/5e342b880462d70decb5e915

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