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 burdening costly IT resources?

Our 2 Cents

The latest version of the most-widely used report analytics solution in the world is in use at more than 40,000 organizations. It combines a powerful new user interface with enhanced features and functionality for those needing to access, analyze, manipulate, and leverage the data contained in existing, static reports. 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.

Mine Your Own Business!

Benefits for your organization

• You don't have to give money to massive resources on behemoth data warehousing projects, or resort to old-school rekeying and manual entry of data. They are expensive, time-consuming and risky! They ignore the benefits of working with existing reports!
• Data quality: by extracting data directly from existing reports, there is no question of the integrity of the data.
• Security and 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: they know the data, structure and meaning! 
• Self-service data extraction and analysis of the wealth of clean, trusted, auditable data for business users.
• This tool makes it easier to model and transform the data in your reports and business documents and makes you more productive than ever!
• No need for programming or highly specialized skills.
• You can create, publish and distribute the resulting dynamic, interactive reports throughout the enterprise, without requiring the time, expense or expertise of valuable IT resources.

Core Capabilities

• This tool 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. 
• Easy import of reports and data sources on the web.
• XML export.
• Powerful interface, optimized for high resolution displays and multiple monitors.
• Crisp rendering and zooming of text and graphics to aid visual analysis.
• Native 64-bit version.
• Charting with zooming and the ability to view multiple charts in a grid.
• 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 and cleansing and transformation capabilities with an extensive function library.
• Quick and intuitive data analysis features, including filtering, sorting, aggregation and drilling.
• 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 info?

• 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.
• Monarch Report Manager on Demand: for high-volume print output, document and report capture, archiving and management.