Monarch V10 Standard

Manufacturer: Datawatch
Monarch Standard is a Windows-based business intelligence and reporting tool designed for easy use by everyone, not just a select group of "power users" with advanced technology skills. Unlike other BI or reporting tools, Monarch Pro easily "mines" data from existing text-based or PDF reports - an information source often overlooked by other BI tools. Monarch Pro also enables users to access and analyze data from database files, spreadsheets, ODBC sources, delimited text, and HTML files.

Monarch Features
" Extracts data from report files produced on any mainframe, midrange, client/server or PC system for fast and easy integration of your data management system
" Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls) spreadsheets so you can work with your data in the format you want
" Provides a variety of options for working with report-based data: sort, filter, analyze, visualize and export data to spreadsheets, databases and other applications
" Supports SharePoint(r) repositories, including access and export, so you'll always be connected.
" Creates new views of data using data extracted from existing reports.
" Windows Vista(tm) ready

Benefits:
" Easily integrates data from your company's existing business systems to desktop applications such as Microsoft Office, including Excel 2007, without programming - increasing productivity and accuracy
" Removes the need to re-key data from printed reports. With Monarch, reports become live, actionable data
" Provides powerful auditing, accounting, financial analysis and inventory analysis by utilizing financial statements and other familiar and trusted reports
" Reduces the need for custom reports, allowing users to re-deploy data from existing reports

New to Monarch
Report Window
" Report Window Exports
" Increased Number of Allowed Templates
" Increased Number of Lines in a Template
" Not Traps
" Trap on Lines Other than the First Line with Footer Templates
" Page Break on Hidden Leading Text Option
" Next Report/Previous Report Icons
" Bookmark Improvements
" Increased Number of Items in Recent Reports

Table Window
" User-Defined Functions
" Opening of Models without Data Sources
" Test Function for Calculated Fields and Filters
" Increased Number of Characters in an Expression
" Calendar Control for Inserting Dates
" Increased Number of Arguments for Min and Max Functions
" Improved Duplicate Handling
" New DateAdjust Function
" Maximize the Expression Editor
" Lookup Field Enhancements
Summary Window
" Quick Summary Design
" Summary Start Tab
" Summary Design Preferences
" Excel Subtotals and Grand Totals as formulas
" Enhanced Options for Measure Value Matching
" Hiding Summary Elements
" Excel Conditional Formatting Rules
" Excel Outlining
" Header Lines
" Multiple Blank Lines
" Increased Limits on Labels
" Increased Number of Item Fields
" New Excel Export Engine
" Export to OpenXML Spreadsheet (xlsx)
" Excel Autofilter
" Excel Freeze Panes
" More control over exporting Null values to Excel
" FirstValue of Field Macro
General
" Object Comments
" PDF Security Options
" Tip of the Day
" Customizable Toolbar
" Enhanced Default Folder Options
" Project and Model Portability
" Sharepoint Support
" Publishing Passwords Stored in Encrypted Form
" Saved Dialog Settings

New to Monarch Pro Only:
" Linking Objects
" PDF Improvements
" Import Using OLE DB
" Import OpenXML Spreadsheets
" Enhanced Database Filters
" Import Multiple Delimited Text Files
" Import Excel Files with No Header Row
" Ability to force Data Types to Character
" Replace Nulls on Import
" Multi-Select Project Exports

Monarch Summary
Monarch unique modeling technology allows even non-technical users to effortlessly build a collection of filters, calculations, summaries and charts and apply them to different data sets, plus export data at anytime to Excel, Access, PDF, and more - all without programming and without help from the IT department.

Managers, analysts, auditors, accountants and staff workers might struggle with other highly complex BI tools, or wait for help from the IT department to get the data they need, causing frustrating delays, missed deadlines and lost business opportunities. To avoid such delays, they often resort to printing and flipping through thick paper reports run from their ERP system, HR/payroll system, banking, healthcare or government information system, or mainframe system, and then rekey the data into a spreadsheet, to perform needed analysis and reporting.

Monarch ends such time-wasting, error-prone work. Monarch transforms existing text-based or PDF reports into live, actionable data, and/or easily access other sources of data. This data can be sorted, filtered, combined with additional complimentary data from other sources, supplemented with new calculations, summarized, exported to Excel, Access, etc., all without programming and without help from the IT department.

So easy to use, Monarch is the ideal solution for managers, analysts, accountants and auditors who want to access and manipulate data from trusted reports and other data sources, quickly and easily, without programming. IT professionals use Monarch well, to help reduce demands for custom database queries and report writing jobs.

Monarch includes all the standard features of Monarch, the world's leading Report Mining and analysis tool, plus the ability to mine data from PDF reports, plus import and analyze data from XLS, MDB, DB, DBF, WKx, delimited text and HTML files, as well as any ODBC-compliant data source, including SQL Server and Oracle. Monarch Pro reads and mines data from report files commonly known as print files, spool files, TXT files, formatted ASCII files, PRN files and SDF files.

Monarch Import Formats
" Fixed length ANSI or ASCII text (TXT, PRN, SDF, etc.)
" PDF
" HTML
" DBF
" DB
" MDB
" XLS
" WKx
" Delimited text files

Monarch Export Formats
" Portable Reports File (PRF)
" Access 1.0, 1.1, 2.0, 3.0, 4.0
" Excel 2.1, 3.0, 4.0, 5.0 and 8.0
" PDF
" Paradox 3.x, 4.x, 5.x and 7.x
" Lotus 1-2-3 Release 1 (wks), Release 2 (wk1), Release 3 (wk3)
" dBASE III, IV, and 5.0
" Fixed length and delimited text
" HTML (requires Office XP or freely available Office XP web components)
XML-SS (requires Office XP or freely available Office XP web components)