2020: Week 23


This week's challenge is related to quiz results and answers! Many people are taking part in virtual pub quizzes with their friends and families and there is always the made panic at the end to total your scores! Therefore, for this week's challenge we are going to try and automate this process a little by solving this in Tableau Prep!

Each pair of participants have created their own set of 10 multiple choice questions. Therefore, creating 5 rounds and a total of 50 points up for grabs. 

Input

1. Participant Answers


This contains: 
  • Name - Name of the participants
  • Round 1-5 - These were the rounds of the quiz
  • Each cell shows the answers for that round. The first letter represents the answer to question 1, the second letter is question 2, and so on. 
2. Correct Answers


This contains the correct answers for each of the rounds. The answers are in the same format as the previous input.

Requirements

  • Input Data
  • Identify the participants and correct answer for each question
  • Combine the two input tables
  • Calculate how many correct answers per round and in total for each pair of participants.
  • Output Data

Output

  • 6 Rows (7 including header)
  • 8 Columns
    • Position
    • Name
    • Round 1
    • Round 2
    • Round 3
    • Round 4
    • Round 5
    • Total Score

The output can be found here for comparison. 

Make sure to fill in the participation tracker, share using #PreppinData on Twitter and post you solutions onto our Tableau Forums community page so that we can compare our workflows! 

Popular posts from this blog

2023: Week 1 The Data Source Bank

2023: Week 2 - International Bank Account Numbers

How to...Handle Free Text