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 721 - 750 of 1192
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
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
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
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
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
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
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
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
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
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
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
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
This report tracks employees' FMLA (Family and Medical Leave Act) leave information and also tracks all other types of leave (personal, USERRA, administrative, etc.).
Data Domain
Human Resources
Community
Benefits
Intended Audience
HR Benefit
Reporting System
Power BI
This report tracks employees' FMLA (Family and Medical Leave Act) leave information and also tracks all other types of leave (personal, USERRA, administrative, etc.).
Data Domain
Human Resources
Community
Benefits
Intended Audience
HR Benefit
Reporting System
Power BI
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
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
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
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
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
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
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
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
This report provides a list of active managers; selecting a Manager will populate an additional table with a list of employees who report to the Manager.
Community
Human Resources
Intended Audience
HRIS, HR Business Partners
Reporting System
Tableau
This report provides a list of active managers; selecting a Manager will populate an additional table with a list of employees who report to the Manager.
Community
Human Resources
Intended Audience
HRIS, HR Business Partners
Reporting System
Tableau
This is a listing of Managers who have employees in the Job Classification of Executive Stream under their supervision
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
This is a listing of Managers who have employees in the Job Classification of Executive Stream under their supervision
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
This Dashboard is a listing of all Managers who only supervise/manage employees who are exempt.
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Tableau
This Dashboard is a listing of all Managers who only supervise/manage employees who are exempt.
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Tableau
Provides timely insight into manual registrations and report inefficiencies and implications.
Data Domain
Academics
Community
Office of the Registrar
Intended Audience
Registrar's Office
Reporting System
Tableau
Provides timely insight into manual registrations and report inefficiencies and implications.
Data Domain
Academics
Community
Office of the Registrar
Intended Audience
Registrar's Office
Reporting System
Tableau