DA0-001 · Question #81
Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion. Which of the following…
The correct answer is B. Q3 2019 vs. Q3 2020. To compare the performance of the Q3 2020 promotion against the Q3 2019 promotion, the analyst should use specific date parameters for Q3 of both years.
Question
Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion. Which of the following date parameters should the analyst use?
Options
- A2019 vs. YTD 2020
- BQ3 2019 vs. Q3 2020
- CYTD 2019 vs. YTD 2020
- DQ4 2019 vs. Q3 2020
How the community answered
(45 responses)- A7% (3)
- B80% (36)
- C11% (5)
- D2% (1)
Why each option
To compare the performance of the Q3 2020 promotion against the Q3 2019 promotion, the analyst should use specific date parameters for Q3 of both years.
Comparing a full year (2019) against a year-to-date (YTD 2020) would not isolate the performance of the Q3 promotions.
The request specifically asks to compare 'Q3 2020 promotion' versus 'last year's Q3 promotion,' which directly translates to comparing the sales data for Q3 2019 against Q3 2020 to assess the promotion's effectiveness.
Comparing year-to-date (YTD) figures for 2019 and 2020 would include Q1 and Q2, thus not focusing specifically on the Q3 promotion periods as requested.
Comparing Q4 2019 against Q3 2020 would be comparing different quarters, which is not relevant to assessing the Q3 2020 promotion against its prior year's equivalent.
Concept tested: Time-series comparison (quarter-over-quarter)
Topics
Community Discussion
No community discussion yet for this question.