UCI Data Central —
Data Warehouse & Business Intelligence
UCI Data Central is a vital resource providing integrated, clean, and timely data for reporting and analysis. This service empowers campus decision-makers and analysts to efficiently address business questions. Leveraging tools like IBM Cognos, Tableau and DWQuery, Data Central ensures that data is accessible, consistent, and well-documented.
Providing Student, HR, Finance and other data
Delivering reports, dashboards and queries in Cognos, Tableau and DWQuery
Serving over 2000 unique users
Integrating operational data to create analytical solutions
Quick links to reports and dashboards
Frequently used subject areas are listed below or go to our complete list of all data marts.
Compass Explorer
Compass Explorer student success analytics portal provides access to a comprehensive catalog of tools, dashboards, reports, and analytics to track and improve student outcomes. It is your front door to the variety of student success tools designed to help our students succeed in their studies and beyond.
UCI UCPath
UCPath is the University of California’s modernized payroll, benefits, human resources and academic personnel system for all UC employees. In UCPath Data Central, authorized users can view reports and dashboards on job, pay, benefits, budget, compensation, payroll, and leave information.
Kuali Financial System
The Kuali Financial System (KFS) is the Financial System for all UCI departments and all University funds are managed through this system. KFS Data Central provides reports and dashboards for general ledger, travel & entertainment, purchase orders, accounts payable, accounts receivable and budget.
Research Administration
The Office of Research provides central campus administrative tools in its mission to support and enhance the creative and scholarly activities of UCI faculty, leadership, and students. Research Administration Data Central provides reports and data analysis tools for contracts/grants, awards, proposals and other research administration information.
What can our Data Central team help you do?
Apply for Access to Tools & Services
Access to all data, reports, dashboards and tools is managed by KSAMS.
Request New or Updated Content
All requests for new data extracts, automated/direct data access, reports, or dashboards are requested using the data and report request form.
Open a Ticket
Need assistance? Please email the OIT Help Desk at oit@uci.edu or create an incident on the OIT Support Desk site.
IBM Cognos
IBM’s Cognos BI is a business intelligence suite offering reporting, analysis, scorecarding, and business monitoring tools. It extracts data from various sources, turning them into actionable insights through detailed reports, interactive dashboards, and visualizations.
DWQuery
DWQuery provides the ability for users to access financial, historical employee/payroll ledgers (pre-2019), research administration, and budgetary data for query and analysis. Users may query the data warehouse in detail, including the option to search and find unique transactions. In addition, search results may be exported to Excel for further data management and reporting.
Tableau
Tableau is intuitive, interactive, easy to learn, highly visual, and very efficient at creating dashboards and other graphical content. It is also a powerful tool for exploring data – experimenting with different data, different formatting and different presentations to determine what works best.
UCI Metadata
The Metadata tool is a data catalog for report, subject, and data definitions for data stored in UCI data warehouses. This website will serve as a platform for communication on approved and commonly agreed upon data definitions, and for disseminating definitions to campus users who are consuming data. Access to the website is managed with different KSAMS user access and roles.