Descriptive Statistics

About the narrative

Details covered in the analysis

The length of the narrative and the level of detail the narrative contains depend on which narrative length option is selected in Step 3. The narrative will include some or all of the following:

  • a section for each measure (e.g. Sales), drilling down by up to three dimensions (e.g. Product, Country, and Segment), which includes:

    • an analysis of different combinations of dimensions, highlighting the most significant insights (such as minimums, maximums, totals and outliers) for each combination. For example:

      pbi-descriptive-stats-overview.png
    • when the Include distribution analysis option is selected, any skew in the data towards a particular instance of a dimension. For example, the first section of the narrative includes sections like those shown here in yellow:

      pbi-descriptive-stats-distribution.png

    Note

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

 

Top

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 three non-time dimensions and multiple measures.

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

Note

When one measure and multiple dimensions are selected, the Summary narrative length is not supported.

 

Aggregation and entity types

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

arria-apps-entity-aggregation-descriptive-statistics-pbi.png

Tip

Aggregation types are set in Power BI. Note that Power BI may automatically set the aggregation type of a calculated measure to Don't summarize.

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

Ranking

Control the order into which dimensions are drilled down using this option.

Select Use order of dimensions set in Step 1 to set priority according to how you order your fields in Step 1.

Select Let us decide to let Arria's algorithms decide priority.

Default: Let us decide.

pbi-ranking-option.png

Include distribution analysis

Distribution analysis describes how the data is distributed through a range of dimensions.

Select this option to gain insight into the skew of the data, if one exists.

Default: unchecked.

pbi-distribution-analysis.png

 

Top