Transform Your Existing Reports into Live, Actionable Data

What if you could have the flexibility of Excel and the usability of dashboards with the data that is in your existing reports, regardless of source system or format? What if you could have all the data you need without building new systems or using costly IT resources?

Monarch 11 is the latest version of the most-widely used report analytics solution in the world, in use at more than 40,000 organizations. Monarch 11 brings powerful new user interface design, features and functionality to those needing to access, analyze, manipulate, and leverage the data contained in existing, static reports.

Existing Reports Contain a Wealth of Information . . . But are Often Unusable

Reports are often overlooked as a source of operational business intelligence and data feeds for application integration throughout the enterprise. That's not surprising, given that reports are designed to be consumed by humans, rather than processed by computers, with implied relationships based on data positioning, ordering and context.

Working with Existing Reports Brings Huge Benefits

Organizations have embraced business intelligence as a way to access, analyze and act on core business data. Unfortunately, business intelligence works only with structured data in relational databases; traditional business intelligence does nothing to leverage the rest of the data in your enterprise. There’s a wealth of valuable data stored outside of databases and relational systems, including:

• PDFs from suppliers and customers
• "canned" ERP and CRM reports
• Business documents stored in content management systems.

Common approaches to solving this problem include spending massive resources on behemoth data warehousing projects, or resorting to “old school” rekeying and manual entry of data. Both of these approaches are expensive, time-consuming and risky, and ignore the benefits of working with existing reports. Existing reports deliver:

• Data Quality: by extracting data directly from existing reports, there is no question of the integrity of the data
• Security & Traceability: using reports as a data source ensures that all the data used in your decisions can always be traced back to an authoritative source
• Familiarity to Business Users: business users know the data, structure and meaning. When given a report modeling environment such as Monarch, business users have the perfect tool for self-service data extraction and analysis.

What’s New in Monarch 11

Monarch 11 has been updated using the latest .Net technology, unlocking the benefits of multi-core processors and 64-bit operating systems. Introducing a brand new interface that blends a Microsoft Office-like ribbon with Monarch's contextual interface, Monarch 11 makes it easier to model and transform the data in your reports and business documents and makes you more productive than ever. Monarch 11 contains a host of improvements, including:

• Increased data capacity
• Easy import of reports and data sources on the web
• XML export
• A powerful new interface, optimized for high resolution displays and multiple monitors
• Crisp rendering and zooming of text and graphics to aid visual analysis
• Redesigned charting with zooming and the ability to view multiple charts in a grid
• New native 64-bit version

More on What's new in Monarch 11

Monarch Report Analytics – Extending the Power of Monarch 11

The Monarch Report Analytics Platform enables business users to easily extract and analyze the wealth of clean, trusted, auditable data contained within existing reports and other business documents without the need for programming or highly specialized skills. The Monarch Report Analytics platform automates the processes that enable users to easily access, extract and incorporate data from any combination of existing reports already published inside or outside the enterprise, then create, publish and distribute the resulting dynamic, interactive reports throughout the enterprise – without requiring the time, expense or expertise of valuable IT resources. The Monarch Report Analytics platform also includes:

• Monarch Data Pump for automating repetitive processes for acquiring, validating, integrating, scheduling and distributing report data;
• Monarch Enterprise Server for Web-based distribution of dynamic reports throughout the enterprise, including capabilities to archive these reports for proper information governance to satisfy the needs of internal auditors and regulatory bodies;
• Monarch Report Mining Server for data mining and analytics on documents stored in enterprise content management systems such as IBM’s Content Manager OnDemand, ASG Mobius ViewDirect and others.
• Datawatch Report Manager on Demand for high-volume print output, document and report capture, archiving and management.

Features & Benefits

• Flexible new user interface, optimized for high resolution displays and multiple monitors
• Easy to use data extraction technology, market proven over more than 15 years
• Extract data from text, PDF, HTML, Excel, Access, XPS, OLE DB/ODBC, business intelligence reports and other sources
• Open files directly from the web and SharePoint
• Powerful data cleansing and transformation capabilities with an extensive function library
• Quick and intuitive data analysis features, including filtering, sorting, aggregation and drilling
• New charting environment, with the ability to view multiple charts in a grid
• Unparalleled Excel exporting, with full-fidelity formatting, AutoFilter, Outlining, Pivot Tables and more
• Export to a variety of other popular formats including PDF, HTML, Access, XML and text

More on Features and Benefits

Related Topics

• Excel Spreadsheet Strategies
• Monarch Tips and Tricks

Buy now View Demo What's New Product Literature

The Monarch Forum

Features & Benefits

• Imports data directly from virtually any report, database, spreadsheet, database file, PDF file, HTML file and more
• Exports Excel 2007 OpenXML (xlsx) spreadsheets as well as standard (xls) spreadsheets so you can work with your data in the format you want
• Enhances compliance and auditability of Excel spreadsheets by including source report files

Technology & System Requirements

• Windows XP Home/Professional SP3, Windows 2003 Server SP2, Windows Vista SP1 or later, Windows 7, Windows 2008 Server R2
• 1 GB RAM
• 200 MB Disk Space for installation
• .NET Framework 4.0 (Full Installation)

Monarch is now available as a 32-bit or 64-bit application. The Monarch 32-bit edition will run on 64-bit Windows operating systems. However, due to the requirement for an Access Database Engine, you must ensure that the Monarch Edition you install is compatible with your Microsoft Office Installation. Consult the Install Guide to determine which Monarch edition and/or Access Database Engine to install, based on the Microsoft Office edition you are currently using.