The questions in this exam are from Playfair Data's Proxy dataset. Download the latest version here

1. What is the percent difference of Sales from May - August compared with the prior comparison period of January - April?

A. -2.30%

B. 2.30%

C. -2.73%

D. 2.73%

2. What is the percent difference of Sales for Wednesday, January 17 compared to the immediately prior Wednesday?

A. 40.00%

B. 41.09%

C. -7.00%

D. -7.45%

3. What is the percent difference of Sales in the first 15 days of April to the first 15 days of March?

A. -0.50%

B. 7.55%

C. 0.88%

D. -19.73%

4. What is the best method for comparing date ranges on a line graph?

A. Normalize the comparison date ranges on the same axis.

B. Using one line graph, ensure the axis includes both the current and comparison date ranges.

C. Construct two line graphs, one for each date range, and compare the two on a dashboard.

D. A and B

5. What is the Pareto Principle?

A. 25% of the output driving 75% of the results, e.g. the top quarter.

B. Isolating the top 80% of causes that are responsible for the top 20% of results.

C. 20% of the output driving 80% of the results.

D. Isolating the top 75% of causes that are responsible for the top 25% of results.

6. Calculate the 3-month moving average of Sales. What is the 3-month moving average in July?

A. $398,047

B. $406,990

C. $409,180

D. $399,188

7. What would be the benefit of using a moving average instead of a straight average?

A. Reducing the impact of short-term volatility within the data.

B. Increasing the impact of short-term volatility to smooth out a dataset.

C. Accounting for long-term volatility within the data.

D. A straight average does not account for long-term or short-term volatility.

8. Which of the following would be the purpose of using standard deviations in analytics?

A. To quickly determine the mean and median of a dataset.

B. Outlier detection.

C. A and B

D. Neither A or B

9. Using two standard deviations to analyze Sales, are there any months that stand out as outliers?

A. October

B. April

C. March

D. August

10. What is the weighted average of Sales by US states?

A. $327

B. $340

C. $365

D. $342

11. What months are above or below the 25th and 75th percentiles of Sales?

A. August, April

B. April, October

C. August, March

D. March, December

12. What is the purpose of building a histogram?

A. To visually compare dimension members.

B. To understand the distribution of data within a dataset.

C. To use bars to compare time-series data.

D. None of the above

13. What is a cluster analysis doing?

A. Grouping data points based on their relative importance to a model’s output.

B. Organizing data points into groups based on how closely associated they are.

C. Separating data by color.

D. All of the above

14. Which of these is a typical input used in forecasting?

A. Custom aggregation

B. No aggregation

C. Seasonality

D. B and C

15. In what situation would a waterfall chart be appropriate?

A. Analyzing a part-to-whole relationship.

B. Conducting a correlation analysis.

C. To find the distribution of data.

D. None of the above

16. When would you use a slope chart?

A. To compare data points in one category against another.

B. To compare multiple categories across two points in time.

C. To compare a single category against itself.

D. A and B

17. Which of these advanced techniques does not assume your data has a normal distribution?

A. Linear Regression

B. One-way ANOVA tests

C. Median Absolute Deviation

D. All of the above

18. What does an MSE of 0 prove of your model quality?

A. Your regression line is a perfect fit.

B. Your regression line does not fit your data well.

C. Low MSE indicates estimated values are close to true values.

D. None of the above

19. Which portion of a box and whisker plot displays the range that contains 50% of the data?

A. The space between the top of the box plot and the upper whisker.

B. Outerquartile Range

C. Upper whisker

D. Interquartile Range

20. Create a box plot that visualizes video-views of Activity Titles. Which Activity Title falls above the upper whisker?

A. Exercise: Make a Bar Chart in Tableau

B. Two Ways to Dynamically Show the Top N vs Other

C. How to Normalize Current and Prior Dates on One Axis in Tableau

D. Exercise: Create a Ranged Dot Plot in Tableau

21. Build a waterfall chart to visualize Sales by Product. What is the percent of total for the second Product when sorting in descending order?

A. 7.36%

B. 4.82%

C. 3.97%

D. 14.75%

22. Create a slope graph that compares the Sales of US states from January to December. Which states starts in 13th and ends in 8th?

A. MA

B. OR

C. VA

D. WA

23. Build a pareto chart. What is the actual percent of Activity Titles that make 80% of the total usage (count of Activity URL)?

A. 52.44%

B. 50.89%

C. 52.22%

D. 52.67%

24. Which of the following normalization methods focuses on the absolute difference between two measures?

A. Min-max normalization.

B. Zero-baseline normalization.

C. Normalizing data by population size.

D. None of the above

25. What is the main difference between a simple moving average and an exponential moving average?

A. You cannot include the current data point in a moving average calculation, but you can include it in an exponential moving average.

B. An exponential moving average gives the same weight to all previous values while a moving average gives more weight to recent values.

C. A simple moving average goes back a predetermined distance in the data and takes the average through the current data point while an exponential moving average gives more weight to recent values.

D. None of the above

Let us know who is taking the test:

First Name(Required)

Last Name(Required)

Playfair+ Email(Required)

Phone

Company Name

Visual Analytics Engineering Advanced Exam

What to know:

Let us know who is taking the test: