I’m trying to get my head around how to set up my data model - and I seem to only be able to make things work with many to many relationships and crossfiltering in both directions.
From all of Sam’s videos I understand this to be a bad thing - though I don’t fully understand why.
So each student has a dozen classes. Each class has twenty something students. Each student has sat multiple assessments. The assessments are graded in different ways.
What I am trying to achieve is a model where I can filter for any course and produce a set of graphs of student performance for that class that are filterable by student characteristics (Gender, Ethnicity etc)
I then want to be able to identify who the students are at any grade level within a class from the graphs (i.e. graphs filter table).
What I have seems to work - but is that just an illusion? (only works if I use implicit rather than explicit measures)
Any help or suggestions would be greatly appreciated.