How to get "Shopping basket" in my Excel 2016

[Srinivasacharyulu Daroori]

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

please help

[#2]

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.

[#3]

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-analysist...