/uploads/galerie/000172/Adm Cockpit W.PNG

Detailed presentation of the ADMISSIONS dashboard

Your ADMISSIONS dashboard will contain 19 KPIs

  • ApplicationsTotal number of applications (including invalid applications)
  • Applications Under ReviewTotal number of valid applications having a status "Under Review"
  • Admitted (total)Total number of applications having a status "Admitted" or "Enrolled" or "Lost"
  • Acceptance RateShare of Admitted applications: "Total Admitted" / "Number of Considered Applications"
  • EnrolledTotal number of applications having a status "Enrolled"
  • Yield RateShare of admitted applicants who were enrolled: "Number of Enrolled" / ("Number of Enrolled" + "Number of Lost")
  • AdmittedTotal number of valid applications having a status "Admitted"
  • Considered ApplicationsTotal number of valid applications which are not withdrawn and not under review
  • Valid ApplicationsTotal number of applications (excluding invalid applications)
  • ApplicantsTotal number of applicants (excluding invalid applications)
  • RejectedTotal number of valid applications having a status "Rejected"
  • WithdrawnTotal number of valid applications having a status "Withdrawn"
  • Withdrawn %Share of Withdrawn compared to all valid applications
  • LostTotal number of valid applications having a status "Lost"
  • Enrolled+LostTotal number of valid applications having a status "Enrolled" or "Lost"
  • All ApplicantsTotal number of applicants (including invalid applications)
  • Invalid ApplicationsTotal number of invalid applications
  • Applications per ApplicantAvg number of applications per applicant (including invalid applications)
  • Applicant AgeAverage age of applicants

and 8 dashboard pages

Home

Admissions Home

Admissions Home
Admissions HomeAdmissions Home
Get a Home Page for your Admissions dashboard

Cockpit

Admissions Cockpit

Admissions Cockpit
Admissions CockpitAdmissions Cockpit
Get an overview on your admissions process: Applications, Admitted, Enrolled, Acceptance Rate Yield Rate...

Admissions Top KPIs Overview

Admissions Top KPIs Overview
Admissions Top KPIs OverviewAdmissions Top KPIs Overview
Get a transverse view on your top 6 Admissions KPIs, split by the dimension of your choice

Admissions Analytics

Admissions Process

Admissions Process
Admissions ProcessAdmissions Process
Get an overview of your admission process.

Admissions Weekly Analysis

Admissions Weekly Analysis
Admissions Weekly AnalysisAdmissions Weekly Analysis
Visualize how your admissions evolve across weeks

Admissions across Intakes

Admissions across Intakes
Admissions across IntakesAdmissions across Intakes
Visualize how your admissions evolve from one intake to another

GeoAnalytics

Admissions Country Analysis

Admissions Country Analysis
Admissions Country AnalysisAdmissions Country Analysis
Visualize the performance of any of your Admissions KPIs, at Country level

Admissions State/Province Analysis

Admissions State/Province Analysis
Admissions State/Province AnalysisAdmissions State/Province Analysis
Visualize the performance of any of your Admissions KPIs, at State/Province level

Creating your ADMISSIONS dashboard Step-by-Step

You want to get a clear understanding on your Admissions results? You want to build a Tableau dashboard to better understand your Admissions data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Admissions data in less than 5 minutes!

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Admissions data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

  • string
    Academic Period Name of the intake (e.g. "Fall 2019", "2019/2020"...)
  • string
    Academy College, University, Business School...
  • string
    Program Academic program in which the application if done
  • string
    Section Section of the program in which the application if done
  • date
    Application Period Start Date Start date of the application period for this program
  • date
    Application Period End Date Start date of the application period for this program
  • date
    Application Date Date of application (Date used for time-series analysis)
  • string
    Applicant Id Unique identifer of the applicant
  • string
    Gender Applicant gender: "Male", "Female"
  • date
    Birth Date Applicant Birth Date
  • string
    Residence Country Country of residence
  • string
    Residence State/Province State/Province of residence
  • string
    Valid Application Flag "Y" if all the documents are received to review the application
  • string
    Application Status Last application status: "Under Review", "Withdrawn" -> before Admitted/Reject assessment, "Admitted", "Rejected", "Enrolled", "Lost" -> the admitted applicant denied joining, or Null is the application is not complete

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Admissions' and upload your Tableau workbook (note: your data is NOT uploaded).

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

Finally, click 'Confirm & Download'... and your Admissions dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Admissions dashboard is now ready to be used or customized!


Other #DataViz Packs