College Acceptance Rate

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

 Entities Relationship Diagram

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation

TOP