Welcome to Business Intelligence Services' Content Catalog.

This dashboard allows users to view courses taught by instructors for every term with a measure of count of courses by instructor.  

CLICK HERE TO VIEW CONTENT

CPS Metrics is a collection of visualizations that presents the sum of credits hours and student counts by college group for one specific campus. There are three charts accompanied by their corresponding data table. Each chart includes 9 colleges in different colors, representing the amount either of the unique count of students registered by course or, the sum of credit hours for the same group of students.   By default, the information corresponds to the Fall semester but the user can also choose to see the full academic year. Campuses have been grouped by location excluding Foggy Bottom making the user to chose from Alexandria, Arlington,  Hampton, and Virginia.

CLICK HERE FOR CONTENT

The Cross-Listed Courses Dashboard presents the relationship between Courses that are cross-listed by college and subject area. While it is possible to compare multiple terms the most efficient way to use the report is by filtering first the desired data. Available filters are Term Code, Cross List Group, Subject, CRN, Course Level, Course College, Course Name, and Primary Instructor.  There are additional data that can be seen by downloading this information to excel, like the Primary instructor's email address and begin and end time for a course. 

CLICK HERE TO VIEW CONTENT

This report is used by HR Benefits to display current deductions with filtering for deduction code, pays over factor, deduction status among others.

CLICK HERE TO VIEW CONTENT

Overview of total current employee headcount broken down by type of employee.

CLICK PRESIDENT, PROVOST, EVP/CFO OR DEANS AND VPs TO VIEW CONTENT

Encumbrance Amounts broken down by school and FD Group

CLICK HERE TO VIEW CONTENT

List Employees by their current hire date. Filters for this report are "Employee Status usually set as "A" (Active) or "T" (Temporal), Base Employee class code, and the desired range of current hire date.

CLICK HERE TO VIEW CONTENT

List Employees by their current hire date, includes complete W4 address .

CLICK HERE TO VIEW CONTENT

This report includes all purchase orders approved the previous 5 days (with a default to the previous day). It is used by Procurement managers to track workflow progress. Measures include quantity, requisition line value and purchase order amount.

CLICK HERE TO VIEW CONTENT

This dashboard is a count of employees in all DAR units across the University by a date specified by the user. 

CLICK HERE TO VIEW CONTENT

Data Entry Audit Between PEAEMPL Home Org and NBAJOBS Org Code is a report that lists employees whose Primary job PEAEMPL Home Org is different than the NBAJOBS Org code.

CLICK HERE TO VIEW CONTENT

The DC Department of Labor Stats is a dashboard that provides counts of GW employees for DC locations and a count of DC employees terminated and hired during the period specified for the Department of Labor.

CLICK HERE TO VIEW CONTENT

This report lists for auditing purposes DC Paid Family Leave Employee.

CLICK HERE TO VIEW CONTENT

This report estimates accrual of leave for DC Sick and Safe law based on an unsigned draft of GW's internal unpublished memoranda on the policy. Accruals are calculated based off of the current job record as of the run date of the report and as such should not be considered official. This is for rough estimation purposes only and should not be shared external to HR at this time.

CLICK HERE TO VIEW CONTENT

This report will allow user to search for the PABs using Clearing Accounts Non Labor Resource. The report filters include creation date, PAB name, entity, organization name, expense type, project, task and award. The creation date and created by fields are the primary sort with the measure being the amount of the PAB.

CLICK HERE TO VIEW CONTENT

The Dean's Dashboard is a collection of visualizations that provide key insights into the following areas: Admissions Undergraduate Student Tuition Allocation GL Revenues and Expenses Missing Grades Employee Profile     Each user will have a different view of the dashboard depending on his/her college affiliation or position at the University. If the user is in a role that can see across colleges, "All (10 Colleges)" will appear on the dashboard header. If the user is affiliated with a specific college, the college's name will appear on the header. The schools included are: Columbian College of Arts & Science College of Professional Studies Elliott School of International Affairs Graduate School of Education and Human Development Law School Milken Institute School of Public Health School of Business School of Engineering & Applied Sciences School of Medicine & Health Sciences School of Nursing   Data for the Dean's Dashboard is collected from GW's enterprise systems and is as of COB of the previous day.

CLICK HERE TO VIEW CONTENT

To begin, indicate a college at the Welcome page of the Dean's Dashboard. This Admissions tab provides a summary of all ten college groups by graduate and undergraduate. It displays combined Summer and Fall admission counts between January and September. In October to December, it displays Spring admission counts. It shows 4 metrics: Application Count as of the current date, Application Count as of the same day in the previous year, the Increase or Decrease between those counts, and Total Applications in the previous year. These metrics are shown for 4 admission statuses, Applied, Admitted, Coming and Denied.   IMPORTANT NOTE: The Law school and the Medical school have different admissions systems. These systems only move admitted students to banner so only admitted students show on the dashboard and not all the applicants.

CLICK HERE TO VIEW CONTENT

This is part of the Dean's Dashboard. It provides a summary view of fundraising metrics by fiscal year. This dashboard further differentiates between Total Attainment (commitments and outright gifts) and Cash Received (outright gifts and payments on existing commitments). Additionally, this dashboard displays summary total for different allocation uses within the current fiscal year. Note: The advancement dashboard has been designed to report on Fundraising performance. It is important to note that there are two areas where our understanding of the numbers may differ from Finance’s Fund Raising reporting.  We “freeze” our data on a yearly basis to maintain a stable reporting environment for fundraising performance. If an open pledge from 2015 is reduced or canceled in 2016, we do not go back an update our historical fundraising totals. Finance may not report on full transaction totals for specific transaction types. They may produce a discounted value for pledges and bequest intentions based on accounting rules.

CLICK HERE TO VIEW CONTENT

This is part of the Dean's Dashboard. This tab provides a count of active employees in the College and its composition (tenure, full-time status and location). It also provides the amount spent for Overtime pay in the College for the current and previous fiscal years.

CLICK HERE TO VIEW CONTENT

This part of the Dean's Dashboard shows the income statement items for the 10 Colleges: Actuals vs Annual Budget for the current and previous Fiscal Years for Revenues, the Top 3 Compensation Expenditures, and non-compensation expenditures Notes: Additional Security: To be able to view GL Balances, access to accounting strings in EAS must be granted. For those who are able to see across colleges: The Dean’s Dashboard only includes revenues and expenses for the 10 GW Colleges.

CLICK HERE TO VIEW CONTENT

The Missing Grades tab of the Dean's Dashboard shows the top 10 departments in the College with the highest number of unsubmitted grades for the last 7 terms.

CLICK HERE TO VIEW CONTENT

The Undergraduate Tuition Allocation tab (part of the Dean's Dashboard) is a projection of revenues that the College will make based on the the cost per credit (determined by the Budget Office) and the number of credits taken from Undergraduate courses taught by the College. It also compares the number of credits in the current fiscal year with the number of credits in the previous fiscal year by Department and by Budget Campus.

CLICK HERE TO VIEW CONTENT

This report lists employees with a selected "benefit or deduction code" filtered by history date range.

CLICK HERE TO VIEW CONTENT

This dashboard provides user activity, to determine whether a user is eligible for a DegreeMAP account, and to ensure user access is removed when no longer employed.

CLICK HERE TO VIEW CONTENT

This is a tableau public dashboard. It contains ten years of data on the number of degrees awarded by George Washington University. The data matches the official numbers reported to IPEDS.

CLICK HERE TO VIEW CONTENT

This report provides a list of basic information for employees: Name, Job Title (primary job), Department, Email and Work Phone Number for primary job only.

CLICK HERE TO VIEW CONTENT

This report provides a listing of employees by Position/Building location. The ability to filter by a specific building or street address is available.

CLICK HERE TO VIEW CONTENT

This report is a list of active employees and their home addresses as well as bio demo details such as birth date.

CLICK HERE TO VIEW CONTENT

This is a report of all employees identified as on-site personnel for purposes of GWorld and COVID testing.

CLICK HERE TO VIEW CONTENT

This report provides dataset associated with detail code with Max Effective date for users to create their custom reports

CLICK HERE TO VIEW CONTENT