Ranking Analysis

About the narrative

Details covered in the analysis

The narrative includes:

  • an overview section that summarizes ranking changes in a measure (Profit) for the highest priority dimension as set in Step 1 (Country). For example:

    pbi-ranking-analysis-overview.png
  • subsections that describe top and bottom ranking changes and when they happened, for up to three dimension drilldowns. For example:

    pbi-ranking-analysis-drilldown-3.png

    Note

    The order of drilldown is determined by the order of dimensions set in Step 1.

The narrative wording depends on the selected aggregation types, referring, for example, to total, average, minimum or maximum values. For the Percentage, Rating and Ratio entity types, total values are omitted from the narrative as it does not make sense to sum up non-additive measures.

The app attempts to describe as much detail as possible, but when there is too much to describe the narrative will not report on dimensions below the second dimension drilldown.

Note

Only the Important things narrative length is available for this app in Step 3.

Data requirements

All NLG Apps have the same data requirements relating to supported formats and field names. See the NLG Apps Data requirements topic for details.

In addition, each app has specific data requirements:

If your data selection and configuration do not meet the specific requirements for a particular app, the app is grayed out and disabled in the wizard. In this example, the Describe a Pie Chart app has been disabled:

pbi-nlg-apps-minimum-requirements.png

Dimensions and measures

This app can analyze:

  • up to two time dimensions, up to three non-time dimensions, and exactly one measure.

Minimum requirement: one time dimension, one non-time dimension, and one measure.

 

*Time dimension requirements for each analysis period:

Analysis period

Required date fields

Year

Date or Year

Quarter

Date or Year+Quarter

Month

Date or Year+Month

Important

For each time dimension, the Entity Type field must be set to DateTime in Step 1 of the wizard.

 

Aggregation and entity types

Not all combinations of aggregation and entity types are supported for measures. The Ranking Analysis app can analyze the following combinations:

arria-apps-entity-aggregation-ranking-analysis-pbi.png

Tip

Aggregation types are set in Power BI.

Entity types and other data attributes are set in Step 1 of the Arria for Power BI wizard.

 

Top

Configuration options

The following options are available to configure:

OPTION

DESCRIPTION

LOCATION

Measure

Select the measure you want to analyze.

Default: highest priority measure from Step 1.

pbi-measure-field.png

Period

Select a time period for the analysis. The time period you select must appear as a field in your data.

Default: Month.

pbi-period-field-ranking.png

Ranking

Specify whether you would like to include only the top ranking changes, only the bottom ranking changes, or both.

Default: Top only.

pbi-ranking-field.png

 

Top