ANALYTICS FINAL TEST PAPER 2026 FULL
QUESTIONS AND SOLUTIONS GRADED A+
● Algorithm . Answer: Sets of instructions that transform the data into
information
● Calculated Columns . Answer: Adds a new column to a table and its
content is calculated starting from the values in other columns; integral
part of the table
● Measure . Answer: A total that can be used in reports for analytical
purposes
- Aggregate can then be sliced by any possible combination of
dimensions
- Created by algorithms
- Not an integral part of table
- At the center of data analytics
● Data Models . Answer: show the structure of a data set (concepts are
being described, the tables, and what fields are being used to describe
the concepts)
,● Information Model . Answer: Extends the data model and includes
additional information from the dataset (i.e. calculated columns and
measures)
● What are the objectives of an information model? . Answer: 1. To
create a rich set of measures for the fact table
2. To create a rich set of dimensions that can break down, or slice,
measures in many ways
● Who Table . Answer: describes the agents involved in the transactions
uses a participates relationship to link agents to transactions
● What Table . Answer: describes the resources that were given up or
acquired as part of a transaction
uses a flows relationship to link resources to specific transactions
● When Table . Answer: describes when a transaction occurs
uses an occurs relationship to link the calendar to specific transactions
, ● Within-Table Numeric Calculation . Answer: creates a new field
(calculated column) from one or more numeric columns/fields in the
same table
● Within-Table Text Calculations . Answer: creates new field with text
fields
● Within-Table Classification . Answer: create a new column that
contains new knowledge by applying conditional logic
● Across-Table Calculations . Answer: data from different tables used to
create a new column
● Single-Column Aggregation . Answer: applies mathematical operation
to all the values of a single column (SUM, AVERAGE, COUNT, MAX,
MIN)
● Filtered Aggregation . Answer: aggregates a subset of the values of a
single column
(i.e. filters: WHERE,IF)
● Measure Hierarchies . Answer: new/more complex measure created
using existing measures is created (i.e. ratios/benchmarks)
QUESTIONS AND SOLUTIONS GRADED A+
● Algorithm . Answer: Sets of instructions that transform the data into
information
● Calculated Columns . Answer: Adds a new column to a table and its
content is calculated starting from the values in other columns; integral
part of the table
● Measure . Answer: A total that can be used in reports for analytical
purposes
- Aggregate can then be sliced by any possible combination of
dimensions
- Created by algorithms
- Not an integral part of table
- At the center of data analytics
● Data Models . Answer: show the structure of a data set (concepts are
being described, the tables, and what fields are being used to describe
the concepts)
,● Information Model . Answer: Extends the data model and includes
additional information from the dataset (i.e. calculated columns and
measures)
● What are the objectives of an information model? . Answer: 1. To
create a rich set of measures for the fact table
2. To create a rich set of dimensions that can break down, or slice,
measures in many ways
● Who Table . Answer: describes the agents involved in the transactions
uses a participates relationship to link agents to transactions
● What Table . Answer: describes the resources that were given up or
acquired as part of a transaction
uses a flows relationship to link resources to specific transactions
● When Table . Answer: describes when a transaction occurs
uses an occurs relationship to link the calendar to specific transactions
, ● Within-Table Numeric Calculation . Answer: creates a new field
(calculated column) from one or more numeric columns/fields in the
same table
● Within-Table Text Calculations . Answer: creates new field with text
fields
● Within-Table Classification . Answer: create a new column that
contains new knowledge by applying conditional logic
● Across-Table Calculations . Answer: data from different tables used to
create a new column
● Single-Column Aggregation . Answer: applies mathematical operation
to all the values of a single column (SUM, AVERAGE, COUNT, MAX,
MIN)
● Filtered Aggregation . Answer: aggregates a subset of the values of a
single column
(i.e. filters: WHERE,IF)
● Measure Hierarchies . Answer: new/more complex measure created
using existing measures is created (i.e. ratios/benchmarks)
