Welcome to Business Intelligence Services' Content Catalog.

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

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

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

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

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

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

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

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

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

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

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