Nov 22 2017 08:54 AM
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
Nov 22 2017 09:39 AM
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.
Jul 16 2018 11:42 PM