Analytics-DA-201 - Explore and Analyze Data (41% of the exam) - Section 2.8
Summarise, model, and customise data using totals and subtotals, reference lines and bands, average and trend lines, distribution bands, and forecasting.
Practice question for this objective
lock_openFree sampleExplore and Analyze Datamedium
An analyst adds a linear trend line to a sales-over-time line chart that contains one extreme outlier month caused by a one-off bulk order. They want the trend line to reflect the normal pattern without permanently deleting the outlier mark from the data source. Which action achieves this directly from the view?
ARight-click the outlier mark and choose Exclude, which removes it from the view so the trend line recomputes without itcheck_circle Correct
BEdit the trend line and tick the option to ignore the highest value, which Tableau applies before fitting
CDelete the outlier row from the underlying data source so every worksheet using it is corrected at once
DSwitch the trend model from linear to polynomial, which Tableau weights to suppress isolated outliers
Excluding a mark from the view refits the trend line on remaining data while leaving the underlying data source unchanged. Tableau recomputes trend lines from the marks currently in the view, so the Exclude command removes a single mark from that view and triggers an immediate refit without altering the data source or other worksheets.
Why A is correct: Excluding a mark drops it from the current view only, leaving the data source intact, and Tableau immediately refits the trend line on the remaining marks so the line reflects the normal pattern.
Why B is wrong: The trend line editor has no ignore-the-highest-value setting; fitting options cover model type and factors, not single-point exclusion. It sounds plausible because excluding the outlier is the goal, but this control does not exist.
Why C is wrong: Editing the data source contradicts the requirement to keep the outlier in the data, and it affects every view rather than just this one. The scenario explicitly rules out permanent deletion.
Why D is wrong: A polynomial model changes the curve shape but does not down-weight outliers; a single extreme point can distort a polynomial fit just as much. Changing model type does not remove the outlier's influence.
Answers that look right on this material and are not. Each one is a distractor from a different question in the Analytics-DA-201 bank for this domain.
It marks the total profit summed across all sub-categories, giving a benchmark equal to the overall figure for the pane.
errorWhy it is wrong: Summing across the pane would give a total, not a median; the Median aggregation reports the central per-mark value, so describing it as the summed total confuses median with a grand total.
A distribution band can only be placed on a continuous axis, whereas a reference band works exclusively on discrete headers.
errorWhy it is wrong: Both bands are placed against a continuous axis, so this invented restriction is false even though axis type is a genuine consideration for reference items.
Add a Total quick table calculation to SUM(Sales) and set Compute Using to Category.
errorWhy it is wrong: A running or total quick table calculation transforms the displayed values inside existing cells rather than inserting dedicated subtotal rows for the outer Region dimension, so it does not produce the structural subtotal the analyst wants.