Welcome to Business Intelligence Services' Content Catalog.

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

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

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

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

Report that contains GL Balance level of detail from the university data warehouse and made available for custom exporting.

CLICK HERE TO VIEW CONTENT

Report that contains GL Balance level of detail from the university data warehouse and made available for custom exporting.

CLICK HERE TO VIEW CONTENT

GL Balances Report is designed for the school and division financial directors.  It provides both the budget and actual cost information for all the Orgs the financial directors are overseeing.  

CLICK HERE TO VIEW CONTENT

GL Balances Report is designed for the school and division financial directors.  It provides both the budget and actual cost information for all the Orgs the financial directors are overseeing.  

CLICK HERE TO VIEW CONTENT

An interactive dashboard that shows General Ledger Balances activity over a selected period of time. Results will be limited to the accounts that a user has access to in EAS.

CLICK HERE TO VIEW CONTENT

An interactive dashboard that shows General Ledger Balances for ALL FY's activity over a selected period of time. Also, the dashboard has a Comparisons tab that displays the year over year percent change. Results will be limited to the accounts that a user has access to in EAS.

CLICK HERE TO VIEW CONTENT

An interactive dashboard that shows General Ledger Balances for ALL FY's activity over a selected period of time. Also, the dashboard has a Comparisons tab that displays the year over year percent change. Results will be limited to the accounts that a user has access to in EAS.

CLICK HERE TO VIEW CONTENT

General Ledger Report based on GL Subledger Fact Tables

CLICK HERE TO VIEW CONTENT

General Ledger Report based on GL Subledger Fact Tables

CLICK HERE TO VIEW CONTENT