Skip to main content

Descriptive Statistics

About the analysis

This out-of-the-box narrative app generates a summary of quantitative insights derived from your measures and dimensions. Each measure is analyzed in turn and the analyses are broken down by one or more dimensions to describe where statistically interesting breakdowns appear. For example, the narrative may analyze both Profit and Sales, with the analysis of each broken down by Product and Country.

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 of the wizard. The narrative includes 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 of the wizard.

 

Top

Required 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.

 

If your data selection does not meet the specific requirements for a particular app, that app is grayed out and unavailable for selection. For example, if no time dimensions have been configured, the Time-Based Variance app is disabled:

excel-arria-app-disabled.png

 

Top

Configuration options

The following options are available to configure in the Configure Narrative wizard:

OPTION

DESCRIPTION

LOCATION

Step 2: 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 the dimensions in the first step of the wizard.

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

Default: Let us decide.

excel-arria-ranking-field.png

Step 2: 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.

excel-arria-distribution-analysis.png

Step 3: Tell me how you want to say it

Summary: produces a narrative of filtered facts in a more concise way than the Important things option.

Important things: produces a narrative of filtered facts based on Arria's ranking algorithm.

Tell me everything: produces a narrative that includes every fact extracted from your data by Arria's algorithms.

Default: Important things.

excel-arria-verbosity.png

 

Top