I have a vendor that is starting to give me some rather large reports on course completions and usage.
They have two formats for the reports:
If a student is enrolled in a course, they will have an row entry with basic student and course information for each course. Fields would be student name, student id, student email, course name, course status, course completion date.
Each student would have one row. Each course would be represented by a different column. So we would have student name, student id, student email, course name A, course status A, course completion date A, course name B, course status B, course completion date B, course name C, course status C, course completion date C, course name D, course status D, course completion date D...
The good point of report #2 is that it is much smaller than the report #1. However I am having a hard time getting a handle on executing views and jobs based on a variable column table (as courses get added I don't really know).
I need to make some advanced usage reports and wrap up student info with certain courses and completions. Is there a reason why one of the raw formats will either make my job easier or make the database perform queries easier?