High Level Design


Educational institutions such as colleges and universities need to constantly balance between their desire to fill up their academic programs which would increase income from enrollment to maintaining high requirements which contributes to the institutions prestige and ability to receive more funding for research. Therefore, these institutions have a need for a reporting tool which enables them to run sensitivity tests and recognize which programs fill/don’t fill capacity, what are 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

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

College Acceptance - Education Dashboard 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)


  • 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

 Entities Relationship Diagram