Visual Analytics Engineering Fundamentals 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. Find the distinct count of Campaign IDs.
A. 10
B. 194
C. 12,966
D. 227
2. Find the sum of Sales.
A. $4,734,110
B. $365
C. $120,966
D. $3,473,941
3. What is the maximum Discount Percentage?
A. 25%
B. 33%
C. 50%
D. 75%
4. What is the average Sales per customer?
A. $400
B. $450
C. $341
D. $365
5. What is the total Discount Amount?
A. $262,940
B. $215,104
C. $194,820
D. $318,270
6. What is Sales minus Discount Amount?
A. $4,519,006
B. $4,471,170
C. $4,539,290
D. $4,415,840
7. Find the sum of Discount Amount for Premium memberships within the Product dimension.
A. $95,400
B. $137,502
C. $169,200
D. $202,500
8. Extract the first two letters of Customer ID. Which two letter combination has the highest customer count?
A. LA
B. AJ
C. CG
D. SJ
9. Extract the last two characters of Customer ID. Which two character combination has the lowest customer count?
A. 98
B. 85
C. 60
D. 42
10. How many Customer ID's contain the pattern "1134"?
A. 12
B. 8
C. 7
D. 10
11. Filter to Kansas. Which Customer ID has the highest Sales?
A. AF-11024550
B. AE-5099636
C. AY-6734980
D. AV-8080712
12. Filter to Florida. Which membership in the Product dimension has the highest count of customers?
A. Core - 87
B. Free - 1,279
C. Free - 1,135
D. Premium - 457
13. How many customers have Sales between $450 and $900?
A. 6,088
B. 5,025
C. 3,362
D. 4,425
14. Which customer has viewed the most videos?
A. HJ-5436171
B. OH-11974258
C. YG-2479877
D. MI-1775608
15. What is the distinct count of customers that have a sum of Sales less than $450?
A. 8,534
B. 8,541
C. 12,959
D. 8,537
16. How many customers had greater than a 10% discount?
A. 406
B. 255
C. 576
D. 982
17. What is the count of Customer ID for the Strategy skill content published by Ryan Sleeper?
A. 12,939
B. 12,932
C. 12,851
D. 11,111
18. Which state is in the top 10 when ranking by Sales?
A. VT
B. AL
C. WI
D. IL
19. Which option most accurately describes the type of calculation that combines and summarizes multiple data points into a single value?
A. Row-level calculation
B. Aggregate calculation
C. String calculation
D. Level of Detail calculation
20. Which chart type would be best suited for comparing discrete, categorical values?
A. Pie chart
B. Line graph
C. Bar chart
D. Scatter plot
21. Build a line graph that visualizes Sales over time. Which month had the lowest Sales?
A. October
B. August
C. April
D. March
22. Build a line graph that visualizes Discount Amount over time. Which month had the highest Discount Amount?
A. October
B. September
C. June
D. March
23. Build a bar chart that visualizes the count of customers by Product. Which Product has the most customers?
A. Premium
B. Free
C. Core
D. Public Event 2
24. Build a bar chart that visualizes Sales by Medium, which Medium accounts for the most Sales?
A. Email
B. Affiliate
C. Referral
D. Organic
25. Build a line graph that visualizes Sales by Country over time. Which month does Mexico have more Sales than Canada?
A. March
B. July
C. February
D. October
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
