Aperture Data Studio Version 2.12 - Aug 2023

AdrianW
AdrianW Adrian Experian Cumbria, UK admin
edited October 2023 in Releases (including download links)

Aperture Data Studio Release 2.12 is a roll-up of all features and improvements since Release 2.11 (May 2023). In addition, it comes with a new Notifications inbox, Two-click Profiling, Solutions, plus UX improvements, bug fixes and security updates.

Download links: Windows | Linux | Find Duplicates | SDK

Notifications inbox
Users can receive alerts on Data Studio events in their new Notification inbox, instead of receiving this as emails with all their other business emails.

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/automations-and-notifications/

image.png

Update to Equals function

The Equals and Equals(strict) Functions have been combined. This updated Equals function will compare if the input value is exactly the same as any of the comparison values. There are options to reduce the strictness of the match, e.g. ignore differences in data types or case. Any existing Functions will be upgraded to return the same results as before the upgrade:

  • Equals will have all options checked to return same results as previously.
  • Equals (strict) will no longer be required, existing Functions will be upgraded without Ignore datatype selected to return same results as previously.

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-functions/#validation~native-functions

image.png

Profile Default output
It is now possible to select one of your Profile definitions as the default for the Space (or all Spaces if created in the System Space). The default output columns will be automatically selected when Profiling data.

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/create-a-single-customer-view-scv/discover-and-profile-data/#profilestepsettings

image.png

Profile Data tags
The All statistics Profile output now includes two new columns:
• Data Tags: a comma separated list of all tags assigned to the column
• Sensitive Data Tags: a comma separated list of all tags assigned to the column that have the Sensitive data flag

These new attributes can be included in any custom Profile definitions that you might have defined in Step settings.
https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/prepare-and-move-data/tag-data/
https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/create-a-single-customer-view-scv/discover-and-profile-data/#profilestepsettings

image.png

Two-click Profiling
Right-click on any Dataset or View then click Profile, which will show Profile results (using your default definition output) for all columns in the data making it quicker and easier to understand the structure, consistency, uniformity and completeness of the data.

image.png

Solutions
Solutions are a more advanced form of metadata management than import/export/synch, which allow multiple Spaces to be combined, can contain system-wide objects such as User Groups and can create new Spaces as part of the deployment. Solutions are versioned like other objects and so changes can be reverted if necessary. This all leads to a streamlined sharing and deployment experience for more complex cross-Space use cases.

image.png

External screenshot

image.png

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/collaborate-and-re-use-data/manage-solutions/

Rows to columns
Additional options on Rows to columns step to aggregate values: First, Sum, List etc. (rather than having to follow with a Group step).

image.png

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-a-workflow/#rows-to-columns

Automations event filters
We improved the filter options for events so that filter properties can be used more than once and added new operators like “greater/less than” that can be used for numbers and dates, “contains” for strings like the data set name, “not equal to, does not contain”. These options are applicable for suitable events.

image.png

https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/automations-and-notifications/#eventfilters

UX improvements

  • New Upload data button allows quickly view the existing data before adding / overwriting the Dataset with new data.
    image.png
  • Function list screen filters are remembered, as with other object list screens, to save re-typing, clicking, sorting each time.
  • Dashboard tabs can be re-ordered by dragging tabs into new position.
  • Dashboard widget can be renamed to make Dashboards easier to read, whilst keeping a descriptive name for the View/Chart.
  • The Views info panel now contains the date the underlying data source was refreshed, which is useful if the user cannot access the Dataset.
  • Automations can now be cloned saving time if a similar Automation is required.
  • Clicking on the output node of a Workflow step now brings up a searchable menu to add the next step, which saves time when building out a Workflow.

Bug fixes and improvements:

  • Fixed export issue with Progress Snowflake driver
  • Create Dataset API error when uploading a fixed-width .dat file
  • Find duplicates installer upgrade

Recap of key 2.11.X features you can read more about in the notes for each release

Tagged:

Categories

Share your thoughts on Aperture Data Studio

Your feedback will influence how we improve our products.