Projects in Progress
Project (ServiceNow Link) | Description | Current Status | Comments |
|---|---|---|---|
| Implement the UCPath CDW (Common Data Warehouse), including UCI customizations. Import Informatica mappings delivered from UCLA. Maintain UCI's implementation of the DDODS (data dissemination operational data store). Design SQL Views to be used by campus Tier-N systems using the Enterprise Service Bus (ESB). Develop reports based on campus and UCIMC requirements. | In Progress | ||
| /wiki/spaces/OITOR/pages/15051292 | Phase I of project (report remediation): Develop ODS and replace legacy reports with new reports in Cognos Phase II of project (new reports): Develop ODS and/or dimensional data warehouse and reports based on requirements | In Progress | |
| /wiki/spaces/adcom/pages/68014905 | A number of groups across the campus create and utilize student data and process it in different ways for different purposes. This project is to create and execute a road map for a student data warehouse that will help organize and make student data available in a more efficient and useful manner, and to a larger audience than it is available to today. | In Progress | Daily Admissions data mart design and ETL development complete. Planned production roll-out in early June. Grad Admissions (Slate) operational data store (ODS) development is in progress. Working with executive data warehouse governance committee to develop a road map and resource plan for other subject areas. |
| Data Warehouse Website Redesign | As BLISS queries are decommissioned, the Data Warehouse team will need to re-purpose the datawarehouse.uci.edu URL for all things data warehouse related. This will be a one-stop site for anything related to Decision Support. It will include links to DWQuery as well as Cognos reports and dashboards. It will also include information on how to get access to the data that exists in the data warehouse. | Planning | |
| Metadata Project (SN Project) | Develop a solution to manage and store data warehouse metadata, along with reports/queries cross-reference look-up. Modify all existing DWQueries and Cognos reports to provide 'pop-up' window of data definitions. | In Progress | Solution will be developed in-house. Initial POC is in progress. |
| KFS Workflow | Develop a KFS Workflow data mart, and any reports needed per requirements. | In Progress | ETL development is in testing, and the team is optimizing ETL for performance. |
| Motio CI | Adaption of Motio CI for Cognos 11 and campus socialization | In Progress | Transitioning OIT BI team |
| Migration of BLISS to DWQuery | Parent project for all efforts related to migrating BLISS to DWQuery. In an effort to decommission of the outdated code used by BLISS, migrate all BLISS queries to the DWQuery tool. This includes General Ledger, Purchasing, Payroll and other queries as needed. Convert any access controls from SAMS to KSAMS. | In Progress | UCPath-critical queries have been developed and are in UAT. |
| Senturus Proof of Concept (SN Project) | Senturus is a connector that allows Tableau to connect to Cognos frameworks and/or reports as its data source. If Senturus is effective, it will help us overcome some of the principal impediments to Tableau adoption -- controlled access to data, managing security, and managing back-end data complexity. | In Progress | Testing in progress -- nearing completion |
| Data Virtualization Proof of Concept (SN Project) | Plan out and build a proof-of-concept of connecting extraneous data sets using data virtualization. Partner with another non-OIT department, and possibly one internal OIT team. | In Progress | Working with TIBCO on POC. Currently in the process of planning out POC and setting up environment. |
| Access Request Process (SN Project) | Design and implement a process for requesting and granting Decision Support access. This is a process for any centrally controlled reports or central access, direct database access, or any access to restricted or sensitive data. This project will also define a process for using KSAMS to grant access to Cognos reports, and grant direct access to the data warehouse for individuals or other systems. In addition, this project will develop end-user documentation on the access request process. | In Progress | Drafted of process documented, needs vetting from data stewards, security team and stakeholders |