|
Data Mining and Report Writing
Example: Market Basket Analysis
How valuable would it be to know what items were purchased most frequently along with this week's coupon? And to know who purchased those items?
Here is an example of a Monarch model which performs market basket analysis. Using a sales history report as a basis, the model asks the user for the market basket item. The model then reports what items were purchased along with the market basket item and counts the frequency of those related items.
1. Below is a portion of a Sales History (Ticket History) report. The first step is to open this report file with Monarch.
2. Open the model and fill in the form. We want a report showing what items were sold on tickets along with item #coupon.
3. Monarch produces a report showing what items were sold along with the key item, Coupon.
The template, filters, sorts, summary reports, etc. are saved for re-use as a model, so the next time we want to do a Market Basket Analysis, we run a Ticket History Report, open it in Monarch, open the saved model, and the model performs the analysis with no further user input.
The possible uses of this tool are endless. Call or e-mail Nancy Hawley to learn about developing useful Monarch models and saving hours of time. |
Monarch is a product of Datawatch Corporation.
28 Duffy Road, Milton, Vermont 05468
802-893-6300
E-mail:
© Copyright 2009, Nancy Hawley. All Rights Reserved.