Data Mining and Report Writing
|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.
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.
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.
N. Hawley Business Solutions
28 Duffy Road, Milton, Vermont 05468
© Copyright 2013, Nancy Hawley. All Rights Reserved.