Visual Analytics Engineering Intermediate Exam
What to know:
Only Playfair+
Core
and
Premium
members are eligible
You will need the
Proxy
dataset
This test is designed to take 60 – 90 minutes
You must answer 20 of 25 questions correctly to pass
Following the exam, we’ll review your answers and respond within 3 – 5 business days.
Get Started
Δ
Step
1
of
26
3%
The questions in this exam are from Playfair Data's Proxy dataset. Download the latest version here
1. Using IF THEN logic, how many sales does the Core membership have?
A. $245,100
B. $188,000
C. $3,025,800
D. $698,460
2. Create logic to find the sum of Sales for only KS and MO where the Core product increased by 30% in KS and increased by 10% in MO. The Premium product also increased by 20% in KS and 50% in MO, and all other product types for the two states remained the same.
A. $2,548,123
B. $367,410
C. $572,130
D. $3,810,960
3. What is the average videos watched for Premium members that joined with a discount?
A. 3,362.0
B. 53.6
C. 9.0
D. 29.4
4. Find the count of customers that purchased a Core membership and received a discount.
A. 685
B. 340
C. 1,663
D. 3,362
5. What is the best use-case for choosing a scatter plot to visualize data?
A. Comparing categorical data.
B. Visualizing time series data.
C. Finding correlations between data points.
D. Identifying outliers.
6. Find the running sum of customers subscribing to Free memberships from January to June.
A. 5,471
B. 6,596
C. 2,867
D. 3,468
7. What is the Month over Month percent change of the count of Free memberships from May to June?
A. 2.91%
B. 1.35%
C. 1.33%
D. 4.56%
8. What is the percent of total count of customers for Premium memberships in the Product dimension?
A. 53.05%
B. 25.93%
C. 24.68%
D. 12.83%
9. Which chart type would be best used for setting goals or measuring progress?
A. Bullet chart
B. Highlight table
C. Histogram
D. Scatter plot
10. Find the difference in Sales between Florida, Kansas, and Texas. Which has the largest difference in Sales?
A. FL and KS
B. KS and TX
C. FL and TX
11. Which states in the US have an average number of videos viewed less than the national average?
A. CO, MT, TX
B. IA, OR, WI
C. IA, NV, CO
D. NV, NJ, CA
12. Create a map to visualize the distinct count of customers by city. Find the city that has the most Customer IDs.
A. Orlando
B. Kansas City
C. Dallas
D. Chicago
13. Create a filled map to visualize Sales by State. Which state has the most Sales?
A. MA
B. KS
C. FL
D. TX
14. Which of the following uses the correct conditional logic to return the US states that have total Sales between a minimum of $1,000 and at most $2,000?
A. IF SUM(Sales) >= $1,000 AND SUM(Sales) <= $2,000 THEN States
B. IF SUM(Sales) > $1,000 AND SUM(Sales) < $2,000 THEN States
C. IF SUM(Sales) = $1,000 OR SUM(Sales) = $2,000 THEN States
D. IF SUM(Sales) $1,000 AND SUM(Sales) < $2,000 THEN States
15. What is a major benefit of using parameters within your analysis?
A. Too many parameter can detract from the impactfulness of your analysis.
B. A parameter allows the stakeholder to interact with the analysis.
C. Parameters don’t let you change the data displayed.
D. A parameter permanently changes the state of your analysis.
16. When creating a dual-axis chart, why is it important to synchronize your axes?
A. Synchronizing axes makes it easier to see trends in your charts.
B. Unsynchronized axes are not misleading in dual-axis charts if your two y-axes are similar in values.
C. Synchronizing axes allows you to compare two different measures on the dual axis chart.
D. Unsynchronized axes can unintentionally mislead readers.
17. What is the main difference between a heat map and a highlight table?
A. To transition an audience from spreadsheets to data visualizations.
B. To identify the highest and lowest values in a dataset.
C. To visualize two measures at once with two preattentive attributes.
D. Both A and B
18. Which chart type would be best suited to analyze the distribution of a dataset?
A. Bullet chart
B. Histogram
C. Scatter plot
D. Highlight table
19. What is the percent of total sales of the campaign "pf+-3dr-0508"?
A. 0.63%
B. 0.55%
C. 0.58%
D. 0.44%
20. What is the best way to describe "Level of Detail"?
A. The aggregate calculations used to summarize a view.
B. The granularity of the data within your view.
C. The lowest granularity in the dataset, regardless of the data within your view.
D. The highest granularity in the dataset, regardless of the data within your view.
21. Build a scatter plot. How many campaigns have above average Sales and above average Discount Amount?
A. 67
B. 23
C. 60
D. 62
22. Using the scatter plot built in the last question, how many campaigns have below average Sales and above average Discount Amount?
A. 28
B. 23
C. 29
D. 20
23. Build a box and whisker plot visualizing Sales by State. What are the four outlier states?
A. IA, TX, CA, NY
B. KS, TX, CA, FL
C. TX, MN, MS, OR
D. NY, WI, KS, FL
24. Build a bullet chart that measures each month's actual Core Sales compared to a monthly Core Sales goal of $60,000. How many months have met this Sales goal?
A. 5
B. 10
C. 6
D. 2
25. Build a highlight table to find out which Product and Activity Type has the greatest count of customers.
A. Core, Download
B. Free, Page-read
C. Premium, Download
D. Premium, Video-view
Let us know who is taking the test:
First Name
(Required)
Last Name
(Required)
Playfair+ Email
(Required)
Phone
Company Name
0% Completed!
Previous
Next
Exit
Cookie Settings
