|
Data Mining and Report Writing
Example of a Simple Model
Here is a simple example of a useful Monarch model.
1. Below is a very short Inventory Analysis Report that's useful for this illustration. We want to display only those items which have quantities or dollar values, not the lines with all zeroes. The first step is to open this report file with Monarch.
2. Define a template to trap the data we want to extract.
View larger screen shot of trapped fields
3. Monarch extracts the trapped data and puts it in an Excel-like table, where it can be filtered, sorted, and calculations performed. Output can be printed from within Monarch or exported to Excel, Access, and many other formats.
The template, filters, sorts, etc. are saved for re-use as a model, so the next time we run the Inventory Analysis Report, we simply open it in Monarch, open the saved model, and the zero lines are stripped out.
View larger screen shot of filtered table
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 2008, Nancy Hawley. All Rights Reserved.