Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Admission Acceptance Process

2 posters

Go down

Admission Acceptance Process Empty Admission Acceptance Process

Post  businessintelligence Mon Aug 03, 2015 2:56 am


I am trying to model a student acceptance process. The University offers a student a place, further students have the option to either accept or reject the offer and these statuses could also repeat in any number of combinations. First decline and then accept or vice-versa.

The business is interested to know the latest status of each applicant. How many were offered, how many accepted, how many decline, how many did not reply and so on. They are interested to analyze this data based on the applicant dimension.

Can you suggest what is the appropriate fact table design to answer this question and what is the type of fact table


Posts : 14
Join date : 2015-06-23

Back to top Go down

Admission Acceptance Process Empty RE:Admission Acceptance Process

Post  hkandpal Mon Aug 03, 2015 11:44 am


this could be a transactional fact, where in you can capture the students degree level information, course and other information. Also you could store if the student has been accepted, waitlisted, rejected.




Posts : 113
Join date : 2010-08-16

Back to top Go down

Back to top

- Similar topics

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