Skip to main content Skip to complementary content

An example of an evolution report

Before you begin

At least one type of analysis is created in the Profiling perspective.

About this task

In this example, we create a basic column analysis using simple statistics and generate an evolution report on this analysis. This evolution report provides us with the evolution of the simple statistics indicators through comparing current and historical statistics to determine the improvement or degradation of the data in the analyzed column.

Procedure

  1. Follow the steps outlined in Creating a basic analysis on a database column to create a simple column analysis.
    In this analysis, you analyze one column using the Row Count, Blank Count and Distinct Count indicators.
  2. Right-click the analysis name in the DQ Repository tree view and select New Report from the contextual menu.
    The report editor is displayed with the selected analysis already listed in the Analysis List.
  3. In the Analysis list view and from the Template type list, select Evolution as the type for the report you want to generate.
  4. Select the Refresh All check box to refresh the listed analysis before generating the report.
  5. Click Generated Report Settings to display the corresponding view, and then define the settings for the generated report.
  6. Click Presentation Settings to open the corresponding view, and then personalize the presentation settings for the generated report.
  7. Click Database Connection Settings and set the connection parameters to the database where you want to store the report results.
    For further information about creating a report, see Creating a report on specific analyses.
  8. Click the save icon on the toolbar of the report editor to save the report settings.
  9. From the toolbar of the open report editor, click to generate the report file.
    The listed analysis is executed, the data is historized in the report database and a report document is generated in the selected format (pdf, html, xsl, or xml). Every time you generate this report, it will compare the current and historical statistics to determine the improvement or degradation of the data in the analyzed column.

Results

In every evolution report, you will have two graphics: the first indicates the change in the statistics and the second indicates the percentage of that change.

The above report then tracks the evolution through time of the row count, distinct count and blank count of the data records in the column.

Information noteImportant: If you import the items in an evolution report in another project in the Studio, the evolution chart will not display the data of the previous project. For further information on how to show the evolution of data through all projects, see Migrating evolution reports.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here