Overview
UCI DSS is responsible for designing and delivering solutions to business problems using a combination of operational data stores (ODS), campus data warehouse (DWH), Cognos Reports, Legacy Reports (BLISS), and document imaging (Electronic Document Library (EDL) and eDocs/Filenet)
We provide the following services to cater to the information and reporting needs of various departments at UCI:
- Establish and maintain single source of true data (in ODS and DWH) for reporting and analysis.
- Assure that data is documented, clean, consistent, and timely.
- The Campus Data Warehouse provides a central repository for many areas of administrative data including Financials, Personnel/Payroll, Billing and Accounts Receivable, Budget, Facilities, Research, Contracts/Grants and Security.
- Build and maintain standard reports & dash boards to cater to enterprise and department’s needs.
- Provide platform and training for self-service reporting and analytics, supporting staff report development.
- Data education, appropriate use, and training.
- Access.
The Campus Business Intelligence utilizes IBM Cognos tools to deliver Professional Dashboards, Standard Reports, Cubes for doing Analysis and AdHoc Query capabilities.
We are in a major transition phase where the legacy data warehouse built in 1996 and the legacy reporting tool BLISS, are being replaced with a new campus data warehouse and reporting tool (IBM Cognos). This transition started with the Kuali FS go-live in July, 2014 and we expect to be fully transitioned to the new campus data warehouse and Cognos in 2017, with the new Student Information System and UCPath go-lives.
| Section | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Section | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Available Information or Data
Subject Area or System (click to see list of reports) | Reporting Tool | How to Access | Load Frequency | Last Load Date/Time | Data Dictionary | Whom to contact for help | Subject Availability | Status |
|---|---|---|---|---|---|---|---|---|
| Kuali Financial System | Cognos | Portal Decision Support | Daily | 24/7 | ||||
| Kuali Financial Documents | eDocs | |||||||
| Kuali Budget System | Cognos | Portal Decision Support | ||||||
| Kuali Research Administration | Cognos | Portal Decision Support | ||||||
| Student Enrollment | Cognos | Daily | ||||||
| Student Analytics | Cognos | |||||||
| University Advancement | Cognos | UCI's IBM Cognos Connection and email delivery | Daily | Julie George | ||||
| UCI Medical Center | Cognos | UCI's IBM Cognos Connection | Daily | Guna Raman | ||||
| Facilities Management | Cognos | Zot Portal, Tririga and UCI Cognos Dashboard | Monthly and on demand | Aileen Lin | ||||
| Research Proposal/Award Data | BLISS | Legacy Data Warehouse (BLISS) | ||||||
| Employee / HR | BLISS, eDocs, Filenet |
| Daily | |||||
| Payroll Expense | BLISS | Monthly | ||||||
| Payroll/PPS Reports | EDL/Mobius | EDL | ||||||
| Space | BLISS | Legacy Data Warehouse (BLISS) | Yearly | |||||
| Cognos Portal | Cognos | |||||||
| EDL Reports / Images | Mobius | |||||||
| eDocs Images | Filenet |
Project
- Project Timelines / Milestones
- Status - What are we working on? Scorecards.
- Strategic Plan (Current state, Future State/Vision, Roadmap, Costs)
- Presentations
More Information
- Data Warehouse/BI Leadership Meetings
- UCI Decision Support Organization
- UCI Data Management and Governance Project
- UCI Data Inventory
- UCI Reporting Assessment Report Inventory.xlsx (Nice Template used for SIS by Ellucian)
- Additional Resources
...
Home Page: http://www.oit.uci.edu/bi-dss
ZotPortal Channel: https://portal.uci.edu/uPortal/f/decsupport/normal/render.uP
/wiki/spaces/adcom/pages/68012274
Child Pages
| Child pages (Children Display) |
|---|