QUESTION 42

When creating a matrix, make sure your _____ data (the non-number data) is on the left of the matrix, and the numeric files on the right to ensure the horizontal scroll bar appears, and to make sure that scrolling behavior works properly.

dimension

categorical

factual

slicer

QUESTION 43

_____ charts are typically used to show changes over a particular process, such as a sales pipeline or website retention efforts.

Bar

Scatter

Funnel

Bubble

QUESTION 44

_____ charts are typically used to show changes in a particular value over time.

Bubble

Hierarchical

Funnel

Waterfall

QUESTION 45

Sometimes when building reports you may want to track a just single Key Performance Indicator (KPI) or metric over time. What kind of visualization would be used.

Scalar

Vector

Matrix

Gauge

QUESTION 66

Column names must always include the _____.

forward slashes

parentheses

square brackets

curly braces

QUESTION 67

It's best practice to always do the following: (choose all that apply)

Always include the table name in formulas

Use double quotes

No spaces in table names

Start table names with tbl

QUESTION 68

_____ are useful when you want to slice or filter on the value, or if you want a calculation for every row in your table.

		Formulas
		Slicers
		Dicers
		Calculated columns