Preppin' Data

Solution by Tom Prowse and you can download the workflow here .  The challenge this week comes from Andreea Scintei where we try to evaluate the quality of teaching based on surveys and results data. Step 1 - Join Data Sets First we want to input both tables from the input files and then join them using an inner join on Student ID: Step 2 - Avg Grades Next we want to calculate the average grade per class for each subject. We can do this using an aggregate step where we group by Class and Avg Economics, English, and Psychology:  At this stage our data table should look like this:  Step 3 - Pivot Data We're now in a position where we can change the shape of our table by pivoting so that we have a column for Subject, Grade, and Class. To achieve this we want to do a columns to rows pivot where we bring Economics, English, and Psychology into the pivoted fields section:  Our table should now look like this:  Step 4 - Filter & Rank The final steps are to cal...

Challenge by: Andreea Scintei This is our next challenge from one of the members of the 38th cohort of the Data School UK. This week the Prep School has decided to evaluate the quality of their teaching. As this is not an easy task they are trying to tackle it from different points of view. They have a team conducting surveys and one analysing student performance over the past year.  As part of the analytics team, you have been tasked with identifying which classes struggle the most with each course so that the school can provide targeted support or adapt their approach to the curriculum. Inputs 1. Student Information   2. Student Results  Requirements Input the data Join the datasets together Aggregate to get the average grade per class for each subject Pivot the data to get 3 columns and rename -  Subject, Grade and Class Add a clean step to rank  In Tableau Prep -> right click the Grade column - create calculated field - Rank - Group by Subject Filter to t...