4.6 Retail
For the Retail industry, we have pre-built scenarios for 3 use cases such as Market basket analysis, Customer
loyalty programs, Store clustering. Depending on the use case and the functionality that we are analyzing, we
have picked up either the Automated Analytics or the Expert Analytics approach.
Basically for all 3 use cases, we have used the leading SAP application Customer activity repository as the data
source and sample data sets are available for the same.
Note: Any SAP or non-SAP customer would be able to deploy or mimic the data structure, load the data and use
the pre-built models.
Market Basket Opportunities
In this use case, we focus on identifying what products sell well as a basket during different times of a day, week
and weekends.
Expert Analytics
For non-SAP Customer Activity Repository installation
Select the LUMS file for Retail Market Basket Analysis
a. Launch Expert Analytics in SAP Predictive Analytics. Open menu File and choose Import to
folder and import or if the LUMS file is already imported browse through the Documents list for
Retail_Market_Basket_Analysis.lums file
b. In the dialog box, enter the SAP HANA server details, your user name, and password.
Verify the data
Choose Prepare panel to ensure that the data has loaded properly.
Switch to the
Predict
panel to view the predictive model.
Adjust the
Time Period
filter component
a. Choose
Configure Settings
in the
Time Period
filter component.
b. Under
Row
Filter
, change the filter properties for the
Business Date
and enter a date range
applicable for transaction analysis.
Adjust the
Filter:Store xxxx Weekday
filter component
a. Choose
Configure Settings
in the
Filter:Store xxxx Weekday
component
b. Under
Row Filter
, change the filter properties for
Store ID
to the appropriate Store ID for
analysis.
Adjust the
Filter:Store xxxx Weekend
filter component
a. Choose
Configure Settings
in the
Filter:Store xxxx Weekend
component
b. Under
Row Filter
, change the filter properties for
Store ID
to the appropriate Store ID for
analysis.
Adjust the
Apriori : Across all stores
SAP
HANA Apriori component
a. Choose
Configure Settings
in the
Apriori : Across all stores
component
b. Change the
Support
level to an appropriate value
c. Change the
Confidence
level to an appropriate value
Run the algorithm
Choose
Run
to execute the scenario
Choose
Yes
to switch to the
Results
view for verifying the execution results.
For SAP Customer Activity Repository installation
Select the LUMS file for Retail Market Basket Analysis
