Forum Discussion
sales analysis
I'm trying to do a sales analysis, I thought that key influencers could help but couldn't. What I wanted was the following:
I have a sales table (Example Attachment) I would like to make a correlation that if a customer buys product 1 what is the chance of him taking product 2 based on sales history, the only correlation data would be sales history according to the table . It would be a kind of recommendation that people who buy product 1 also buy product 2, something like that. But I'm not quite sure how to do this analysis.
Table Exemple. link download.
https://drive.google.com/file/d/1wE5TZ_V3225XnhDw4FF9Kr-iEUnuAqyF/view
Could you help me?
Thanks
I think you are looking for market basket analysis?
refer
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi Anonymous ,
you can do an analysis like this in R.
I wrote a short blog post about it in German, but google can translate it.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
6 Replies
I think you are looking for market basket analysis?
refer
https://businessintelligist.com/2017/03/27/market-basket-analysis-using-power-bi/
https://www.mssqltips.com/sqlservertip/5428/market-basket-analysis-in-r-and-power-bi/
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601amitchandak
Thank you, I did not know the nomenclature of this analysis, helped me a lot to search even more references. Your reference helped me completely .. Thanks
Hi Anonymous ,
you can do an analysis like this in R.
I wrote a short blog post about it in German, but google can translate it.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.mwegener
I read your article helped me a lot in the concept, for now I'm looking for a solution in dax. I will in the near future see how it works in R. Congratulations for the article and thanks.
Hi,
See if my solution here helps - Identify Customers that Organisations can upsell or cross sell their products to.
