Summaries

Question 1

What Cogito feature would you utilize if you wanted to aggregate and analyze data in groups, or track trends overtime?

Answer 1

Summary (9.4)

Question 2

Cogito’s tools have a number of different ways to summarize data, but all of the tools go through two main steps to generate summaries. What are those two steps?

Answer 2

1. Group the rows (9.11)

2. Aggregate across the rows (9.12)

Question 3

Once data has been grouped, _____ _____ aggregate the data and define how it should be displayed for each group.

Answer 3

Summarization functions (9.12)

Question 4

Can you use a count function on numeric data to find the total amount?

Answer 4

No (9.13)

Question 5

What function should you use if you want to display the number of different values?

Answer 5

Count Unique (9.13)

Question 6

Will NULL values be considered when calculating an average?

Answer 6

No (9.12)

Question 7

When adding up numbers, does 0 or NULL affect the total sum?

Answer 7

No (9.12)

Question 8

Name that aggregate function: For each group, your summary will show how many rows in the group have a value in that column.

Answer 8

Count (9.12)

Question 9

In SlicerDicer, what would you add to change grouping?

Answer 9

You would add a slice (9.14)

Question 10

In SlicerDicer, what controls which summarization functions are used?

Answer 10

Measures (9.14)

Question 11

Where do the slices that can be chosen come from?

Answer 11

The list of SlicerDicer Filters (FDS records) built for the chosen data model (9.14)

Question 12

On what condition are new FDS records built?

Answer 12

That the data is in Caboodle (9.14)

Question 13

True or False: Columns do not have to be displayed to be available to a summary.

Answer 13

True (9.16)

Question 14

Where are Workbench report summaries built?

Answer 14

In the Summary tab of the Report Settings window (9.16)

Question 15

What Display Format does a SlicerDicer component use?

Answer 15

Graph (9.18)

Question 16

What form determines advanced graph display settings?

Answer 16

The Output Format form (9.20)

Question 17

What three tabs in the Output Format form are essential to any table component?

Answer 17

General Settings tab, Columns tab, Thresholds tab (9.20)

Question 18

On the Output Format form, what tab determines overall how your table component will look?

Answer 18

The General Settings tab (9.20)

Question 19

For a table component, what tab, in the Output Format form, can specify thresholds at which the summary data can highlight red, yellow, or green to indicate which groups of data need attention first?

Answer 19

The Thresholds tab (9.20)

Question 20

Can a user set both row and cell level indicators?

Answer 20

Yes (9.21)

Question 21

True or False: Bounds are exclusive.

Answer 21

False

Bounds are inclusive (9.21)

Question 22

How do components evaluate table rows?

Answer 22

From top to bottom (9.21)

Question 23

Does the order of the threshold bounds matter?

Answer 23

Yes (9.21 )

They are evaluated from top to bottom.

Question 24

What do overlapping boundaries ensure?

Answer 24

They ensure that number with decimals are included (9.22)

Question 25

Why is it good practice to have an overlap across rows?

Answer 25

Because if a value does not fall within any threshold bounds that you’ve defined, it will appear with no indicators (9.23)

Question 26

What are easily digestible graphics representing a single data point from a table or graph component?

Answer 26

Badges (9.23)