Section 7: Calculations

Question 1

Name each of these boxes

Answer 1

Question 2

What are the MEASURE aggregations available?

Answer 2

Sum, Average, Median, Count, Count (Distinct), Min/Max, Standard Deviation, Percentile, Variance

Question 3

What are the DIMENSION aggregations available

Answer 3

Min/Max, Count, Distinct Count

Question 4

What are the different aggregation types?

Answer 4

Question 5

What are the 5 types of functions?

Answer 5

Question 6

What is DateADD function and how many arguments does it require?

Answer 6

Question 7

What are the arguments DATEDIFF requires (in order from left to right)

Answer 7

Question 8

What does DATENAME do?

Answer 8

Returns a part of the given date as a string, with units defined by the date interval. DateNAME(‘month’, ‘2021-04-01’) would return April

Question 9

What does DATETRUNC do?

Answer 9

DATETRUNC(‘month’, ‘2021-06-10’) -> ‘2021-06-01’

Question 10

Name the different Date Intervals

Answer 10

Question 11

Name the different Date Intervals

Answer 11

Question 12

Define Addressing and Partitioning in Tableau

Answer 12

Question 13

Define the three LOD types

Answer 13

Question 13

Define the three LOD types

Answer 13

Question 14

What would you expect to happen when you drag the following calculated field to the table in the attached picture:

{EXCLUDE [State]: SUM(Spend)}

Answer 14

Aggregates up our spend to region, but excludes the state dimension.

Question 15

What would you expect to happen when you drag the following calculated field to the table in the attached picture:

AVG({INCLUDE [Customer ID]: SUM([Spend])})

Answer 15

Calculates the average spend using Customer ID, by state.

Question 16

What would you expect to happen when you drag the following calculated field to the table in the attached picture:

{FIXED [Country/Region]: SUM[Spend]}

Answer 16

Ignores all dimensions and has the sum of spend of the country/region (United States)