2020.3 - DataClarity What’s New and Release Notes

Data Preparation

Support for DateTime and Time data types in files

In addition to the Date column types, users now have support for DateTime and Time columns when creating file-based datasets. The data profiling automatically identifies the DateTime and Time column types and sets the appropriate data reporting role matching the physical data type. This feature provides users with more options and flexibility to create DateTime and Time-based visualizations and analyses and manipulate dates and times using the built-in aggregations and functions.

mceclip11.png

When using built-in Date, DateTime, or Time calculations, DataClarity’s Data Engine sends optimized native SQL calculations to all the data sources and executes in memory the calculations that are not supported by the underlying sources.

Access to How-to Videos from the platform

How-to videos are a great resource to learn about the platform's powerful capabilities and features. Short, up to the point, and easy to follow content is now accessible directly from the platform interface. To find the videos, on the toolbar, point to the Help icon, click Guided tours, and navigate to the How-To Videos tab. The Search field has been added to help you find needed content. Point a video tile to see what is covered in the video.

mceclip12.png

Storyboards

Adding storyboard subscriptions

Storyboard subscriptions are a great way to review the latest storyboard updates without having to log in to DataClarity. Storyboard owners and managers can now set up a storyboard subscription for the selected users and groups to receive emails with storyboard snapshots.

Subscription emails are customizable and can include such macros types as ${first.name}, ${last.name}, and ${email} so that each user receives a personalized message. Subscription emails can be sent based on an hourly, daily, weekly, or monthly basis considering time zones.

To add a new subscription for a storyboard (tile or row), point to More actions, and then go to Subscribe > Add subscription. Alternatively, if the storyboard is already open, click Storyboard options on the toolbar, and then go to Subscribe > Add subscription on the menu.

mceclip7.png

mceclip6.png

To enable subscriptions, the SMTP email server should be configured by the administrator in Access Manager. To receive subscription emails, users must have a valid email address assigned.

Managing storyboard subscriptions

In addition to creating subscriptions, storyboard owners and managers can unsubscribe users from existing subscriptions and make various subscription updates.

The Manage subscription dialog includes the list of all the subscriptions created for the given storyboard. For each subscription, you can see the email subject, the name of the page sent in the email, the format of the page, and the defined schedule. Additionally, you can view the name of the user who created a subscription, and the dates of the last sent email and the next scheduled email.

To manage a subscription for a storyboard (tile or row), point to More actions, and then go to Subscribe > Manage subscriptions. Alternatively, if the storyboard is already open, click Storyboard options on the toolbar, and then go to Subscribe > Manage subscriptions on the menu.

mceclip5.png

mceclip4.png

To enable the subscription feature, the SMTP email server should be configured by an administrator in Access Manager. To receive a subscription, users must have a valid email address assigned.

Customizing the size of the markers (bubbles)

When creating visualizations with markers, like bubble or scatterplot, users may need to control how the data points are plotted on the chart. Depending on the number of markers, adjusting markers size makes them easy to distinguish. Using DataClarity widgets, you can now benefit from a new setting, Marker size, which has been added on the appearance tab of the Scatterplot, Bubble, and Scatterplot Heatmap visualizations to help you control markers appearance.

mceclip3.png

Chord visualization

DataClarity’s visualization list has been updated with a visually appealing and a popular chart type – a Chord diagram. It allows you to evaluate the number and volume of directed quantitative connections between entities, for example, when analyzing economic flows, traffic flows between cities, and similar).

To build a Chord diagram, specify two dimensions in the order of the desired flow and a measure based on which to evaluate the magnitude of the flow. Each dimension is represented by a colored fragment on the outer part of the circular layout (a node). The arcs between each dimension are drawn to show the connection. The size of the arc is proportional to the selected measure. When pointing to the arc, the tooltip will display the flow order and the respective measure for the flow, and when pointing to the node – the total measure for the respective dimension.

The Chord visualization has been added under the Network section in the Widgets pane on the Visualizations tab.

mceclip2.png

Sankey visualization

Good news for those who need to visualize and evaluate a many-to-many mapping between domains – a Sankey chart is now on the DataClarity’s visualization list. The Sankey chart is useful in such business cases as the transfer of the resources, materials, costs, cash flows, web traffic, and other types of flows. By using this chart, users may quickly see the largest flows, the largest consumer, the main losses, and so on.

To build a Sankey chart, specify two dimensions in the order of the desired flow and a measure based on which to evaluate the magnitude of the flow. Each dimension is represented by a colored rectangular fragment (a node). The lines from one dimension to another are drawn to show the connection. The line thickness is proportional to the flow quantity based on the selected measure.

When pointing to the line, the tooltip will display the flow order and the respective measure for the flow, and when pointing to the node – the total measure for the respective dimension.

The Sankey visualization has been added under the Network section in the Widgets pane on the Visualizations tab.

mceclip1.png

Access to How-to Videos from the platform

How-to videos are a great resource to learn about the platform's powerful capabilities and features. Short, up to the point, and easy to follow content is now accessible directly from the platform interface. To find the videos, on the toolbar, point to the Help icon, click Guided tours, and navigate to the How-To Videos tab. The Search field has been added to help you find needed content. Point a video tile to see what is covered in the video.

mceclip0.png

General

Blending support for Data Server

In this release, DataClarity Data Server supports JOIN statements, which allows the datasets created in DataClarity to be blended with any other data sources. After establishing a PostgreSQL data connection to Data Server with datasets, just select the data, and blend it with any other data sources. Moreover, you can blend DataClarity datasets with other sources in other external BI tools like Tableau, PowerBI, and others.

mceclip10.png

Simplified installation process

The installation process has been enhanced to simplify retrieving administrator password, updating it, and accessing the Kubernetes Dashboard. Also, the 31002 port needed for installation has been changed to 5432.

Portals

Search by tooltips in reports

The search capabilities in Portals have been enhanced to consider tooltips. Now, when searching for the reports in the Content pane or in the general search, the search checks not only to the report or content name, but also the tooltips associated with it.

mceclip9.png

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.