Business Intelligence



Bi Chart 2

Standard Reports


Business Intelligence (BI):

Business Intelligence (BI) provides a business view of the right information at the right time, place and form.  Continuously evolving to be the premier information provider to the UD community by providing the intelligence they need to make strategic business decisions.  BI interacts with University constituents to develop a clear understanding of business requirements to facilitate a reliable, comprehensive and consistent data source to support operational, tactical and strategic reporting and analysis needs.  We seek to understand the data requirements of the wide array of University decision-makers.  BI provides the transfer of knowledge on business rules and technical skills creating self-sufficient clients better preparing them to perform daily operations with data that will be accessible to any person within the UD community with a legitimate business need.  BI builds multiple platforms for access to information and knowledge to users including active online reports, dashboards, and data searching and reporting to empower users to meet their information needs.  BI supports business decisions by analyzing and modeling historical data predicting trends in a meaningful way enabling informed decision making.

What is Business Intelligence (BI)?

Business Intelligence (BI) describes the technologies and processes that transform raw data into meaningful information used to analyze and predict the university’s performance.  Business Intelligence (BI) refers to methods and tools used to transform and analyze data in support of data-driven decision-making. The University of Delaware uses IBM Cognos as our enterprise warehouse business application. IBM Cognos is used for data analytics and delivers data visualization through dashboards and reports.  

The University of Delaware Enterprise Warehouse (UDEW) is maintained by Business Intelligence (BI). The university data warehouse is an Oracle-based database that is comprised of transaction data extracted from PeopleSoft Financials, Human Resources and UDSIS.  Additional sources of data are periodically added to the warehouse to meet new analytical needs.  BI is responsible for modeling and making revisions to data marts. Consulting with the campus community to facilitate the development of reports from the various data marts.  BI responds to requests in support of Revenue-Based Budgeting (RBB) reporting and BI IBM Congos Training.

The University of Delaware uses IBM Cognos version 11.0.12 which includes the capabilities of authoring, viewing and modifying reports and creating interactive data visualization.


BI – IBM Cognos Data Marts

IBM Cognos Data Marts have security called Cognos Roles.  Access to the data marts listed below is based on the Cognos Roles. Click on Getting Started with IBM Cognos for more information on IBM Cognos Roles.

Financial Data Marts

Archived Web JVs

JV Active Web Form

JV Web Form

New JV Web Active Web Form

New JV Web Form

Project Closeout

UD Financial Data Mart – contains all financial data including: Awards, Balances, Contracts, Projects, Proposals, Payables, Purchasing and Trans Detail

Transmittal Web Form

Human Resources Data Marts

HR Census Data Mart

HR Daily Extract – daily snapshot of HR data


HR Official and Daily Extract

HR Official Extract – snapshot of HR data usually taken in the Fall, Spring and Summer.

Student Data Marts

Admissions Data Mart – contains graduate and undergraduate admissions data since Fall 2007

Degree Data Mart – contains all conferred degrees since Fall 1971

Persisters Data Mart

Financial Aid Data Mart

Plan to Department – Academic Plans with the Academic Program, Academic Org, Dept ID, and CIP codes

SOC Data Mart (Schedule of Class) – contains class data since Fall 1971

Student Enrollment Data Mart – contains all of a student’s academic data per a given semester since Fall 2007

Student Transfer Credits Data Mart

UDSIS Online Official Extract – UNDUPLICATED HEADCOUNTS – snapshot of online enrollment taken on the first day, official (10th) day and last day of classes.

UDSIS Online Term Extract – UNDUPLICATED HEADCOUNTS – daily snapshot of online enrollment for the current semester

UDSIS Official Extract – UNDUPLICATED HEADCOUNTS – snapshot of enrollment data taken on the first day, official (10th) day and last day of classes.

UDSIS Term Extract – UNDUPLICATED HEADCOUNTS – daily snapshot of enrollment data for the current semester