using datawatch monarch pro to mine your data n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Using Datawatch Monarch Pro to Mine Your Data PowerPoint Presentation
Download Presentation
Using Datawatch Monarch Pro to Mine Your Data

Loading in 2 Seconds...

play fullscreen
1 / 13

Using Datawatch Monarch Pro to Mine Your Data - PowerPoint PPT Presentation


  • 216 Views
  • Uploaded on

Using Datawatch Monarch Pro to Mine Your Data. KATHI RIFFE Financial & Business Systems Analyst Guilford Technical Community College. PREG – PO Register Example.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Using Datawatch Monarch Pro to Mine Your Data' - noelani


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
using datawatch monarch pro to mine your data

Using Datawatch Monarch Pro to Mine Your Data

KATHI RIFFE

Financial & Business Systems Analyst

Guilford Technical Community College

preg po register example
PREG – PO Register Example

Goal: Two reports – one for AP and one for Purchasing. The two reports will separate the PO’s so that each respective area can look at only those items that pertain to them.

Method: Differentiate the PO’s with various line statuses. For example, if the line status is “Accepted” then it should appear on the AP report. If the line status is “Outstanding” or “Backordered”, it should appear on the PO report. Ignore all other statuses.

slide3

What is Monarch?

Monarch is a Windows-based business intelligence and reporting tool that is easy to use – even if you’re not a “power user” with advanced technology skills. It mines data from existing text-based, PDF or XPS reports and lets you access and analyze data from databases, spreadsheets and other sources.

this is an excerpt from a gl trial balance gltb how would you work with this data to analyze it

This is an excerpt from a GL Trial Balance (GLTB). How would you work with this data to analyze it?

slide5

Print report and rekey data? This is time consuming and prone to errors.

  • Import into Excel? Depending on report, fairly easily done but can be labor intensive for repetitive processes.
  • Use Monarch…
slide8

How do you go about getting these results every time without setting it up each time?

Monarch uses models. Models are groups of templates which select text based on certain parameters (traps). When it finds those traps, it mines the data and uses it to create a view very similar to Excel.

slide9

After adjusting the model to reflect the desired results, you can export the file in an Excel format.

Now – open in Excel and play to your heart’s content!

other features of monarch
Other Features of Monarch

There are many other features of Monarch which include the ability to:

  • create calculated fields
  • create filters
  • link Excel spreadsheets
  • format the export into a summary format like Excel’s subtotal functionality.

These are very useful when you need to pull data from a query or other document into a report to isolate only those items that you want to analyze as well as providing consistent formatting for repetitive reports.

slide12

Most recent change in software (version 10 to 10.5) added a few new features which are great for auditing. You can now select to export the source data with the table view and embed it in the Excel file. Using a new Excel add-in, Monarch Context, you can select to show the source data and verify the accuracy of the exported data.

Version 10.5 requires Excel 2007. Previous versions will also work with Excel 2003.

slide13

Software information:

Datawatch Corporation www.datawatch.com

Monarch Pro 10.5 (newest version as of 10/27/09)

Contact Information:

Kathi Riffe, Financial & Business Systems Analyst

klriffe@gtcc.edu

336-334-4822 x2322