1. Tell me about your data

In Step 1 of the wizard, you characterize and prioritize the data fields you have selected for your narrative.

Tip

You must select at least the minimum number of data fields required for the NLG App you wish to use. The minimum requirements for each NLG app are described in the Selecting data section for that app.

Configure data fields as dimensions or measures

Arria for Power BI automatically categorizes each field in your selected data as a dimension or a measure, according to how they've been categorized in Power BI.

You can recategorize a dimension as a measure, and vice versa.

pbi-arria-change-dimension-to-measure.gif

Configure data attributes

Further characterize your selected dimensions and measures by adjusting their attributes.

Note

See Data requirements for detailed guidance on the expected format for each type of data field.

Dimension attributes

OPTION

DESCRIPTION

LOCATION

Alias

Adds an alternative name for the field (if desired). For example, you could give the Segment field the alias Market.

Default: data field name.

pbi-dimension-alias.png

Entity Type

Ensures appropriate handling of dates and locations in the narrative. Set the Entity Type field to DateTime or Location as required.

For example, when you set Entity Type to Location, the narrative uses language like "... in the US." rather than "... for US."

If neither of these entity types applies, leave this selection blank.

Default: none.

pbi-dimension-entity-type.png

Measure attributes

ATTRIBUTE

DESCRIPTION

LOCATION

Alias

Adds an alternative name for the field. For example, the Sales field could be given the alias Actual Sales.

Default: data field name

pbi-measure-alias.png

Entity Type

Along with a measure’s aggregation type, determines what type of analysis is appropriate, and therefore which apps can be used to analyze the measure.

Not all aggregation and entity type combinations are supported by every app. For details of the combinations supported by a particular app, see the relevant page in the NLG Apps Directory.

Also ensures appropriate language and formatting is used in the narrative. For example, when Currency is selected, 3,000,000 is displayed as $3M.

Default: None

Note

When analyzing percentages:

  • if your percentage data is formatted as decimals (e.g. 0.75), use Percentage. The % symbol is automatically appended in the narrative.

  • if your percentage data is formatted as percentages (e.g 75%), use Ratio, and enter % in the Unit field.

pbi-measure-entity-type.png

Unit

Defines the appropriate unit for your measure (e.g. kg). The unit specified in this field appears in the narrative after the corresponding numerical value.

A number of ISO 4217 currency codes are supported. Select the code for the currency you want to use in the narrative. For example, when the Unit field is set to GBP, $3M is displayed as £3M.

Default: none.

pbi-measure-unit.png

Increase in Value is

Characterizes an increase in value for each of your measures as a positive, neutral, or negative change: Select Good, Neutral, or Bad.

For example, an increase in Sales is a positive change, whereas an increase in Cost of Goods Sold is a negative change.

Default: Good.

pbi-measure-increase-in-value.png

Important

Arria Answers currently supports only the Sum aggregation type and the None and Currency entity types. When switching from an NLG Apps narrative to Arria Answers, make sure the measures chosen to generate the narrative meet these requirements. If they don't, Arria Answers will return incorrect responses.

 

Top

Prioritize data fields

The higher the position of a dimension or measure, the higher its priority for coverage in the generated narrative.

Fields are initially prioritized in the order you select them in the Power BI Fields pane. Drag and drop fields to change their priority order to suit the narrative you want to generate.

arria-apps-prioritize-measures-dimensions.gif

Prioritizing dimensions

The priority order for dimensions is important for apps that perform drilldown analysis. For example:

arria-apps-dimensions-country-segment.png
arria-apps-dimensions-segment-country.png
arria-apps-dimensions-country-segment-narrative.png
arria-apps-dimensions-segment-country-narrative.png

Prioritizing measures

The priority order for measures is important for apps that describe each measure in turn. For example:

arria-apps-measures-profit-sales.png
arria-apps-measures-sales-profit.png
arria-apps-measures-profit-sales-narrative.png
arria-apps-measures-sales-profit-narrative.png

 

Top