Sample dataset guide
This topic provides information about the sample dataset for Arria for Power BI. This dataset is included in the sample report that you download in the tutorials.
Note
Click HERE to download the sample dataset in CSV format.
Key terms
Term | Definition |
|---|---|
Measure | A numeric, quantitative field in your data (e.g. Sales, Profit, or Units Sold). |
Dimension | A categorical, qualitative field in your data (e.g. Segment or Product). |
Dimension instance | A specific instance of a dimension (e.g. Glower for Product). |
Time dimension | A special type of dimension that contains date values (e.g. Date). |
Measures in the dataset
The dataset includes the following measures:
COGS
Units Sold
Sales
Target Sales
Profit
Dimensions in the dataset
The dataset includes the following dimensions:
Product
Segment
Country
Dimension instances
The dataset includes the following instances for each dimension:
Dimension | Dimension Instances |
|---|---|
Product |
|
Segment |
|
Country |
|
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:
Recommended further reading
Arria Answers returns incorrect or unexpected results when the input data fails to meet specific requirements. Please refer to the Data requirements topic for guidance.
