Power BI Report - Graduate Admission Report

Contact

• FunctionalReport User 1 ExampleUpdates
  • Department: UndergradInstitutional Admissions
  • User: Matt RutherfordEffectiveness
  • Org Chart Link: https://directories.www.clarkson.edu/orgchart/index.php?username=mrutherforganizational-chart?depart=86
• TechnicalReport UserUpdates 1 Example
  • Department: OIT
  Office
  • User:of slate@clarkson.edu
  the
  Dean
-
• Technical User 2 Example
  • Department: Graduate AdmissionsCRC
  • User: Amy Nevin
  • Org Chart Link: https://directories.clarkson.edu/orgchart/index.php?username=anevin
• Data Structure Updates
  • Department: OIT
  • User: helpdesk@clarkson.edu

Slate ProcessesDefinitions

• FormsAcademic Year
  • Definition: An academic year spans Summer to Spring. Academic Year 2023-24 includes Summer 2023, Summer Quarter 2023, Fall 2023, Fall Quarter 2023, Winter Quarter 2024, Spring 2024 and Spring Quarter 2024. 
  • SQL Logic: Populated by getting the ACAD_YEAR field from PS_TERM_TBL. Visually its changing the display to show CONCAT(ACAD_YEAR-1 ,'-', SUBSTRING(ACAD_YEAR, 2, 2)
• Academic Career
  • Definition: 
  • SQL Logic: SELECT ACAD_CAREER, DESCR FROM PS_ACAD_CAR_TBL where ACAD_CAREER IN (SELECT DISTINCT ACAD_CAREER FROM PS_CU_GRAD_ADM)
• Academic Program
• Academic Plan
• Student Types
  • International
  • Domestic
• Prospects
  • Form 1 Name - Link
  • Form 2 Name - Link
    
• MailingsApps
  • Mailing 1 Name - Link
  • Mailing 2 Name - Link
• QueriesComp. Apps
  • Query 1 Name - Link
  • Query 2 Name - Link
• Source FormatsAdmits
  • Source Format 1 Name - Link
• Other Slate Objects 1Denies
  • Other Slate Object 1 Name - Link
• Other Slate Objects 2Paids
  • Other Slate Object 2 Name - Link
• Declines
• Matrics
• Melt
• Grads

Instructions

1. Instruction 1
2. Instruction 2
3. Instruction 3
4. Instruction 4
5. Instruction 5