Welcome to Business Intelligence Services' Content Catalog.

This dashboard is part of the Provost and Deans - Planning Dashboards portfolio. This report is intended to look at the distribution of credit hours through different lens: who are the students being taught, how much is the department teaching, and the credits taught by full-time vs part-time faculty. It shows the trend over the last 5 academic years. Security: Deans and their designates will only be able to view data from their own school. The Provost and his/her designates will be able to see all schools.

CLICK HERE TO VIEW CONTENT

This dashboard is part of portfolio, Provost and Deans - Planning  Dashboards. This report shows a Summary of total compensation paid to Faculty broken down by Research, Proposals, Number of Students, estimated gross tuition based on Credit Hours, and Tuition generated. Based on an "estimated per credit hour gross tuition amount" the report reflects whether a Faculty's salary is covered. The Detail report provides more data on the position and courses taught. Security: Deans and their designates will only be able to view data from their own school. The Provost and his/her designates will be able to see all schools. Only selected users will be able to view Compensation.

CLICK HERE TO VIEW CONTENT

This dashboard is part of portfolio, Provost and Deans - Planning  Dashboards. This report is a high level view that compares an academic program's enrollment versus the number of applicants in order to gauge how the programs are performing over a period of time. Security: Deans and their designates will only be able to view data from their own school. The Provost and his/her designates will be able to see all schools.

CLICK HERE TO VIEW CONTENT

This report allows users to create custom reports using "Award Management - PTA Expense Summary" data set

CLICK HERE TO VIEW CONTENT

QA Award Review dashboard includes two sub dashboards: QA Award Review and Admin Establishment to Fully Executed Review. QA Award Review dashboard is used by GCAS QA team to monitor the new awards setup to make sure the specified review points are correct. User can enter the award creation date from and to to pull all the awards that have been created during that period of time. For each review point that has a number greater than 0, user can click the number and see the details of the awards. Admin Establishment to Fully Executed Review dashboard is trying to capture the awards that were set up as admin establishment awards (with AT Risk status and $0 budget) , and then were changed to fulling executed awards (Active status with budget). This dashboard is to assist GCAS QA team to monitor the specified review points for the fully executed awards to make sure they were set up correctly.

CLICK HERE TO VIEW CONTENT

QS Admin Data

CLICK HERE TO VIEW CONTENT

QS Encumbrance Details

CLICK HERE TO VIEW CONTENT

Qs for Tableau

CLICK HERE TO VIEW CONTENT

This report identifes SMHS expenses for MFA reviewing

CLICK HERE TO VIEW CONTENT

Provides a comprehensive overview of benefitted Faculty, presenting demographic insights including age, gender, race/ethnicity, and years of service.

CLICK HERE TO VIEW CONTENT

This report is used by HR Benefits to list employees rehired in a specified date range. It includes comprehensive details about position and salary with filters for effective date range, employee type, benefit category and GWid. 

CLICK HERE TO VIEW CONTENT

This Dashboard provides email addresses and phone numbers for supplier sites that are listed as 1099 reportable suppliers. Also included are start and end dates.

CLICK HERE TO VIEW CONTENT

This report displays award project numbers with award organization name, PI and vendor names as well as expenditure account details such as award status, commitment number and description as well as encumbrance amounts

CLICK HERE TO VIEW CONTENT

Provides a comprehensive overview of benefitted Research, presenting demographic insights including age, gender, race/ethnicity, years of service, and career stream.

CLICK HERE TO VIEW CONTENT

Resident Raise Files is a report of active medical residents along with some position and demographic information for the purpose of promotion. 

CLICK HERE TO VIEW CONTENT

Resident Rasies Before and After Merit is a listing of all medical residents who were granted raises and some position and bio demographic information

CLICK HERE TO VIEW CONTENT

Resident Raises Before and After Merit for Payroll is a listing of medical residents and their raise information before and after merit was implemented.

CLICK HERE TO VIEW CONTENT

This report lists all active employees under benefit or deduction codes DFA, DFP, DFR, DTA, or DTP. In addition to a bulk filter for GW ID, the user will decide what employees are included in the detailed report. 

CLICK HERE TO VIEW CONTENT

This report lists all active employees for GW ID in a bulk filter. The user will decide what employees are included in the detailed information that shows the W4 address.

CLICK HERE TO VIEW CONTENT

This dashboard that contains retention and graduation rates of first-time, full-time freshmen who entered GW between 2003 to 2014 and contains 6 tabs: Enrollment, Retention, Graduation Overall, First to second year retention, First to third retention and Definitions in order to understand the metrics used.

Retirement Termination Reporting is a listing of terminated employees who are retirement eligible and their age at termination.

CLICK HERE TO VIEW CONTENT

This dashboard, with six tabs, is to support revenue recognition for different types of awards. Unconditional Contribution Dashboard lists all the awards that have Unconditional Contribution term.  Revenue will be booked for all unconditional contribution awards in the year of receiving contribution. Exchange Transactions CC Awards lists all CC awards that have Exchange term.  This report will calculate percentage of completion by expenditure, and percentage of completion by award dates and the expected expenditures. EC and EE Awards Events is to identify all the events that have not yet been billed and/or generated revenue. Revenue Recognized EE and EC Awards lists all the EE and EC awards with revenue generated in the month selected.  Both revenue generated in the month and accumulated revenue are listed in the dashboard. Unrecognized Revenue CC Exchange Award lists all the CC Exchange awards that have expenditures posted within the GL Date selected, and the expenditures with expenditure item dates before the date selected. EC Awards Cash over Revenue lists all EC awards that have Cash Receipts over Revenue generated for the awards.

CLICK HERE TO VIEW CONTENT

This report shows the usage of rooms by building, room number and term.  It shows the course that is being taught, including the room capacity and actual enrollment.

CLICK HERE TO VIEW CONTENT

This report is based on the Room Usage report with a variation to sort by Building and Room Number. It includes a report that lists one per column Meeting Pattern day and an additional report that concatenates the Meeting Pattern to combine days into one column (e.g., MWF). Academic Schedulers use this report for room assignments during semester scheduling.  

CLICK HERE TO VIEW CONTENT

List of all employees, including regular rates and annual salaries therefore, this report is highly confidential. 

CLICK HERE TO VIEW CONTENT

Benefit Eligible Staff who exceed the salary Maximum range OR are under the Salary Minimum. A prompt is required to calculate the aging percentage. 

CLICK HERE TO VIEW CONTENT

Provides insights into average and median salaries, along with their percentage differences, across different employee types and benefit-eligible positions, aiding strategic decision-making.

CLICK HERE TO VIEW CONTENT

This report provides transaction amount totals with student information by detail category code filtered by term code.

CLICK HERE TO VIEW CONTENT

This report provides deatils on course that have active CRN. 

CLICK HERE TO VIEW CONTENT

The purpose of this dashboard is to show the most recent comment input by the username for a student with a delinquent code. Details such as activity date, term code and GWid are displayed. 

CLICK HERE TO VIEW CONTENT