Welcome to Business Intelligence Services' Content Catalog.

The catalog provides a way to find reports, dashboards, and associated business terms across the university's data domains. You must be connected to GW's VPN to access the links in this catalog.

For an explanation of the filters, see the catalog's glossary of terms.

Displaying 421 - 450 of 727

Data Domain
Community
Tags
Status
Reporting System
IGEN Award Review
Created Jun 26, 2020 10:28 am
Status Certified

This dashboard is to assist the GCAS team in the monthly billing. It includes two sub dashboards. One for CCNS awards and one for Event awards. This report is to allow GCAS billing specialist to review the unbilled awards before the automated invoice generation program runs.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IGEN Award Review
Created Jun 26, 2020 10:28 am
Status Certified

This dashboard is to assist the GCAS team in the monthly billing. It includes two sub dashboards. One for CCNS awards and one for Event awards. This report is to allow GCAS billing specialist to review the unbilled awards before the automated invoice generation program runs.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

Inactive PEAEMPL Home Org
Created Jul 19, 2024 10:48 am
Status Certified

Inactive PEAEMPL Home Org is a dashboard that shows employees who have a Banner Home Org that is inactive. 

Community

Human Resources

Intended Audience

HR Operations

Reporting System

Tableau

Tags

HR_Operations

Incident Aging Ticket Metrics
Created Dec 21, 2016 9:56 am
Status Certified

This report enables managers to query unresolved incident tickets by how long they have been open in the ITSM system (BMC Remedy ITSM). Managers can then use this report to identify tickets that need special attention, incident trending and incident closeout performance.   

Data Domain

Services

Community

Incident Management

Intended Audience

Division of IT Managers and staff who want to check on their aging tickets. This is not public facing. 

Reporting System

Tableau

Tags

IT, Services

Incident Summary by Portfolio - Enrollment and Student Experience
Created Aug 17, 2018 2:24 pm
Status Certified

Incident Summary organized by DIT Portfolio areas. Displays service and product support by volume. Measures include total number of incidents, day and times when service takes places with filter for schools and divisions.  

Data Domain

Services

Community

Change Management

Intended Audience

Service and Contract Management team members, Portfolio leads and customers

Reporting System

Tableau

Tags

IT, Services

Incident Summary by Portfolio - Enrollment and Student Experience
Created Aug 17, 2018 2:24 pm
Status Certified

Incident Summary organized by DIT Portfolio areas. Displays service and product support by volume. Measures include total number of incidents, day and times when service takes places with filter for schools and divisions.  

Data Domain

Services

Community

Change Management

Intended Audience

Service and Contract Management team members, Portfolio leads and customers

Reporting System

Tableau

Tags

IT, Services

Information Technology Service Center (ITSC) Volume Dashboard
Created Mar 16, 2017 8:57 pm
Status Certified

ITSC's monthly metrics that summarizes customer inquiries by various resources

Data Domain

Services

Community

Incident Management

Intended Audience

DIT, GW IT Schools (LSPs) and GW customers

Reporting System

Tableau

Tags

IT, Services

Information Technology Service Center (ITSC) Volume Dashboard
Created Mar 16, 2017 8:57 pm
Status Certified

ITSC's monthly metrics that summarizes customer inquiries by various resources

Data Domain

Services

Community

Incident Management

Intended Audience

DIT, GW IT Schools (LSPs) and GW customers

Reporting System

Tableau

Tags

IT, Services

Integrating Quality Dashboards
Created Nov 07, 2019 3:05 pm
Status Certified

These dashboards provide insight to how application measures correlate with academic performance for enrolled students in health sciences.

Data Domain

Academics

Community

School of Medicine and Health Sciences (SMHS)

Intended Audience

Program directors, department chairs, select administrative staff

Reporting System

Tableau

Interactive Grade Report
Created Mar 12, 2019 2:15 pm
Status Certified

This dashboard contains two tabs: Interactive Grade Report and Customize Comparisons Data includes course grades, which includes letter grade distribution, mean/median GPA grades, and course enrollment for each course. It is created to automate the process of sending out grade summary reports to each school in excel format every semester. The table data source for this report is based on: TBL_STUDENT_COURSE_REGIST_PDS.

Data Domain

Academics

Community

Office of Institutional Research and Planning

Intended Audience

School deans and chairs

Reporting System

Tableau

Tags

Academics, IR

Interactive Grade Report
Created Mar 12, 2019 2:15 pm
Status Certified

This dashboard contains two tabs: Interactive Grade Report and Customize Comparisons Data includes course grades, which includes letter grade distribution, mean/median GPA grades, and course enrollment for each course. It is created to automate the process of sending out grade summary reports to each school in excel format every semester. The table data source for this report is based on: TBL_STUDENT_COURSE_REGIST_PDS.

Data Domain

Academics

Community

Office of Institutional Research and Planning

Intended Audience

School deans and chairs

Reporting System

Tableau

Tags

Academics, IR

Internal Funding Analysis
Created Sep 10, 2020 11:54 am
Status Certified

This dashboard is designed to assist FDs in analyzing the internal funding. The dashboard includes three tabs. Internal Funding Analysis is the main dashboard where FDs can search for all PTAs related to the non closed or recently closed (closed within last 18 months) IXXS awards. And then user can click on each PTA to get to more detailed actual expenditures based on the period end GL dates entered. Actual Expenditures by GL Date sub dashboard could be accessed through a link from the PTA counts per organization chart. This report provides summary information per PTA by the period end GL date. This is to provide a high level picture on where the PTA stands in terms of expenditures.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS and FDs

Reporting System

Tableau

Tags

FINANCE

Internal Funding Analysis
Created Sep 10, 2020 11:54 am
Status Certified

This dashboard is designed to assist FDs in analyzing the internal funding. The dashboard includes three tabs. Internal Funding Analysis is the main dashboard where FDs can search for all PTAs related to the non closed or recently closed (closed within last 18 months) IXXS awards. And then user can click on each PTA to get to more detailed actual expenditures based on the period end GL dates entered. Actual Expenditures by GL Date sub dashboard could be accessed through a link from the PTA counts per organization chart. This report provides summary information per PTA by the period end GL date. This is to provide a high level picture on where the PTA stands in terms of expenditures.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS and FDs

Reporting System

Tableau

Tags

FINANCE

IPED Survey Report
Created Mar 06, 2018 3:52 pm
Status Certified

The Integrated Postsecondary Education Data System (IPEDS) is a system of interrelated surveys conducted annually by the National Center for Education Statistics (NCES), a part US Department of Education. Survey collect various Higher Education Institutions' data. This report summaries annual sponsored research activities according to IPEDS categories.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IPED Survey Report
Created Mar 06, 2018 3:52 pm
Status Certified

The Integrated Postsecondary Education Data System (IPEDS) is a system of interrelated surveys conducted annually by the National Center for Education Statistics (NCES), a part US Department of Education. Survey collect various Higher Education Institutions' data. This report summaries annual sponsored research activities according to IPEDS categories.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IT Capability Dashboard
Created Apr 02, 2019 12:03 pm
Status Certified

Purpose: IT Capability Maturity Program will enable all members of GW IT to understand what we do, how we do it and determine whether we are doing "it" well. This dashboard is the first step to visualizing the data. Impact: By understanding our IT capabilities, we are able to determine which IT capabilities are critical to services that deliver desired business outcomes by the Greater GW community.  With that understanding, we will be able to accurately invest human and fiscal resources in the maturity of those capabilities and measure the success of our investment. Value: IT Capability-based market research, analysis, and recommendations for future planning; Guidance on current and future roles per capability; Process improvement recommendations;  Technology lifecycle recommendations per process alignment and industry trends; and  Impact analysis of capability improvements on service delivery.

Data Domain

Services

Community

Information Technology

Intended Audience

GW Leadership Team, IT Directors, IT Managers, Teams

Reporting System

Tableau

Tags

IT, Services

Job Change Reason Dashboard
Created Sep 13, 2024 12:00 pm
Status Pending Data Certification

This Dashboard displays a report of employees by Job Change Reason Codes, it also contains a report of Job Change Reason Codes and Descriptions

Community

Data Governance Council

Intended Audience

HR Service Deliver Team, Compensation, Benefits, Student Employment and Faculty Personnel

Reporting System

Tableau

Job Change Reason Dashboard
Created May 19, 2020 11:09 am
Status Rejected

This Dashboard displays a report of employees by Job Change Reason Codes, it also contains a report of Job Change Reason Codes and Descriptions

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Service Deliver Team, Compensation, Benefits, Student Employment and Faculty Personnel

Reporting System

Tableau

Tags

Benefits, HR, Faculty

Job Families
Created Jan 21, 2021 3:28 pm
Status Certified

This is dashboard of all the Job Family and Job Subfamily Codes and descriptions along with the User who entered the codes and descriptions in the Banner tables and the date it was entered.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

Tags

HR

Job Labor Distribution
Created Mar 25, 2022 12:23 pm
Status Certified

This report provides a listing of Active Employees by org code and includes the job labor distribution amount.

Data Domain

Finance

Community

Financial Reporting - Job and Position

Intended Audience

Finance and Finance Directors

Reporting System

Tableau

Tags

Finance_Director, FINANCE, HR

Labor Cost Transfer
Created Jan 12, 2021 4:04 pm
Status Certified

This report is for GCAS to review the Grants related Labor Cost Transfers. The report includes earn amount measure with transaction and posting dates.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

Labor Effort
Created Jan 16, 2015 1:43 pm
Status Certified

Shows the percent of effort spent by an employee on a given award based on Banner HR Labor Distributions. The report includes distributions across all positions and banner indexes, including non-sponsored research activity. 

Data Domain

Research

Community

Office of the Vice President for Research (OVPR)

Intended Audience

OVPR, Principal Investigators, Finance Directors

Reporting System

Tableau

Tags

Research, OVPR

Leave of Absence Report
Created Jun 05, 2023 5:06 pm
Status Certified

This report tracks the employees FMLA (Family Medical Leave Act) leave information

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefit

Reporting System

Power BI

Tags

HR_Benefits

Leave of Absence Report
Created Jun 05, 2023 5:06 pm
Status Certified

This report tracks the employees FMLA (Family Medical Leave Act) leave information

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefit

Reporting System

Power BI

Tags

HR_Benefits

Leave PEAEMPL Report
Created May 16, 2023 10:14 am
Status Certified

This report lists employees status and leave of absence details with filtering of leave of absence reason code.

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Tags

HR_Benefits

Leave PEAEMPL Report
Created May 16, 2023 10:14 am
Status Certified

This report lists employees status and leave of absence details with filtering of leave of absence reason code.

Data Domain

Human Resources

Community

Benefits

Intended Audience

HR Benefits

Reporting System

Power BI

Tags

HR_Benefits

LOA Audit Dashboard
Created Aug 16, 2019 5:00 pm
Status Certified

This dashboard contains 4 sub dashboards, which will be used for LOA related audit.  PPL and SD2 paid is used to ensure that only employees approved for these benefits are being paid under these earn codes.  NY Employees with UNY Deductions dashboard is used to pay for NY disability program premiums. Unpaid leave dashboard is pulling all employees in Banner in leave without pay job status for multiple benefits audits. FSA DC During LOA dashboard is used to check for FSA dependent care deductions, which cannot be continued on LOA for longer than 30 days.  Benefits will maintain the list of GWID number of Employees who are on paid LOA.  The file, with the list of GWID numbers, needs to be in CSV format, and will be emailed to BIS provided box email.   This will load the attached CSV file to BIS Box folder.  This CSV file will then be used as one of the  data sources for this report.  The BDCA codes shown on report are limited to FFD, I50, SD1, SD2  and deduction codes from category codes 15 (Employee Life Insurance),25 (Employee Non-taxable Life), and 26 (Dependent Non-taxable Life).

Data Domain

Human Resources

Community

Benefits

Intended Audience

Benefits

Reporting System

Tableau

Tags

Benefits, HR

LOA Audit Dashboard
Created Aug 16, 2019 5:00 pm
Status Certified

This dashboard contains 4 sub dashboards, which will be used for LOA related audit.  PPL and SD2 paid is used to ensure that only employees approved for these benefits are being paid under these earn codes.  NY Employees with UNY Deductions dashboard is used to pay for NY disability program premiums. Unpaid leave dashboard is pulling all employees in Banner in leave without pay job status for multiple benefits audits. FSA DC During LOA dashboard is used to check for FSA dependent care deductions, which cannot be continued on LOA for longer than 30 days.  Benefits will maintain the list of GWID number of Employees who are on paid LOA.  The file, with the list of GWID numbers, needs to be in CSV format, and will be emailed to BIS provided box email.   This will load the attached CSV file to BIS Box folder.  This CSV file will then be used as one of the  data sources for this report.  The BDCA codes shown on report are limited to FFD, I50, SD1, SD2  and deduction codes from category codes 15 (Employee Life Insurance),25 (Employee Non-taxable Life), and 26 (Dependent Non-taxable Life).

Data Domain

Human Resources

Community

Benefits

Intended Audience

Benefits

Reporting System

Tableau

Tags

Benefits, HR

LOA Payroll Audit
Created Sep 11, 2019 12:02 pm
Status Certified

LOA Payroll Audit Dashboard is primarily used by Benefits team to audit various GW benefits and payrolls related to leave of absence. The Salary Increment report will pull salary increases by month and year, which will be used to audit life, AD&D and disability increase during a leave of absence. Payroll Report is used to review employee hours paid for multiple uses including FMLA eligibility and DC Sick and Safe Leave accruals.  Earn Code Report will pull payroll transactions for Earn Code SD2 (GW Paid STD) and PPL (Staff paid parental leave) to ensure they are being charged to account 51824.

Data Domain

Human Resources

Community

Benefits

Intended Audience

Benefits

Reporting System

Tableau

Tags

Benefits

Losing Benefits Eligibility
Created Apr 01, 2021 2:48 pm
Status Shared

This is a dashboard that provides a listing of employees who are no longer Benefit Eligible

Data Domain

Human Resources

Community

Benefits

Intended Audience

Human Resources

Reporting System

Tableau

Tags

Benefits, HR

Displaying 421 - 450 of 727