Week 3 Quiz :Data Visualization and Communication with Tableau (Excel to MySQL: Analytic Techniques for Business Specialization)Answers 2025

Number of different sequences of tests after removing Shih Tzu 190 lbs
✔ at least 4
❌ 1, ❌ 2, ❌ 3, ❌ at least 15
Day of the week with most games played
✔ Wednesday
❌ Thursday, ❌ Friday, ❌ Saturday, ❌ Sunday
Month with most tests completed
✔ October 2014
❌ August 2013, ❌ March 2014, ❌ June 2015
Hour of the day with most games played (US, adjusted for time zones)
✔ 7 PM
❌ 7 AM, ❌ noon, ❌ 3 PM, ❌ 10 PM
Approx. % of users completing 20 tests
✔ 8%
❌ 6%, ❌ 15%, ❌ 23%, ❌ 25%
% of “Free Start” users completing 20 tests
✔ 1%
❌ 6%, ❌ 17%, ❌ 22%, ❌ 29%
Possible value in “Second(Created At)” column
✔ 39
❌ 2/8/2013 1:39:00 AM, ❌ 0, ❌ 1:39:00 AM
Missing aggregation in rank calculation RANK(([Created At]),'asc')
✔ an aggregation before [Created At], the most appropriate of which is ATTR
❌ aggregation after, ❌ MEDIAN, ❌ nothing missing
Rank calculation partitioned by Dog ID and Test Name
✔ List “1” for the first test of every Dog ID
❌ Provide incorrectly ranked number, ❌ Provide correctly ranked number for every test, ❌ Provide one number for every test within subcategory
Partitioning fields to rank tests per human user
✔ User ID
❌ Created At, ❌ Dog ID, ❌ Test Name, ❌ None of the above

Q#	Topic	Answer / Insight
3	Test sequences after removing Shih Tzu 190 lbs	At least 4 sequences
4	Day of week most games	Wednesday
5	Month most tests	October 2014
6	Hour most games (US)	7 PM
7	% users completing 20 tests	8%
8	% “Free Start” users completing 20 tests	1%
9	SECOND(Created At) value	39
10	Missing aggregation in rank calc	Aggregation before Created At → ATTR
11	Rank table by Dog ID/Test Name	1 for first test of each Dog ID
12	Partitioning field for human user rank	User ID