Course Dimension

View previous topic View next topic Go down

Course Dimension

Post  MarkW on Mon Feb 22, 2016 2:43 pm

I am trying to create a data mart around training completion/non-completion for our company's learning and development program. An obvious candidate dimension would be 'course', but there are two different types of courses - those that belong to a curriculum and certification (looks like a hierarchy), and those that are extra-curricular ad hoc courses. What is the a best way to model this, with one or two dimension tables?

MarkW

Posts : 14
Join date : 2015-11-25

View user profile

Back to top Go down

Re: Course Dimension

Post  ngalemmo on Mon Feb 22, 2016 4:54 pm

Curriculum and course are two different things, so there are two dimensions but not two dimensions for course.

You would have a course dimension and a curriculum dimension. There would be a bridge table to record which courses belong to which curriculums. There would also be a fact table for enrollment. Curriculum may or may not be a dimension of the latter depending on wither or not you know the student enrolled in the course to satisfy a particular curriculum. If you don't, you can always analyze progress toward completion of a curriculum by combining data from the curriculum bridge and enrollment facts.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Course Dimension

Post  MarkW on Tue Feb 23, 2016 4:19 am

I think that's where I am doubting myself in how I need to structure the tables, or the bridge tables to be exact.

In the operational system (source) there are the following tables:

transaction

enrolments (PK enrolmentid, FK learningid)

master/attribute

curriculumcourses (PK id, FK learningid, FK parentid)
learningobject (PK learningid)
coursecompetency (PK id, FK learningid, FK competencyid)
competency (PK competencyid)

MarkW

Posts : 14
Join date : 2015-11-25

View user profile

Back to top Go down

Re: Course Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum