Forecasting in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate Forecasted Sales for Next Quarter

You have monthly sales data and want to forecast sales for the next quarter using Tableau's built-in forecasting. Which calculated field expression correctly sums the forecasted sales for the next 3 months?

A SUM([Sales]) + 3 * AVG([Sales])

B WINDOW_SUM(SUM([Sales]), 1, 3)

C RUNNING_SUM(SUM([Sales])) + 3

D SUM([Sales]) * 3

💡 Hint

Think about how to sum values in a forecasted range using window functions.

Option B uses WINDOW_SUM to sum the forecasted sales for the next 3 months after the last actual data point. Other options either multiply or add incorrectly.

❓ visualization

intermediate

Best Visualization for Showing Forecast Accuracy

You want to show how close your sales forecast was to actual sales over the past year. Which visualization type is best suited for this in Tableau?

A Line chart with actual and forecast sales lines over time

B Pie chart showing percentage of forecast vs actual sales

C Bar chart showing total forecast sales only

D Scatter plot of sales vs time

💡 Hint

Think about how to compare two values over time clearly.

A line chart with both actual and forecast sales lines allows easy comparison of trends and accuracy over time. Pie charts and bar charts do not show time trends well.

🧠 Conceptual

advanced

Understanding Seasonality in Forecasting

Why is it important to include seasonality when creating a sales forecast in Tableau?

A Because seasonality makes the forecast always increase over time

B Because seasonality removes all random noise from data

C Because seasonality ignores past sales trends

D Because sales often follow repeating patterns during certain times of the year, improving forecast accuracy

💡 Hint

Think about how sales might change during holidays or seasons.

Seasonality captures repeating patterns like holiday spikes, which helps the forecast reflect real-world sales cycles. It does not remove noise or ignore trends.

❓ data_modeling

advanced

Preparing Data for Accurate Forecasting

You have daily sales data with missing dates. What is the best way to prepare your data in Tableau for accurate forecasting?

A Fill missing dates with zero sales to maintain continuous time series

B Remove all missing dates from the dataset

C Replace missing dates with average sales of other days

D Ignore missing dates and forecast only on available dates

💡 Hint

Think about how Tableau expects time series data for forecasting.

Filling missing dates with zero sales keeps the time series continuous, which is important for forecasting algorithms. Removing or ignoring dates breaks continuity.

🔧 Formula Fix

expert

Troubleshooting Forecast Errors in Tableau

You created a forecast in Tableau but it shows an error: 'Insufficient data to generate forecast'. What is the most likely cause?

A The data contains negative sales values

B The forecast model is set to exponential smoothing instead of linear

C The data has too few data points or missing continuous dates

D The worksheet has more than one measure

💡 Hint

Think about what Tableau needs to create a forecast.

Tableau requires a continuous time series with enough data points to build a forecast. Missing dates or too few points cause this error.