As an extra goodie, we add four more numeric additive facts representing or time gaps between “lags” particularly important steps in the process. These include Information Requested ==> Sent lag Application Submitted ==> Complete lag Application Submitted ==> Final Decision lag Final Decision ==> Accept or Decline lag These lag facts are both good diagnostics for picking out stalled applications, but they help the managers tune the process by identifying bottlenecks. Our fact table design looks like Preliminary Test Receipt Date Key (FK) Information Requested Date Key (FK) Information Sent Date Key (FK) Interview Conducted Date Key (FK) On-Site Campus Visit Date Key (FK) Application Submitted Date Key (FK) Transcript Received Date Key (FK) Test Scores Received Date Key (FK) Recommendations Received Date Key (FK) Admissions First Pass Review Date Key (FK) Reviewed for Financial Aid Date Key (FK) Admissions Final Decision Date Key (FK) Applicant Decision Received Date Key (FK) Admitted Date Key (FK) Enrolled Date Key (FK) Applicant Key (FK) Admissions Decision Key (FK) Preliminary Test Score Receipt Quantity Information Requested Quantity Information Sent Quantity Information Requested-Sent Lag Interview Conducted Quantity On-Site Campus Visit Quantity Application Submitted Quantity Transcript Received Quantity Test Scores Received Quantity Recommendations Received Quantity Application Complete Quantity Application Submitted-Complete Lag Admissions First Pass Review Quantity Reviewed for Financial Aid Quantity Admissions Final Decision Quantity Application Submitted-Final Decision Lag Accepted Quantity Decline Quantity Final Decision-Accepted/Decline Lag
As an extra goodie, we add four more numeric additive facts representing “lags” or time gaps between particularly important steps in the process. These include Information Requested ==> Sent lag Application Submitted ==> Complete lag Application Submitted ==> Final Decision lag Final Decision ==> Accept or Decline lag These lag facts are both good diagnostics for picking out stalled applications, but they help the managers tune the process by identifying bottlenecks. Our fact table design looks like Preliminary Test Receipt Date Key (FK) Information Requested Date Key (FK) Information Sent Date Key (FK) Interview Conducted Date Key (FK) On-Site Campus Visit Date Key (FK) Application Submitted Date Key (FK) Transcript Received Date Key (FK) Test Scores Received Date Key (FK) Recommendations Received Date Key (FK) Admissions First Pass Review Date Key (FK) Reviewed for Financial Aid Date Key (FK) Admissions Final Decision Date Key (FK) Applicant Decision Received Date Key (FK) Admitted Date Key (FK) Enrolled Date Key (FK) Applicant Key (FK) Admissions Decision Key (FK) Preliminary Test Score Receipt Quantity Information Requested Quantity Information Sent Quantity Information Requested-Sent Lag Interview Conducted Quantity On-Site Campus Visit Quantity Application Submitted Quantity Transcript Received Quantity Test Scores Received Quantity Recommendations Received Quantity Application Complete Quantity Application Submitted-Complete Lag Admissions First Pass Review Quantity Reviewed for Financial Aid Quantity Admissions Final Decision Quantity Application Submitted-Final Decision Lag Accepted Quantity Decline Quantity Final Decision-Accepted/Decline Lag
dimensional_modeling_considerations.docx