Building a Recruitment and Admissions fact table

View previous topic View next topic Go down

Building a Recruitment and Admissions fact table

Post  kikesegarra on Tue Nov 17, 2009 3:50 pm

Hi

I'm currently working in a Recruitment and admissions data mart for a university. Right now I'm designing the student fact table. In this fact table I want to track the prospective student events during the recruitment, application, and admission process. I'm not sure if I have to build a separate fact table for the prospect student because this is a process that involve different contact dates with the prospective student, and the application and admission part has only one or two contacts. I was thinking about an Accumulating Snapshot for the admission part and a separate fact table with 1 or more rows per student for the Recruitment or prospect process. I would like your opinion on this.

Thanks

kikesegarra

Posts : 1
Join date : 2009-11-17

View user profile

Back to top Go down

Re: Building a Recruitment and Admissions fact table

Post  ngalemmo on Tue Nov 17, 2009 5:34 pm

Generally, fact tables should focus on a particular process or event. For example, in an order-to-cash environment for a manufacturer, you have orders, fulfillment/shipping and invoicing. These are separate activities and are captured in separate fact tables. One may build an aggregate of these three subject areas, but not without first collecting the detail separately. In your case, you have applications, admissions and eventually, enrollment. These are three somewhat independent steps that occur at different times with their own processes, not unlike the order-to-cash scenario.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Building a Recruitment and Admissions fact table

Post  Vincent Rainardi on Thu Nov 19, 2009 12:00 pm

I'd put the recruitment, application and admission processes into 3 separate fact tables Kkesegarra, as they are 3 different business events.

Vincent Rainardi

Posts : 6
Join date : 2009-02-03
Location : London

View user profile http://www.datawarehouse.org.uk

Back to top Go down

Re: Building a Recruitment and Admissions fact table

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