Analytical Processing

Talend Data Quality Portal User and Administrator Guide

EnrichVersion
6.5
EnrichProdName
Talend Real-Time Big Data Platform
Talend MDM Platform
Talend Data Fabric
Talend Data Services Platform
Talend Big Data Platform
Talend Data Management Platform
task
Data Quality and Preparation
Data Governance
EnrichPlatform
Talend DQ Portal

Talend Data Quality Portal provides an access to Online Analytical Processing (OLAP) on the data resulted from the analyses carried on in the Profiling perspective of Talend Studio. In this page, you can easily and selectively extract and view data based on multi-dimensional analytical queries and save the most interesting view.

The Analytical Processing page in the web user interface gives an access to a document with time and indicator dimensions and their corresponding measures (values of threshold indicators). The view can also be displayed in the form of a bar chart.

The below figure illustrates an example of an OLAP document:

An OLAP document is a way to inquiry your business data freely and dynamically. This means that normally the user starts his analysis from a predefined view and then he can completely change the inquiry interacting with the platform.

Prerequisites

  • You have accessed Talend Data Quality Portal as a user.

  • Some reports have been generated in the Profiling perspective of Talend Studio.

To change the inquiry that interacts with the platform, do the following:

  1. On the toolbar, click the icon, expand tdq_user and select tdq_olap.

    A page opens with documents on Simple statistics, Summary statistics and Text statistics.

  2. Click one of the documents depending on what type of data you want to extract.

    The Analytical Processing page opens.

  3. From the toolbar of the page, click the OLAP navigator icon to open a matrix table.

    Here you can set the parameters of the query and decide what data to analyze.

  4. From this matrix table, click:

    Link

    To...

    Measures

    define the thresholds you want to use in your query.

    Analysis

    define the analyses to integrate in your query.

    Indicators

    define the indicators you want to use in your query.

    Connection

    define the connections you want to use in your query.

    Date

    define the dates you want to use in your query.

  5. Click the icon on the toolbar to display the extracted data in the form of a bar chart.

  6. If required, click the icon on the toolbar to open a view where you can configure the chart display.