How to get "Shopping basket" in my Excel 2016

Question

Hi,
I have the Data Analysis pack add-in and solver add-in in my Excel 2016. However, I could not find the tab where i can see the "Shopping Basket Analysis" as shown in the microsoft website (https://msdn.microsoft.com/en-us/library/dn282369(v=sql.120).aspx) see the attached screenshot
&nbsp;
please help

sergeibaklan · Answer

That's not a part of Excel 2016. You may click around you link, that's somewhere with Data Mining Add-Ins for Office which work with SQL Server 2010 or so. Not sure if that's still supported and works.

leon chen · Answer

Shopping Basket Analysis is for excel 2010.I tried to use the tools many times&nbsp;in excel 2016 &amp; 2013 but it doesn't work.I suggest you to use&nbsp;Shopping Basket Analysis tools in excel 2010.https://docs.microsoft.com/en-us/sql/2014/analysis-services/shopping-basket-analysis-table-analysistools-for-excel?view=sql-server-2017

Forum Discussion

How to get "Shopping basket" in my Excel 2016

Shopping Basket Analysis is for excel 2010.

I tried to use the tools many times in excel 2016 & 2013 but it doesn't work.

I suggest you to use Shopping Basket Analysis tools in excel 2010.

https://docs.microsoft.com/en-us/sql/2014/analysis-services/shopping-basket-analysis-table-analysistools-for-excel?view=sql-server-2017

Share

Resources