pbPassingBI
/
tableau/quizzes/tableau-desktop-analytics-trendlines-forecast
advanced 10 questions

Analytics, Trendlines & Forecast

The Analytics pane in practice.

  1. Trend lines are used to:

    1. Filter outliers
    2. Predict continuation of a trend and show correlation
    3. Change mark colour
    4. Group dimension members

    Answer: Predict continuation of a trend and show correlation — They help identify correlation between variables by showing the trend in both.

  2. Tableau's forecasting model is:

    1. Linear regression
    2. Exponential smoothing
    3. ARIMA
    4. Random forest

    Answer: Exponential smoothing — Tableau uses exponential smoothing to predict future values of a measure.

  3. Forecasting requires:

    1. A dimension on Colour
    2. A date dimension and a measure
    3. An extract
    4. A dual axis

    Answer: A date dimension and a measure — Forecasting works on a time series, so a date field is essential.

  4. A reference line differs from a trend line because:

    1. It is always horizontal
    2. It marks a constant or computed value rather than fitting the data
    3. It cannot be formatted
    4. It only works on maps

    Answer: It marks a constant or computed value rather than fitting the data — Reference lines mark a value such as an average or target; trend lines fit a model to the marks.

  5. Which analytics object shows the spread of the middle 50% of values?

    1. Trend line
    2. Box plot
    3. Forecast
    4. Reference band

    Answer: Box plot — A box plot displays quartiles, with the box covering the interquartile range.

  6. R-squared in a trend line describes:

    1. The slope
    2. How much variance the model explains
    3. The p-value
    4. The number of marks

    Answer: How much variance the model explains — R-squared measures fit; the p-value indicates whether it is statistically significant.

  7. Which chart is best for examining correlation between two measures?

    1. Pie chart
    2. Scatter plot
    3. Gantt chart
    4. Filled map

    Answer: Scatter plot — Scatter plots take two to four measures and reveal relationships.

  8. A histogram requires:

    1. Two measures
    2. One measure and a binned dimension
    3. A geocoded field
    4. A date

    Answer: One measure and a binned dimension — Bins group a measure into bands; the histogram then counts records per band.

  9. Clusters in the Analytics pane group marks by:

    1. Alphabetical order
    2. Similarity across chosen measures
    3. Colour
    4. Sheet order

    Answer: Similarity across chosen measures — Clustering uses k-means over the variables you supply.

  10. Adding a totals row to a view is done from:

    1. The Marks card
    2. Analysis → Totals
    3. The Filters shelf
    4. Show Me

    Answer: Analysis → Totals — Analysis → Totals adds row and column grand totals and subtotals.