Reports

NEW: Metadata Reference Dossier

May 2021

The Business Intelligence Services team has created a dashboard that will help users identify all available data elements in the Academic project. Data elements are grouped by type, either attributes (descriptive data) or metrics (measures). Users will be able to browse and search for metrics and attributes by name and category. Furthermore, users will be able to see the descriptions of the metrics and attributes. The Long Description will provide additional information about the attributes and metrics in the Academic project. This dashboard was designed to help MicroStrategy users better understand the attributes and metrics used in their reports. The BIS team continues to work with subject matter experts from across the University to complete and improve this resource.

Report Location/MicroStrategy Folder Path
  • Academic > Shared Reports
  • Click HERE to go to the dashboard
Availability

This report is available to all users who have access to the MicroStrategy Academic Project.


NEW: UG Student Change Major Dashboard

May 2021

This dashboard shows Undergraduate students Primary Major changes by Application Major or Degree Major from the Admit Term through Degree Term. The data includes the count of active students per term, grouped by their Primary Major 1. This dashboard contains 3 chapters titled:

  • Application Major Analysis
    • Based on the selected Admit Term, Application College and Application Major, this visualization shows the student’s progression from the term they applied to the term they earned a degree. The Sankey diagram shows changes to a student’s Primary Major between the fall terms, from the selected admit term through the following seven fall terms. The same information is shown in the form of text in the grid below the visualization.
  • Degree Major Analysis
    • Based on the selected Admit Term, Degree Term, Awarded Degree College and Awarded Degree College Major 1, this visualization shows the Primary Major progression from the Term they applied to a Major to the Term they earned a Degree. Like the Application Major Analysis chapter, the Primary Major progression is shown for the Fall terms from the selected Admit term through the following seven Fall Terms. The same information is shown in the form of text in the grid below the visualization.
  • Dashboard Help
    • This is a help section that contains information about each chapter and how to use the dashboard. This Dashboard shows only Undergraduate student data and will always contain the last 10 years of data, including current year data. For example, if we are in 2020, we will have data from 2010 to 2020.
Report Location/MicroStrategy Folder Path
  • Academic > Shared Reports > Student Registration/Enrollment > Majors, Minors and Concentrations
  • Click HERE to go to the dashboard
Availability

This report is available to all users who have access to the MicroStrategy Academic Project.


NEW: Budget Incentive Model

May 2021
In a joint effort with the Office of Budget and Planning, BIS has created several new MicroStrategy reports enabling users to see credit hours and estimated tuition revenue based on registered credit hours by course section college and by student primary major college.

  • FY Tuition Detail for Course College

    This report contains Credit Hours and estimated Tuition Dollars for Course College by Fiscal Year, College, Domicile, Level, TermT, Department, and Subject as of the first day of the Unrestricted Withdrawal period. Includes only Standard Credit Hours.

    Report Location/MicroStrategy Folder Path
    • Location: Academic > Shared Reports > Budget Incentive Model > Tuition Calculations
    • Click HERE to go to the report
  • FY Tuition Detail for Stu Major College

    This report contains Credit Hours and estimated Tuition Dollars for Stu Major College by Fiscal Year, College, Domicile, Level, Term, Department, and Major as of the first day of the Unrestricted Withdrawal period. Includes only Standard Credit Hours.

    Report Location/MicroStrategy Folder Path
    • Location: Academic > Shared Reports > Budget Incentive Model > Tuition Calculations
    • Click HERE to go to the report
  • FY Tuition Summary by College

    This report contains Credit Hours and estimated Tuition Dollars for both Course College and Stu Major College by Fiscal Year, College, Domicile, Level, and Term as of the first day of the Unrestricted Withdrawal period. Includes only Standard Credit Hours.

    Report Location/MicroStrategy Folder Path
    • Location: Academic > Shared Reports > Budget Incentive Model > Tuition Calculations
    • Click HERE to go to the report.
  • Credit Window Law

    This report contains Credit Hours falling within the 15-17 Law credit hour window. The report also provides estimated Tuition Dollars for these credit hours, using the appropriate per credit hour rate. These metrics are calculated by Student, Term, and Student Major College as of the first day of the Unrestricted Withdrawal period. This report only includes Standard Credit Hours.

    Report Location/MicroStrategy Folder Path
    • Location: Report: Academic > Shared Reports > Budget Incentive Model > Credit Window
    • Click HERE to go to the report
  • Credit Window UG

    This report contains Credit Hours falling within the 13-15 Undergraduate credit hour window. The report also provides estimated Tuition Dollars for these credit hours, using the appropriate per credit hour rate. These metrics are calculated by Student, Student, Term, and Student Major College as of the first day of the Unrestricted Withdrawal period. This report only includes Standard Credit Hours.

    Report Location/MicroStrategy Folder Path
    • Location: Academic > Shared Reports > Budget Incentive Model > Credit Window
    • Click HERE to go to the report
  • Allocations

    This dashboard shows the percentage each college contributes to the total number of credit hours. It supports the allocation rules applied as part of the Budget Incentive Model.

    Report Location/MicroStrategy Folder Path
    • Location: Academic > Shared Reports > Budget Incentive Model > Allocations
    • Click HERE to go to the dashboard
  • Budget Incentive Model Reference Reports

    Budget Incentive Model reports contain groupings, filter logic, and element values that are specific to the Budget Incentive Model business rules and calculations. Therefore, BIS has created these reference reports that show these values so that users are able to better understand how they are derived and how they relate to other data elements.

  • Budget Level

    This report shows how the Budget Level attribute is derived from a combination of Student Level and Student Primary Degree Level. As of March 2021, the Budget Level is used on the following Budget Incentive Model reports:

    • Allocations
    • Credit Window LAW
    • Credit Window UG
    • FY Tuition Detail for Course College
    • FY Tuition Summary by College
    • FY Tuition Detail for Stu Major College
  • Priority Date

    This report shows the calendar date on which the Unrestricted Withdrawal period begins in each term. The number of registered credit hours on this day is used in all Budget Incentive Model calculations. You can see this in each report’s description. The report description is located below the title of the report. Below is an example.

  • Parts of Term Per Fiscal Year

    This report shows how each Term and Part of Term within it are assigned to a Fiscal Year. The parts of term for a Summer term are assigned either to the Fiscal Year ending on June 30 or the Fiscal Year beginning on July 1.


ENHANCEMENT: Missing Grades Report

May 2021

The missing grades report previously included a filter that excluded Wiley courses. This Wiley filter inadvertently excluded courses whose campus was MOL (Mason Online). We have removed this filter and now the Missing Grades report shows results of missing grades in courses that are Wiley and courses whose campus is MOL.

Report Location/MicroStrategy Folder Path
  • Academic > Shared Reports > Student Academics > Student Registration/Enrollment > Student Registration/Enrollment Restricted > Grades
  • Click HERE to go to the dashboard
Availability

This report is restricted and is only available to uses who have the Transcript Banner database role. To be assigned this role please follow these steps:

  1. Contact your Banner Liaison and request the Transcript Banner Database Role. You can identify your Department Banner Liaison using the following URL: https://patriotweb.gmu.edu/gmuhelp/banner_liaisons.html
  2. Follow the instructions provided by your Banner Liaison to complete the permission process.

ENHANCEMENT: Graduating Students Per Term Reports

May 2021

All versions of the Graduating Students Per Term reports have been updated to include the new attribute Stu Email – Other. This is an email address provided by the student.

Report Location/MicroStrategy Folder Path
  • Graduating Students Per Term: MicroStrategy Folder Path: Academic>Shared Reports>Student Academics>Degree/Graduation>Graduating Students
  • Click HERE to go to report
  • Graduating Students (All Terms): MicroStrategy Folder Path: Academic>Shared Reports>Student Academics>Degree/Graduation>Graduating Students>Graduating Students (All Terms)
  • Click HERE to go to report

Attributes & Metrics

NEW: Student Other Email

May 2021

We have added a new attribute named Stu Email – Other. This new attribute contains an email provided by the student which is not their GMU email. We have added this attribute to the following Academic Cubes:

  • Degree Application per Term
  • Degrees Awarded per Term
  • Student and Course Registrations per Term
  • Students per Term
  • Student Data per Course Section

Standard Datasets / Cubes / Templates

ENHANCEMENT: Report Templates

May 2021

Important Note

For an introduction on how to use MicroStrategy dashboards, also known as Dossiers, please take the 20-minute self-paced Dossier Introduction video course in MasonLeaps. Select George Mason MicroStrategy Dossier Introduction to access the course.

For training on how to develop reporting using the templates, please use MasonLeaps to register for an upcoming MicroStrategy Academic Analyst course offered by the BIS team.

Report Templates are pre-formatted grid reports and dossiers that can be used as a starting point for building reports and dashboards. These templates are pre-formatted with standardized datasets that enable an analysis of specific subject areas, such as application per term, course registration per term, student enrollment per term, and student enrollment with course and credit hour counts. Below are the four new templates available and their descriptions:

  • Applications Per Term
    • This template contains application and applicant data elements and metrics.
    • Location: Academic > Shared Reports > *Report Templates >Admissions
    • Click HERE to go to the template
  • Degrees Awarded Per Term
    • This template contains data for reporting all awarded degrees for the current and recent terms.
    • Location: Academic > Shared Reports > *Report Templates > Degrees
    • Click HERE to go to the template.
  • Course Registration Per Term
    • This template contains course registration data elements and metrics.
    • Location: Academic > Shared Reports > *Report Templates > Courses
    • Click HERE to go to the template
  • Student and Course Registration per Term
    • This template contains data for reporting student course registration information for the current and recent terms, including student course registration hours.
    • Location: Academic > Shared Reports > *Report Templates > Students
    • Click HERE to go to the template.
  • Student per Term
    • This template contains data for reporting all students for the current and recent terms. This includes active students and those that became inactive within the term.
    • Click HERE to go to the template.

The following dataset requires Transcript level access:

  • Degree Applications per Term
    • This template contains data for reporting all degree applications for the current and recent terms.
    • Location: Academic > Shared Reports > *Report Templates > Degrees > Degrees Applications (Restricted Access)
    • Click HERE to go to the template.