Table of Contents

Search

  1. Introduction to Data Discovery
  2. Data Discovery with Informatica Analyst
  3. Data Discovery with Informatica Developer
  4. Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Cumulative Metrics Trend

Cumulative Metrics Trend

The
Cumulative Metrics Trend
pane displays column charts. You can view the aggregate of good, acceptable, and unacceptable metrics for all the scorecard runs in a month in the chart as vertical bars. You can use the
Cumulative Metrics Trend
pane to view and analyze the metrics trend for the current month and the past five months.
When you move the pointer over a vertical bar, the metric summary for the month appears in a data label. When you click a vertical bar in the pane, the relevant scorecards appear in the assets list pane. You can view the scorecards for which you have read access. Click a scorecard in the assets list pane to view the scorecard results.
The following image shows the
Cumulative Metrics Trend
pane in the scorecard dashboard:
The image shows the cumulative metrics trend for the past six months. You can view the aggregate of good, acceptable, and unacceptable metrics for all the scorecard runs in a month in the chart.
The assets list pane might display a few scorecards in the unacceptable metric list and good metric list when the scorecard trend changes with time in a month. To analyze the metrics, open the scorecard to view the scorecard results.
Example
You are the regional manager for a string of retail stores in the state of California. You create the Sales_SC scorecard on the Sales table.
You set the following thresholds for the Sales_amt metric in the Sales_SC scorecard:
  • Unacceptable = 0% to 40%
  • Acceptable = 41% to 89%
  • Good = 90% to 100%
To capture the sales data on a daily basis, you use the scheduler service to run the scorecards every night on the Sales table. You prepare a monthly report for the management for the month of May and you use the scorecard dashboard to verify your report. For the month of May, when you click the vertical bars for Unacceptable metrics and Good metrics in the chart, the Sales_SC scorecard appears in the assets list pane.
When you analyse the sales across the month, you find the following trend:
  1. From 1st May through 25th May, the Sales_amt metric is computed below 40% and is marked as an unacceptable metric.
  2. In the last week of May, due to a rise in sales, the Sales_amt metric is computed above 98% and is marked as a good metric.

0 COMMENTS

We’d like to hear from you!