Sample dataset guide

This topic provides information about the sample dataset for Arria Answers.

Note

Click HERE to download the sample dataset in CSV format.

Key terms

Term

Definition

Measure

A numeric, quantitative field in your data (for example, Units Sold, Sales, or Profit).

Dimension

A categorical, qualitative field in your data (for example, Product).

Dimension instance

A specific instance of a dimension (for example, Glower for Product).

Time dimension

A special type of dimension that contains date values (for example, Date).

 

Top

Measures in the dataset

The dataset includes the following measures:

  • COGS

  • Units Sold

  • Sales

  • Target Sales

  • Profit

Note

All of these measures are summable. Arria answers does not support non-summable measures.

 

Top

Dimensions in the dataset

The dataset includes the following dimensions:

  • Product

  • Segment

  • Country

 

Top

Dimension instances

The dataset includes the following instances for each dimension:

Dimension

Dimension Instances

Product

  • Camoide

  • Glower

  • Nutrali

  • Ointmo

  • Karateon

  • Retine

Segment

  • Brand Store

  • Channel Partners

  • Chemists

  • Departmental

  • Online

Country

  • Germany

  • France

  • United States of America

  • Mexico

  • Canada

 

Top

Time dimensions in the dataset

A time dimension is a dimension field that contains date information. In the sample dataset, all date values are stored in the Date column. Power BI automatically creates a date hierarchy from this column, thereby creating the fields Year, Quarter, Month, and Day. Use these fields as time dimensions when analyzing your data.

The following is a breakdown of each measure over each year present in the data:

AA_PBI data graph (new).png

 

Top