Basket Analysis using BI Office and SSAS Tabular Edition
There are several articles available on the web showing how to perform associative analysis (or Basket Analysis or who bought what products with what!) using Analysis Services that rely on special configuration of dimensions to perform the required queries, using custom MDX to work around limitations in Microsoft’s own tool set. In this session Pyramid analytics will show how to use BI Office to easily build an adhoc Analysis Services Tabular Edition analytic data set and perform associative analysis using the unique features of BI Office.
Pyramid aims to deliver a BI platform that provides business users with the tools needed to gain insights about their business in a way that is natural, does not require any particular technical skills while allowing a depth of analysis comparable to the best applications available. Furthermore, in a singular tool, we’ve set out to satisfy both the casual data consumer as well as the power analyst.