High Level Design
Overview
Educational institutions, such as colleges and universities, need to constantly balance their need to fill their academic programs to increase income from enrollment with the desire to maintain high standards, which contributes to the institution's prestige and ability to receive more funding for research. Therefore, these institutions need a reporting tool which enables them to run sensitivity tests and recognize which programs fill/don’t fill capacity, what are the demands for each program, etc. In addition, a reporting tool can also assist in recognizing programs with high demand, so the institutions can allocate more resources to increase capacity.Goals
Increase revenue from enrollments while maintaining a high requirement threshold (Allocate necessary resources for applicants who meet minimum requirements but are denied to programs since there is no availability for them in the program)
Objectives
- Adjust requirements based on Acceptance rate
- Fill yearly capacity
KPIs Architecture
Objective | KPI’s | Measures | Data source |
Adjust requirements based on Acceptance rate
|
Acceptance Rate | [Total FlagAccepted]/[# of FlagAccepted] | FactApplications |
# of Applicants | dupcount([Flag Accepted]) | FactApplications | |
# Accepted | [Total FlagAccepted] | FactApplications | |
Meet requirements but weren’t accepted | [Total FlagQualified]-[Total FlagAccepted] | FactApplications | |
Acceptance Rate by Faculty | [Total FlagAccepted]/[# of FlagAccepted] | FactApplications,
DimPrograms |
|
Acceptance Rate by College Degree | [Total FlagAccepted]/[# of FlagAccepted] | FactApplications,
DimPrograms |
|
Acceptance Rate by Gender Type | [Total FlagAccepted]/[# of FlagAccepted] | FactApplications, Applicants | |
Fill yearly capacity
|
Occupancy rate | [Total FlagAccepted]/[Total Yearly Capacity] | FactApplications
DimPrograms |
Capacity | [Total Yearly Capacity] | DimPrograms | |
Not Qualified | ([# of FlagQualified],[FlagQualified]) | FactApplications,
DimPrograms |
|
Qualified but not accepted | [Total FlagQualified]-[Total FlagAccepted] | FactApplications,
DimPrograms |