Here are our new features and enhancements, geared towards further reinforcing how easily you can perform self-service data preparation with Monarch. To see your upgrade or purchase options, click here.
Icon Key:
New Feature
Enhancement
* Classic Interface Update
Monarch Complete v15.3
More Data: New Connectors
Connect directly to Cloudera CDH Hive, Spark SQL, Microsoft Active Directory
Improved Data Field Filtering
Data field filtering experience is now easier, aligned with Monarch Swarm
Monarch Complete v15.2
More Data: New Connectors
Connect directly to Amazon EMR Hive, Google Drive, Google Sheets and SugarCRM
Faster Change History Access
Select a column and jump directly to all related data prep changes
Improved Data Field Filtering
Filter all data fields in this new well-organized and easy-to-use view
Summary Exports
Export all Summaries to new or existing Excel files, and append to named ranges in existing files
Monarch Complete v15.1
Analyze and Summarize
Get to your answers even faster with built-in in totals, subtotals, and analysis features
Connectors and Exports
Connect to more data from HubSpot, Cassandra and Google BigQuery
Export Summaries as CSV
Open Data
Save your favorite data sources for faster access, and easily search our categorized connectors
Menu Redesign
Utilize our intuitive drop-down menu to open, save, and close your workspaces and datasets
Monarch Complete v15
PDF Report Trapping
Full Monarch Classic Report Design functionality to make data extraction from PDFs easier than ever before
Eliminates the need to pivot between Classic and Complete for PDF extraction models
Lookup Calculated Field
Easily find and replace column values with flexible, criteria-based rules
Comments on Change History
Leave comments for yourself and others as you transform datasets and track your data prep changes
Column View Filtering
Simplify your view of a dataset to only the columns you need
New Connectors and Exports
Connect to more data from Google Adwords, Netsuite, Sharepoint and Vertica
Export to a JSON file
Table Append Improvements
New Append interface makes consolidating datasets easier
Monarch Complete v14.3
Transpose Transformation Functionality
Easily swap rows and columns with the new Transpose Transformation
Multi-column pivots
Use pivot icons to select the columns to pivot, key icons to select the columns to group, and check boxes to select one or more aggregate types
Lookups
Append columns to a data set without replicating the existing data
Inner Negative Join
With this new join option, keep only the rows from both tables for which the join keys do not match
Named Exports
Exporting from Monarch has never been so easy with pre-defined export destinations and file types
Statistic Snapshots
Export profiles of your data sets as static exports to see how your data changes over time
Highlighting Duplicate Information
Flagging duplicate data values allows for advanced data clean up and improved data quality
Geo Spatial and Scientific Calculations
Create point to point distance calculations and anything else with new Trigonometry expressions
Redaction
Redact sensitive information from your reporting with this new data preparation option
Repeatability with JSON and XML
Use data explorers to navigate to the data you want, and append results by simply adding files to the same logic
Monarch Public Library
Access public data sets in Monarch to enrich your analysis
Search functionality enables you to find the data you’re looking for in a timely manner
Usability Improvements
New sort, search, expand/collapse, and refresh all options allow additional time-savings in Monarch
Monarch Swarm Library
With a library integration to Monarch Swarm you can now access all public, shared, and personal data sets in Swarm
Monarch Complete v14.1
Table Extractor
Automatically find tables on specific pages in large documents
Drag and highlight data to capture as well as header names
Automated table extraction from documents
Capture data as separate tables within a single page
Improved Ability to set the Correct Stretch Factor *
Using Dynamic Guides, select an area on a single line to use as an anchor
Dynamic Guides track to rightmost edge when stretch is changed
Dynamic Guides show the sample line and area when editing
Additional EBCDIC Support *
Improved Encoding Selection UI
New Encoding Functionality on Context Menu simplifies seeking for correct encoding and line/record options for EBCDIC, as well as other input documents
Maximum line length increased to 65K characters for EBCDIC
New EBCDIC Options support a wide variety of record/line delimiters
Monarch projects and models based on report files may now be used as data sources in the Data Prep Studio. This includes support for PDF reports, multiple reports, all trap types, multi-column regions, formula-based calculated fields with built-in Monarch functions, and Lookup table calculated fields.
Load multiple reports into a single table
Create report nodes by dragging in a report and going into Report Discovery, or by dragging in a Model or Project (along with the associated reports). This produces a table where you may then easily drag in more reports, and perform data prep on the node as a whole.
Collaborate with your team and the rest of the organization with Swarm.
Simply configure your connection to Swarm by specifying a server URL and credentials and gain access to Swarm data sources via the Library, and publish and export to the Swarm library as well.
Library enhancements
As your library grows, you still want to easily find what you need. Now you can click on the column headers to sort and on the filter icons to zone in on specific sources. You can also eee details on hierarchical sources from Swarm – these are grouped and may be expanded, collapsed and individually selected.
We now have a new data source type – Internal. This is for tables published to Swarm or exported from Data Prep Studio to Swarm.
Opt to remove the original column for a Merge operation – useful when consolidating wide data.
Apply a Ditto to Date and Numeric columns – not just to Text.
Custom Change lists are now accessible from the prep menu. Drag in changes, give the list a name, and drag the saved list to a column you want to prep.
Transform enhancements
Easily switch between Remove or Show Duplicates.
View all rows and columns when showing duplicates to easily understand why there are duplicate rows.
View this brief video demonstration to see how Monarch can improve data processing speed and efficiency by specifying a row limit for imports from all data sources:
View this brief video demonstration to see how you can leverage Google Analytics data by joining it with other information to get a better, clearer picture of your business:
Perform Data Prep within the Join screen
Prep and clean up your data even from within the Join Data window, not just from the Prep Data interface.
Undock tables / Floating Tables
Undock tables to view multiple tables at once, allowing you to compare different datasets.
Improved Ability to set the Correct Stretch Factor *
Using Dynamic Guides, select an area on a single line to use as an anchor
Dynamic Guides track to rightmost edge when stretch is changed
Dynamic Guides show the sample line and area when editing
Additional EBCDIC Support *
Improved Encoding Selection UI
New Encoding Functionality on Context Menu simplifies seeking for correct encoding and line/record options for EBCDIC, as well as other input documents
Maximum line length increased to 65K characters for EBCDIC
New EBCDIC Options support a wide variety of record/line delimiters
Monarch projects and models based on report files may now be used as data sources in the Data Prep Studio. This includes support for PDF reports, multiple reports, all trap types, multi-column regions, formula-based calculated fields with built-in Monarch functions, and Lookup table calculated fields.
Load multiple reports into a single table
Create report nodes by dragging in a report and going into Report Discovery, or by dragging in a Model or Project (along with the associated reports). This produces a table where you may then easily drag in more reports, and perform data prep on the node as a whole.
Collaborate with your team and the rest of the organization with Swarm.
Simply configure your connection to Swarm by specifying a server URL and credentials and gain access to Swarm data sources via the Library, and publish and export to the Swarm library as well.
Library enhancements
As your library grows, you still want to easily find what you need. Now you can click on the column headers to sort and on the filter icons to zone in on specific sources. You can also eee details on hierarchical sources from Swarm – these are grouped and may be expanded, collapsed and individually selected.
We now have a new data source type – Internal. This is for tables published to Swarm or exported from Data Prep Studio to Swarm.
Opt to remove the original column for a Merge operation – useful when consolidating wide data.
Apply a Ditto to Date and Numeric columns – not just to Text.
Custom Change lists are now accessible from the prep menu. Drag in changes, give the list a name, and drag the saved list to a column you want to prep.
Transform enhancements
Easily switch between Remove or Show Duplicates.
View all rows and columns when showing duplicates to easily understand why there are duplicate rows.
View this brief video demonstration to see how Monarch can improve data processing speed and efficiency by specifying a row limit for imports from all data sources:
View this brief video demonstration to see how you can leverage Google Analytics data by joining it with other information to get a better, clearer picture of your business:
Perform Data Prep within the Join screen
Prep and clean up your data even from within the Join Data window, not just from the Prep Data interface.
Undock tables / Floating Tables
Undock tables to view multiple tables at once, allowing you to compare different datasets.