Here are our new features and enhancements, geared towards further reinforcing how easily you can perform self-service data preparation in whatever role or industry you are in.

Icon Key:

new feature star iconNew Feature

enhancement iconEnhancement

     *       Classic Interface Update

 

Dec. 2016 Bubble

Monarch Complete v14

Download the data sheet here

 

Use Monarch projects and models as data sources

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.

new feature star icon

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.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Integrate with Monarch Swarm via the Library

  • 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.

 

new feature star icon

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.
new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Preview updates

  • Recent Workspaces and Recent Data Sources are now accessible too, as with Recent Tables.
  • Partial load now also applies to relational data sources – you can limit the number of rows to load for increased efficiency.
  • Previous filters are automatically collapsed to limit visual clutter as you explore your data in Preview.
new feature star icon

UI improvements

  • The +Add More Stuff feature accessible across the application, allowing you to add more data easily no matter what stage of preparation you are in.
  • Default names for Joins, Appends and Transformations are shorter now, occupying less screen space.
new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Text block expansion

In Prep Data mode, rows are automatically expanded to display entire text blocks.

new feature star icon

Drag and drop columns

Organizing your table in Prep Data just got easier – you can now simply drag and drop columns.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Data Prep enhancements

  • 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.
new feature star icon

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.

 

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

New Exports

  • Publish data to Tableau Server and to Swarm.
  • Export to Swarm to share data with others in the organization, or even for use as an archive.
new feature star icon

New settings to configure how Excel files are handled

  • Use extended mode for Excel to address issues with Office 2016 installed locally on desktops.
  • Automatically append named range data with identical structures into a single table.
new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

New Save options

  • Quick save button added to the header bar.
  • Save your workspace with a password and encrypt this for added protection.
  • Save your workspace to the Library to integrate with Swarm.

 

new feature star icon

Additional Functions for the Report Selector Context Menu *

  • Export loaded reports as a consolidated report in text or PDF format.
  • Close, Print, Print Preview, Export and File Information functions now available for multi-selected report files.
  • View file information: Full path, Filename, Size and Last modified date.
 new feature star icon
New Save options
.
Learn More
 Report Selector Context
.
Learn More
 

 

Additional Functions for the Table Selector Context Menu *

  • Do a Quick Export with a customizable default file name, file type and table name.
  • Easily access Model and Project Information, and Model and Project Audit Trails.
  • Rename or Edit External Lookups via the context menu.
new feature star icon

Additional Functions for the Summary Selector Context Menu *

  • Do a Quick Export with a default file name, file type and table name
  • Rebuild a single summary or all summaries to refresh input sources and recalculate summaries
  • Reorder Summaries via Move to Top, Move Up, Move to Bottom and Move Down options
 new feature star icon
Table Selector Context
.
Learn More
 monarch-14-classic-3
.
Learn More
 

 

Enhanced EBCDIC, ASCII and ANSI Codepage support *

  • Quick We now provide support for EBCDIC-encoded files for selected code pages.
  • Specify ASCII and ANSI codepages for input files and text exports.
new feature star icon

Export enhancements *

  • Spaces in auto-generated table names are automatically replaced to ensure validity in Excel exports.
  • Now set the sort order for pivot table row labels in Excel exports.
 new feature star icon
monarch-14-classic-6

Learn More

 

 monarch-14-classic-5
.
Learn More
 

 

Jump to any row or column in the Table or Summary *

  • Navigate to a specified row number or column name/number.
new feature star icon
monarch-14-classic-4

Learn More

 

 

 

 

Sept. 2016 Bubble

Monarch Complete v13.5

 

Partial data loading

Take advantage of improved data processing speed and efficiency by specifying a row limit for imports from all data sources.

new feature star icon

Save connections in a Data Source Library

Eliminate repetitive setting up of data source connections by saving frequently used connections in the Data Source Library.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Export to Power BI

Prepped data may now be exported into Microsoft Power BI, where it appears as a dataset in your account.

new feature star icon

Access Google Analytics as a data source

Leverage Google Analytics data by joining this with other information to get a better, clearer picture of your business.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

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.

new feature star icon

Undock tables / Floating Tables

Undock tables to view multiple tables at once, allowing you to compare different datasets.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Apply negative joins

Perform negative joins to zero in on records that have no match.

new feature star icon

Apply sorts from the Prep Data window

Sorting is now available during Preview and Data Prep.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Perform deduplication

Show or remove rows having duplicate values across all columns or specific columns only (e.g. duplicate Account Numbers or Customers).

new feature star icon

Merge columns

Merge columns and even include characters or text.

new feature star icon
5300 call report
.
Learn More

.
Learn More
 

 

Indicators for nulls and whitespace

Take advantage of on-screen indicators for your data table by showing nulls and whitespace characters (spaces, tab indents and line breaks).

new feature star icon
5300 call report
.
Learn More
 

 

Product Tour