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 696
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
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
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 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
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
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
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 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 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
The dashboard displays information relating to the processing of manual registrations requested via Registration Transaction Forms. It contains 8 tabs. 1. Registration activity that shows percentage of students registered by college. 2. Registration count that shows count of student registered by a) College, b) Level and c) Degree. 3. Registration by semester that includes visualizations by term as well as semester. 4. Registration by activity date plus a comparison by month. 5. Registration by statu date (RSTS Date) plus a comparison by month. 6. Registration added by , that identifies the person who added the information based on Banner IDs, also a visualization by group. 7. Registration added by known user that shows information included but not identified by a Banned ID. Plus a visualization by group. 8. Days(RSTS-Activity) that shows an area chart by day of registration status date.
Data Domain
Academics
Community
Office of the Registrar
Intended Audience
Office of Registrar
Reporting System
Tableau
This dashboard provides details on placement scores for MATH and CHEM. Placement Test Year includes 2024 and later.
Community
Office of the Registrar
Intended Audience
Academics
Reporting System
Tableau
Provides insights into the number of Medical Residents, presenting demographic insights including age, gender, race/ethnicity, and years of service.
Community
Human Resources
Intended Audience
HR Analytics for President, Provost, EVP/CFO
Reporting System
Tableau
This report displays all benefit eligible staff with supervisor and class codes.
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
This report displays all benefit eligible staff with supervisor and class codes.
Data Domain
Human Resources
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
Merit File is a listing of Benefit Eligible Employees who have receivied Merit and some job/position information
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
Merit File is a listing of Benefit Eligible Employees who have receivied Merit and some job/position information
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
Merit Report is a file of Active Benefit Eligible employees who are eligible for merit and some job/position information
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
Merit Report is a file of Active Benefit Eligible employees who are eligible for merit and some job/position information
Community
Human Resources
Intended Audience
HR Compensation
Reporting System
Power BI
This Tableau dashboard provides course information by student, including the option to filter to courses based on whether they are a core or prerequisite for an undergraduate in one of GWSPH's three majors. Also includes options to filter to students with low course grades, and view registration counts of majors, concentrations, and minors by term.
Community
Milken Institute School of Public Health (GWSPH)
Intended Audience
GWSPH Undergraduate Dean and Advisors
Reporting System
Tableau