Forum Discussion

Srinivasacharyulu Daroori's avatar
Srinivasacharyulu Daroori
Copper Contributor
Nov 22, 2017

How to get "Shopping basket" in my Excel 2016

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

Data Analysis

2 Replies

  • Leon Chen's avatar
    Leon Chen
    Copper Contributor
    Jul 17, 2018

    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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 22, 2017

    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.

Resources