Welcome to Business Intelligence Services' Content Catalog.

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.

CLICK HERE TO VIEW CONTENT

IDC Check for CCAS

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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.

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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. 

CLICK HERE TO VIEW CONTENT

This report tracks employees' FMLA (Family and Medical Leave Act) leave information and also tracks all other types of leave (personal, USERRA, administrative, etc.).

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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).

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

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

CLICK HERE TO VIEW CONTENT

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.

CLICK HERE TO VIEW CONTENT

This is a listing of Managers who have employees in the Job Classification of Executive Stream under their supervision

CLICK HERE TO VIEW CONTENT

This Dashboard is a listing of all Managers who only supervise/manage employees who are exempt.

CLICK HERE TO VIEW CONTENT

Provides timely insight into manual registrations and report inefficiencies and implications.

CLICK HERE TO VIEW CONTENT

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. 

CLICK HERE TO VIEW CONTENT

This dashboard provides details on placement scores for MATH and CHEM.  Placement Test Year includes 2024 and later.

CLICK HERE TO VIEW CONTENT

Provides insights into the number of Medical Residents, presenting demographic insights including age, gender, race/ethnicity, and years of service.

CLICK HERE TO VIEW CONTENT

This report displays all benefit eligible staff with supervisor and class codes.

CLICK HERE TO VIEW CONTENT

Merit File is a listing of Benefit Eligible Employees who have receivied Merit and some job/position information

CLICK HERE TO VIEW CONTENT

Merit Report is a file of Active Benefit Eligible employees who are eligible for merit and some job/position information

CLICK HERE TO VIEW CONTENT

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.  

CLICK HERE TO VIEW CONTENT

This dashboard displays the total number of unreported grades by Term, College, Department, Subject, Course Number, and Course Reference Number (CRN). It excludes: Course College = 'School of Med Sc' AND Section = '50' and Sections 'GMU', 'GM1' and CRN must have gradable Indicator = 'Y'

CLICK HERE TO VIEW CONTENT

This report is for GCAS to make sure all the non-LOC cost reimbursable awards (CCNS) have been reviewed and invoiced as expected.  The report will show all the CCNS awards that have funding amount greater than the billed amount and haven't been billed over 90 days.  The report will also include awards started more than 90 days but have not been invoiced.  It only includes awards with ACTIVE and ON_HOLD status .

CLICK HERE TO VIEW CONTENT

Missing Reporting Units is a dashboard that displays missing HR Reporting Units by Organization Code for Timesheet and Position Home Organizations

CLICK HERE TO VIEW CONTENT