Metrics Tab

The Acumen Fuse analysis engine uses libraries of metrics to run project analytics. The metric editor provides a means of simplifying the development of metrics by reducing the amount of times a metric formula needs to be manually written.

Note: For detailed information about writing formulas and creating metrics, see the Deltek Acumen Metric Developers Guide.

What is a Metric and How Does it Work?

A metric is a standard or measure for use in determining how well a project is planned and executed.

Metrics are defined using either basic filters or more advanced formulas that are of the same syntax as those found in MS Excel. Metrics contain formulas and tripwires (thresholds).
  • Use primary formulas to calculate counts as part of an analysis.
  • Use secondary formulas to calculate ratios.
  • Use Tripwire thresholds to flag and filter activities that exceed given levels.

Metric results can be numeric (for example, cost or duration) or percentages (for example, percentage of total project duration). Percentages are useful for portraying results within a given context.

Acumen uses metric libraries to group metrics for project analysis. Standard metric libraries pertaining to schedule quality, cost, project performance, risk exposure, Earned Value, the DCMA 14 Point Assessment, and more are included within the tool. For example, metrics can be organized by categories, project attributes, or along a project lifecycle. Organizing the metrics differently allows you to customize your project or program analysis.

Metric Scorecards

Scorecard totals are calculated using overall or individual activity scores.
  • Overall scores (for example, project scores) are based on the number of activities within the dataset that fail one or more of the metric tests (irrespective of weighting). You can modify this method on the Deltek Acumen Options dialog box (User Interface) to use weighted scores based not just on the number of activities that fail a test but the total number of metrics that fail a test.
  • Individual activity scores are based on the weighted results of all metrics being applied to the activity.

In order to calculate these activity scores, the relative weighting for each metric is required.

Weightings

Weightings indicate how one metric counts towards the overall score for a group of metrics.

Weightings are based on a +/- 10-point sliding scale. The higher the weighting, the more impact the metric in question has on the scorecard score. By default, metric weightings have been set to the midpoint in the weighting scale (that is, +/- 5 depending on whether a high score is a positive or negative result). Newly created metrics inherit a neutral score until you edit them.

To What do Metrics Apply?

All project data is stored in a tabular manner where each activity is represented as a row of data and each activity attribute is listed in a different column.

The data is then aggregated either across the spreadsheet or down the spreadsheet. When viewed in Acumen, you can use the S2 // Diagnostics tab to conduct the analysis for ribbons, phases, or intersection points.

Acumen metrics are calculated:
  • Across a ribbon
  • Down a phase
  • For the intersection of a phase/ribbon (red square)

The screenshot below shows an example view of Ribbon and Phase Analysis in Deltek Acumen on the S2 // Diagnostics tab.

A summary table of the analyses is shown below.

Analysis Type Summary
Ribbon Analysis Analyze and compare groups of activities (that is, activities grouped by WBS, contractor, or CAM).
Phase Analysis Analyze project time phases or identify trends.
Intersection Analysis Analyze a group of activities in a certain time-phase (that is, pinpointing project hot spots).

Metric Library

Acumen ships with a default (built-in) metric library. You can view the default library location or select a custom metric library on the Deltek Acumen Options dialog box (General).

You can use the Metrics tab Open menu option to merge a metric template into an existing workbook. When you import a metric template library, Acumen performs the following actions:
  • Merges metrics based on the metric GUID (globally unique identifier). Imported metric definitions replace existing definitions if the metric already exists in Acumen.
  • Adds metrics that don't already exist in the current metric library.
  • Leaves existing metrics if they don't have an imported equivalent.
  • Merges variables, project variables, and calculated fields based on the name of the item.
  • Adds variables, project variables, and calculated fields that are in the file being imported that are not in the current metric library.
  • Leaves current values for project variables unchanged after the merge. Project variable descriptions will be updated by the import.
  • Updates variables (workbook variables) based on imported values.

Industry Standards Metrics

Acumen ships with sets of industry standards metrics, including DCMA, NASA Health Check, GAO, and DECM.

In order to use the DECM metrics, you must select the DCMA DECM metrics<date>.aft file in the Default Metric Library Location field (Deltek Acumen Options dialog box (General)).