Welcome to Business Intelligence Services' Content Catalog.

This report allows users to create custom reports using "Financial Aid Cost of Attendance" data set

CLICK HERE TO VIEW CONTENT

This report allows users to create custom reports using "Financial Aid Fund Year" data set

CLICK HERE TO VIEW CONTENT

This report provides visualization of financial aid funds for each period. It summarizes the offered amount, accepted amount and paid amount by Fund Type, Award Status, Fund Source, Fund Group, Fund Code and FA Student Type. Users can also drill down to Student Summary Dashboard. The summary compares Accepted amount vs Paid amount so users can find out if the paid amount is more than, equal to, or less than Accepted amount for each student.

CLICK HERE TO VIEW CONTENT

This report provides visualization of financial aid funds for each year. The grain is by year. It summarizes the offered amount, accepted amount and paid amount by Fund Type, Award Status, Fund Source, Fund Group, Fund Code and FA Student Type. Users can also drill down to Student Summary Dashboard. The summary includes a comparison by year measuring amount and student count for offered, accepted and paid.

CLICK HERE TO VIEW CONTENT

This report provides visualization of financial aid funds for each financial organization. Users can also drill down to a Financial Aid Detail Dashboard. The Comparisons tab includes the differences in the amount by year.

CLICK HERE TO VIEW CONTENT

Financial Aid: Student Summary - Build Your Own Report

CLICK HERE TO VIEW CONTENT

This dashboard contains 5 tabs: Respondent Demographics, Financial Knowledge, Student Loan Debt, Advice & Education, and Financial Fragility. Data included displays selected results from the Financial Literacy Survey. Data was collected in October and November 2017.

CLICK HERE TO VIEW CONTENT

List of all Financial Directors and their corresponding EAS orgs under their supervision.

CLICK HERE TO VIEW CONTENT

The First Destination Visualization/Dashboard gives students, parents, alumni, employers and others an in-depth view of the post-graduate success of the classes of 2014 and 2015. The interactive, virtual visualization offers a detailed look at the results of the annual First Destination survey, which highlights the activities of the most recent GW graduates during the first six months after commencement. This dashboard is also published on Tableau Public

CLICK HERE TO VIEW CONTENT

Identifies courses transferred in by first time freshman, including course names, numbers, source institution, and the GW course equivalent. 

CLICK HERE TO VIEW CONTENT

The FLSA Impact Based on Regular Rate is part of a suite of visualizations for the Employee Impact Dashboard and is a listing of all exempt employees (excluding Faculty) that have an annualized salary under the salary threshold for the new FLSA regulations, based on the employees' FTE. This report is only considering salary, and therefore there may be positions included that are exempt under another aspect of the law.

CLICK HERE TO VIEW CONTENT

This is a dashboard that shows employees whose positions went from FT to PT in the prior 60 days.

CLICK HERE TO VIEW CONTENT

FTE Auidut Report is part of a suite of vizulations for the Employee Impact Dashboard that will provide a list of Job records to determine hours per pay and hours per day are correct based on the FTE.

CLICK HERE TO VIEW CONTENT

Funding Source Profiles

CLICK HERE TO VIEW CONTENT

This report returns a list of PTAs with their budget and funding information by selecting an award status. PTAs are listed by project number, task number, award data, and contacts with measures including Budget Amount, Funding, and what the difference is in Budget Amount and Funding.

CLICK HERE TO VIEW CONTENT

This report is used for allocation of fundraising expenses for GW 990 purposes. This reports extracts fundraising expenses by the school recorded in fundraising orgs. Filters include organization, account type, fiscal year and accounting period. The table displays the accounting string, line description, account and measures the total amount for the selected fiscal year.

CLICK HERE TO VIEW CONTENT

For future dated terminations, select days to project as well as 'Benefit Eligible Employees' or 'Temporary and Student Employees' for report list.

CLICK HERE TO VIEW CONTENT

GCAS Report that includes award invoices with designated/undesignated projects.

CLICK HERE TO VIEW CONTENT

This report will track and analyze the number of cost transfers compard with federal grant expenditures for a specific GL to and from date. Includes project number, task number, award number, expenditure account, type and id, GL Date (Calendar) with the measurement of Actual Amount.

CLICK HERE TO VIEW CONTENT

There are two reports included here. The first, IDC by Funding Group, provides a table with funding group dollar amount ranges. The column measurements contain total amounts for Federal IDC versus total amounts for Non-Federal IDC as well as a Grand Total IDC column. The second report, Number of Awards by Funding Group, provides a table with funding group dollar amount ranges. The Federal, Non-Federal, and Grand Total columns contain measures of number of awards and total funding amount.

CLICK HERE TO VIEW CONTENT

The report lists awards based on the expenditure category and expenditure type. This report contains measures for actual amount, budget amount, and funding amount.

CLICK HERE TO VIEW CONTENT

This report includes filtering by billing group, award number and project number. Metrics include start date, end date, award number, award status, project number and task number to show how awards are assigned in Oracle.

CLICK HERE TO VIEW CONTENT

This report is used by GCAS team to view all the reporting groups and the awards they are assigned to in Oracle.

CLICK HERE TO VIEW CONTENT

Quarterly school/division business report stacked bar vis showing encumbrance, multiple, overspending, suspense, underspending and no issue as color bars. Filters include award status, discuss topics parameter, encumbrance parameter, award start date, zero spending indicator, award end date and award close date. Selecting an item on the bar will provide a link to the Award Detail Dashboard.

CLICK HERE TO VIEW CONTENT

This dashboard describes activity in the Gelman Library as captured by the various GWorld card readers in the building. Users will be able to see not only peak dates and times, but also be able to attribute the activity to students and employees. The data includes GWorld card activity for the current year and the previous two years.

CLICK HERE TO VIEW CONTENT

This is an FD Dashboard that contains four tabs: Net Revenues, Compensation, Other Expenditures, and Other Changes. Filter on as of Accounting Period comparing 6 fiscal years. Revenue categories are selected by dropdown to show dollars spend and percentage of growth.

CLICK HERE TO VIEW CONTENT

The 329 Account Detail report shows account detail by Accounting String and includes 'Actual' Balances and ‘Posted’ GL Line Status only.  Information is retrieved from the Data Source: General Ledger Line – Secured (FADM) provided by Tableau Server.  It retrieves GL Line information including Fiscal Year, Entered DR Amount, Entered CR Amount, Entered Amount Balance, GL Source Description, GL Category Description, Effective Date, GL Batch Name, GL Header Name, GL Header Description, GL Line Description and GL Line Number. The report can be filtered by Effective Date, Entity Code, EAS Org Code and Account Code.

CLICK HERE TO VIEW CONTENT

The GL Lines, AP and Invoice Dashboard is the first stop to explore GL329 data in an interactive way. The flexible filtering and dashboard actions allow you to drill down through accounts to find a particular Vendor or PO transaction. [To learn about additional available formats for General Ledger Lines reporting, please refer to the GL Report Catalog in Power BI.]

CLICK HERE TO VIEW CONTENT

Standalone report for GL329 Account Detail 

CLLICK HERE TO VIEW CONTENT

This build your own report contains all of the necessary columns to create custom reports using the GL 329 data points. This report allows users to select each field in order of appearance and to determine how data is filtered to create a personalized report. The report can then be bookmarked to save for future use. 

CLICK HERE TO VIEW CONTENT