Market Basket Analysis - Bulk Search

I was assigned to analyze a sales report and conduct a basket analysis for inventory management to discontinue some products. This experience transformed how I think about data and my approach to problem-solving.

Learn 

• Market Basket Analysis, Association Algorithm Techniques, and Association Rules Viewer

Useful Resource

• The Knowledge Bank by obviEnce , SQLBI, and ViSIT

 

Selection Customers = 
CALCULATE ([Unique Customers],
TREATAS(VALUES('SelectedItem'[ITEM]), 'Sales Line'[Item]))

Basket Analysis = 
VAR v1 = SELECTEDVALUE('SelectedItem'[ITEM])  
VAR v2 = SELECTEDVALUE('GeneralBasket'[ITEM]) 
VAR V3 = SELECTEDVALUE('AnalysisType'[Type])  
VAR v4 =  
SUMMARIZE(FILTER('Sales Line',  
RELATED('Sales Line -Duplicate'[Item]) = v1),'Sales Line'[Order #])

VAR v5 = SUMMARIZE(v4,
'Sales Line'[Order #],
"Basket" , CONCATENATEX(RELATEDTABLE('Sales Line'), 'Sales Line'[Item], "|")
)
VAR v6 = SUMX(v4,1)
VAR v7 = SUMX( v5, IF(PATHCONTAINS([Basket], v2),1, BLANK()))
RETURN 
SWITCH(TRUE(), 
v1 <> v2 && V3 = "% Second Product is Purchased with First",     DIVIDE( v7,v6, BLANK() ),
v1 <> v2 && V3 = "Count of Shared Baskets", v7,
v1 <> v2 && V3 = "count of first Product Purchase", v6,
BLANK () )

 

 

eyJrIjoiMDgyNDlkNjAtZGRjZS00NjE0LWEwZDktMTRkMWQwYWFjNTBiIiwidCI6IjNlMjFhMTFlLTc3MDctNDdmOC1iMzRhLTc5YTQ2YTQ0ZTk5MyIsImMiOjF9