Forecasting in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a forecast to your Tableau visualization.

Tableau

Right-click on the visualization and select [1] to add a forecast.

Drag options to blanks, or click blank then click option'

AAdd Trend Line

BForecast

CShow Me

DEdit Axis

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Add Trend Line' instead of 'Forecast'.

Choosing 'Show Me' which is for chart types, not forecasting.

In Tableau, to add a forecast, you right-click on the visualization and select Forecast.

2fill in blank

medium

Complete the code to specify the forecast length in Tableau.

Tableau

In the Forecast Options dialog, set the [1] to define how far ahead you want to predict.

Drag options to blanks, or click blank then click option'

AForecast Length

BConfidence Interval

CSeasonality

DAggregation

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing 'Confidence Interval' with forecast length.

Selecting 'Seasonality' which adjusts patterns, not length.

The Forecast Length option lets you specify how many periods into the future Tableau should predict.

3fill in blank

hard

Fix the error in the Tableau forecast calculation expression.

Tableau

IF DATEPART('month', [Order Date]) = [1] THEN [Sales] ELSE 0 END

Drag options to blanks, or click blank then click option'

A"January"

B'January'

C1

DJan

Attempts:

3 left

💡 Hint

Common Mistakes

Using string names like 'January' instead of the numeric month.

Using quotes around the month name causing a syntax error.

The DATEPART function returns a number for the month, so to compare it correctly, use 1 for January.

4fill in blank

hard

Fill both blanks to create a calculated field that forecasts sales growth rate.

Tableau

([Sales] - [1]) / [2]

Drag options to blanks, or click blank then click option'

A[Previous Sales]

B[Sales]

D[Total Sales]

Attempts:

3 left

💡 Hint

Common Mistakes

Using the same field for both blanks.

Dividing by previous sales instead of current sales.

The formula calculates growth rate by subtracting previous sales from current sales, then dividing by current sales.

5fill in blank

hard

Fill all three blanks to write a LOD expression that calculates average sales per customer.

Tableau

{ FIXED [1] : AVG([2]) } / [3]

Drag options to blanks, or click blank then click option'

A[Customer ID]

B[Sales]

CCOUNTD([Customer ID])

D[Order ID]

Attempts:

3 left

💡 Hint

Common Mistakes

Using order ID instead of customer ID in FIXED.

Dividing by total count instead of distinct count of customers.

This LOD expression fixes the calculation by customer, averages sales, then divides by the distinct count of customers to get average sales per customer.