Machine Learning Algorithms to find out the correlation/co-variance between the measures.

[former_member510186]

Hi All,

I have a dataset with around 10 measures, among which Customer_Name, Age, Gender, Promotion, Article, Units_Sold, Avg._Sales_Per_Unit, Net_Sales,Profit are few of its measures. As I'm pulling data from HANA and using its native capabilities.

Now, I want to find out the correlation/co-variance between the measures. For example, what would be the relationship between Article, Units_Sold, Net_Sales and how will the variation of one/two measures impact on the other measure, like if there is a variation in Units_Sold, then how would it affect the Profit.

Is there a specific Machine Learning Algorithm or a set of algorithms that could help. Can someone please help me out in this regard.

Thanks in Advance,

Medini H K

[former_member194405]

Hi Medini, there is a SAP HANA Academy about Machine Learning algorithms here

https://blogs.saphana.com/2013/04/26/new-machine-learning-and-data-mining-algorithm-tutorials-on-sap...

You may try it.

If you are using Python, it is very easy to do that with Pandas. You can do it inside HANA with the Python Client API for ML

https://developers.sap.com/tutorials/hxe-ua-install-python-ml-api.html

Hope it helps.

Best,

Marco