[ARCHIVED] Combining quizzes with courses

[jbeavers2]

We are trying to connect Canvas quizzes to course codes and are unable to make it work. The problem is one course id has multiple course codes in the course_dim table. So if we join the quiz_dim and the course_dim table, the same quiz would be joined to multiple course_codes which should not be the case. Ideally every course_id should have only one course_code in the course_dim table. So we need to know if there is some other field that can be used to connect quizzes with course codes. Any help would be appreciated!

[apritchett]

Greetings Jeffrey, I think I understand what your trying to do so hopefully my answer helps you.

First, I would start with the [quiz_fact] and join [quiz_fact].[Quiz Id] to [quiz_dim].[Id] and then [quiz_fact].[Course Id] to [course_dim].]Id]. 

Second, I am assuming when you say "course codes" you are referring to [course_dim].[Code].  In this case, the "course code" is not unique because the same course was offered in more than one term.  This will result in multiple quizzes being assigned to the same "course code".  If you bring in a unique identifier such as [course_dim].[Canvas Id] first this should produce what you're looking for.  Keep in mind if there are multiple quizzes in the course you will see a line item for each quiz associated with that [course_dim].[Canvas Id].