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 391 - 420 of 696

Data Domain
Community
Tags
Status
Reporting System
HR Benefits: Build Your Own Report
Created Aug 03, 2023 1:17 pm
Status Certified

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to the hr benefits published model. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. This is part of the HR: Build Your Own Reports porfolio.

Community

Benefits

Intended Audience

HRIS, HR Benefits, Payroll, Compensation

Reporting System

Power BI

Tags

Benefits, HR_Compensation, HR_Payroll

HR Certification Report
Created Dec 09, 2022 9:51 am
Status Certified

Provides a listing of certifications by HR Reporting unit  for an employee based on activity dates selected. 

Community

Human Resources

Intended Audience

HR Business Partners, HRIS

Reporting System

Tableau

Tags

HR_Business_Partners

HR Compensation: Active Employee Listing at Specific Time
Created Jun 08, 2023 12:15 pm
Status Certified

This is a report of employees active as of date entered into the dashboard parameter. The columns are in a specific order to be used by HR Compensation reporting.

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

HR Compensation: Market and Salary Structure Alignment
Created Jun 08, 2023 3:34 pm
Status Certified

This report shows GW active budgeted positions by job family and classification with salary metrics and count of filled/unfilled jobs associated with each classification.

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Tableau

HR Compensation: Position Class by Position
Created May 31, 2023 4:23 pm
Status Certified

This report reflects all positions where 'position fy active ind' = Y and 'budget status code' = A and 'position status code' = A. Filtering by classification code, job family and position type are available

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Power BI

Tags

HR_Compensation

HR Compensation: Restoration Amounts Report
Created May 31, 2023 4:49 pm
Status Certified

This report lists all Earnings from Earn Type Codes RPF, RPB and BON with a filter for transaction begin and end date. In addition to the Detail report, there is a pivot formatted, Matrix report available.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Power BI

Tags

HR_Compensation

HR Federal WorkStudy Payroll Labor Distribution
Created Mar 22, 2023 9:56 am
Status Certified

Subset of Payroll Labor Distribution dataset that filters on employee class code 'W1', 'W4', 'W5'

Data Domain

Finance

Community

Financial Reporting

Intended Audience

Finance

Reporting System

Power BI

HR Nonpayroll Labor Distribution: Build Your Own Report
Created Jun 22, 2023 12:42 pm
Status Certified

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to non-payroll labor distribution. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation, HR Payroll, HRIS, HR Benefits

Reporting System

Power BI

Tags

HR_Compensation, HR_Benefits, HR_Payroll

HR Payroll Labor Distribution Faculty: Build Your Own Report
Created May 26, 2023 2:03 pm
Status Certified

This build your own report contains all of the necessary data to identify faculty employees and relevant human resources data points specifically relatedto payroll labor distribution. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

Data Domain

Human Resources

Community

Faculty Affairs

Intended Audience

Faculty Affairs, Faculty Personnel

Reporting System

Power BI

Tags

Faculty_Affairs, Faculty_Personnel

HR Payroll Labor Distribution: Build Your Own Report
Created Jun 12, 2023 4:59 pm
Status Certified

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to payroll labor distribution. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation, HRIS, HR Payroll, HR Benefits, HR Operations

Reporting System

Power BI

HR Payroll Reconciliation - Build Your Own Report
Created Dec 15, 2023 2:15 pm
Status Certified

HR Payroll Reconciliation - Build Your Own Report contains all the necessary fields to identify employees and data points related to payroll.  This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

Community

Payroll

Intended Audience

Finance

Reporting System

Power BI

HR Performance Rating Review Report
Created May 15, 2023 10:10 am
Status Certified

This report populates performance review details based on a review date range. Filters for Home Reporting Unit, Banner Home Org, GWID and review rating description are available.

Data Domain

Human Resources

Community

Human Resources

Intended Audience

HR Compensation

Reporting System

Power BI

Tags

HR_Compensation

HR Position Salary Faculty: Build Your Own Report
Created May 26, 2023 12:04 pm
Status Certified

This build your own report contains all of the necessary data to identify faculty employees and relevant human resources data points. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

Data Domain

Academics

Community

Faculty Affairs

Intended Audience

Faculty Affairs, Faculty Personnel

Reporting System

Power BI

Tags

Faculty_Affairs, Faculty_Personnel

HR Position Salary Faculty: Build Your Own Report
Created May 26, 2023 12:04 pm
Status Certified

This build your own report contains all of the necessary data to identify faculty employees and relevant human resources data points. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

Data Domain

Academics

Community

Faculty Affairs

Intended Audience

Faculty Affairs, Faculty Personnel

Reporting System

Power BI

Tags

Faculty_Affairs, Faculty_Personnel

HR Position Salary: Build Your Own Report
Created Jul 17, 2023 3:57 pm
Status Certified

This build your own report contains all of the necessary data to identify employees and relevant human resources data points related to HR position salary. This report allows user to select each field in order of appearance and to determine how data is filtered to create a personalized report.

Community

Human Resources

Intended Audience

HRIS, HR Compensation, HR Payroll, HR Benefits

Reporting System

Power BI

Tags

HR_Compensation, HR_Benefits, HR, HR_Payroll

HRDM Work Location
Created Jun 23, 2023 4:14 pm
Status Certified

This report identifies each employee by his/her Organization unit and job location by city and state. Filters for this report are Base Employee Class Code and HR Reporting Unit Description.

Data Domain

Human Resources

Community

Payroll

Intended Audience

HR Payroll

Reporting System

Power BI

I50 Analysis
Created Jun 05, 2018 10:58 am
Status Certified

This dashboard includes both the I50 Imputed Income Analysis Dashboard and the Salary Change Dashboard.  User can review the salary change for a specific employee by selecting the record on I50 Imputed Income Analysis Dashboard and follow the link to Salary Change report. The I50 Imputed Income Analysis dashboard provides the monthly I50 deduction along with several indicators that will help determine the need for I50 adjustment for the employee.   The Salary Change dashboard provides information on the salary changes for employees.   

Data Domain

Human Resources

Community

Benefits

Intended Audience

Benefits

Reporting System

Tableau

Tags

Benefits, Accounting, Human_Resources

I9 Purge PIDMs
Created Jul 19, 2024 10:14 am
Status Certified

I9 Purge PIDMs is a listing of all PIDMS for terminated employees who were hired within the last 50 months so that GW DOCs can be purged.

Community

Human Resources

Intended Audience

HR Operations

Reporting System

Tableau

Tags

HR_Operations

IDC Analysis
Created Aug 14, 2019 12:02 pm
Status Certified

The IDC Analysis Dashboard includes four tabs: TDC-MTDC-IDC by Schools, Indirect Cost Recovery, TDC MTDC IDC Details, and Sub MTDC Details. TDC-MTDC-IDC by Schools dashboard provides an overview of costs incurred within the selected GL Date range in different categories for each school. GW Funds and 3rd Party Gifts includes all the costs related to IXXS awards, while Direct/Indirect Cost from Sponsor includes all the costs from non IXXS awards. Total Cost is all the cost incurred during the GL Date ranges. The GW Funds & 3rd Party Gifts % is the percentage of total GW Funds & 3rd Party Gifts over the Total Cost. MTDC is MTDC (generic) that includes all non costshare expenses but removed 2 CFR 200 exclusions such as patient care, subcontracts in excess of $25,000, capital expenditures, tuition/stipends, and facility rental from direct cost etc. IDC is all the indirect cost incurred during the GL Date range. Residual Funds is cost charged to account 58952. Weighted Avg Recovery is the percentage of Total IDC Cost divided by the MTDC Cost. Indirect Cost Recovery Dashboard has three reports. One is Indirect Cost Recovery, which provides the Indirect Cost, MTDC, and the Percentage of Indirect Cost Recovery by Entity. The second one is Indirect Cost Recovery by IDC Category, which provides the IDC, MTDC, Percentage of Recovery by IDC Category and Entity. The last one is Indirect Cost Recovery - MTDC Analysis report. This report breaks down the expenditures in GCAS defined categories for each entity. TDC MTDC IDC Details and Sub MTDC Details have detail transactions for the summary report.

Data Domain

Finance

Community

Grants and Contracts Accounting Services (GCAS)

Intended Audience

GCAS

Reporting System

Tableau

Tags

FINANCE

IDC Check for CCAS
Created Dec 14, 2023 2:36 pm
Status Certified

IDC Check for CCAS

Community

Office of the Vice President for Research (OVPR)

Intended Audience

Research OVPR

Reporting System

Power BI

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

Displaying 391 - 420 of 696