Welcome to Business Intelligence Services' Content Catalog.

This report is utilized by the GCAS Compliance team to create metrics that are used to track and analyze the number of cost transfers compared with all grant expenditures for a specific time period.

CLICK HERE TO VIEW CONTENT

The All GW Department of Labor Stats dashboard is a count of all employee at GW during the date specified by Gender, as well as a count of all GW Faculty during the same period.

CLICK HERE TO VIEW CONTENT

This report provides a comprehensive overview of all user profiles within the Banner system.

CLICK HERE TO VIEW CONTENT

This dashboard provides analysis of annualized salaries for active job records with the following employee class code exclusions: F0-F9, FD, FC, (F%), SR, T1-T9 (T%), W1-W8 (W%), Z1-Z6 (Z%), R3, R4, XQ, L1-L9. The visualization is a box plot with box and whisker representing low whisker, low hinge, median, high hinge, high whisker for annualized salaries in each position classification. Measures of salary grade low, mid and high are displayed along side the annualized salaries. Hourly salaries are converted using salary - [rate value*2088] and salary grades of 0.0 are excluded.

CLICK HERE TO VIEW CONTENT

AP Payment Disbursement - Build Your Own Report

CLICK HERE TO VIEW CONTENT

AP Payment Report

CLICK HERE TO VIEW CONTENT

This dashboard shows the application trend and the enrollment trend in the last 6 academic years. 

A detailed view of purchase orders for Procurement.

CLICK HERE TO VIEW CONTENT

This dashboard provides details of approvers in Banner System

CLICK HERE TO VIEW CONTENT

This report will provide GCAS and OVPR with average payment time between AR invoice Date of the Pay Date per Sponsor and Per Award for a specified time range.  It will also provide the Average time and amount for the unpaid invoices.

CLICK HERE TO VIEW CONTENT

This is a weekly report generated for the Asset Management Committee to track university assets impacted by job changes.

CLICK HERE TO VIEW CONTENT

This is a report that is reviewed weekly by the Asset Management Committee to plan computer and other needs of hires and new hires at the university. 

CLICK HERE TO VIEW CONTENT

This is a weekly report generated for the Asset Management Committee to track university assets impacted by terminations.

CLICK HERE TO VIEW CONTENT

The Attainment & Cash report provides a summary view of fundraising performance by fiscal year. This dashboard allows members of Development and Alumni Relations (DAR) to quickly and easily view transactional data by a number of different metrics. Furthermore, this dashboard displays data either in the context of Total Attainment or Cash Received by the university on an annual basis. By presenting historical data in a graphical format, department leadership can use previous strategies and events to make better-informed future business decisions.

Attainment & Cash - Power BI Attainment and Cash - Power BI

This report identifies the current Max Effective date per Benefit or Deduction Code of all  active employees.

CLICK HERE TO VIEW CONTENT

List all GW Employees included under the Base Employee Class code F1, F2, F3, F4, F5 or F6, chosen by effective date.

CLICK HERE TO VIEW CONTENT

List all employees under Benefit or Deduction code FHI, FIM, or FIO considering the last effective date as of today (All future effective dates are not considered). Shows the Benefit Status and Effective dates.

CLICK HERE TO VIEW CONTENT

This yearly audit report lists all employees under Benefit or Deduction code FHI, FIM, or FIO. The Max Effective Date for this report is defined by Employee, Benefit or Deduction, and Reference Number. The result can be filtered by the value of Max Effective Date, including Nulls.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIM considering the last effective date as of the date the reports runs (All future effective dates are not considered). Shows the total Earned and the Pay calendar sequence. 

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIT. Filters for this report Are Base Employee Class Code and Benefit Status. 

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIO. Filters for this report Are Base Employee Class Code, Benefit Status, and Citizen Type.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIT. Filters for this report Are Base Employee Class Code and Benefit Status. 

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code GFT and no filters.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code FIT. Filters for this report Are Base Employee Class Code, Reference Number, Benefit Status, and I9 Status. While very similar to the FIT with Reference Field - No Treaty Report, the detail changes for the purpose.

CLICK HERE TO VIEW CONTENT

List of all employees under Benefit or Deduction code PK1, PRK. Filters for this report Are Base Employee Class Code and Benefit Status. 

CLICK HERE TO VIEW CONTENT

List all employees under every Benefit or Deduction code where the effective date is greater than the one the user chooses. These benefit or deduction codes are SNP, SMP, SMS, SMT, FMP, FSP, FST, SNS, and SNT. The user could see each one independently or in groups.

CLICK HERE TO VIEW CONTENT

List of all employees includeded only in Benefit or Deduction Code UCA, UCO, UCT, UDC, UDE, UFL, UGA, UIL, ULA, UMA, UMD, UMI, UMN, UNC, or UNJ

CLICK HERE TO VIEW CONTENT

List Employees under the Benefit or deduction codes PCT and UCT, includes only Active Employees where the Latest Effective Date = Max Effective Date as of Today.

CLICK HERE TO VIEW CONTENT

Listing of employees under Benefit or Deduction Code equal to UWY

CLICK HERE TO VIEW CONTENT

This is an HR Payroll report that shows an audit of work locations for selected base employee class codes where benefit or deduction code does not contain 'UPL', employment status is active, benefit deduction type code is 06, and benefit status is E or A.

CLICK HERE TO VIEW CONTENT