Mastering Tableau 2018.1, Second Edition 7.5: Understanding Window Table Calculations

The video tutorial provides an in-depth understanding of Windows functions in data analysis, focusing on Windows Sum, Max, and Average functions. It explains how these functions are used in Tableau for complex calculations and data manipulation. The tutorial demonstrates the application of these functions with examples, highlighting the importance of parameters and expressions in defining calculation ranges.

What is the primary purpose of Windows functions in data manipulation?

• To format data

• To perform complex calculations

• To import data

• To create visualizations

Which function is used to calculate the sum of a selected data window in Tableau?

• Windows MIN

• Windows SUM

• Windows AVERAGE

• Windows MAX

What parameters can be optionally defined in the Windows SUM function?

• Start and End

• Row and Column

• Expression and Date

• Category and Value

What does the Windows MAX function return?

• The maximum value in the window

• The average value in the window

• The sum of values in the window

• The minimum value in the window

How can you modify the range of data considered by the Windows MAX function?

• By altering the visualization

• By using a different function

• By adjusting the start and end parameters

• By changing the data type

What does the Windows AVERAGE function compute?

• The total sum of values

• The maximum value

• The minimum value

• The average of values

Which parameters are used in the Windows AVERAGE function?

• Row and Column

• Expression, Start, and End

• Date and Time

• Category and Value