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 | ||
| Research Administration Reporting & Data Warehouse | 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 | Hiring a student developer. Prototype completed using Cascade. |
| SQL Server Upgrade | Upgrade primary data warehouse SQL from 2008 R2 to 2016 before June 2019. | In Progress | Development server migration complete. Compass is now on production SQL Server. Production roll-out for KFS, KR and UCPath planned for the weekend of 5/24/19. |
| Database Planning and Proposal for new Architecture (SN Project) | Short and long-term planning for database technologies for data warehouse. | In Progress | Met with AWS and Snowflake to explore other solutions. Will work with hardware and DB teams to come up with a short-term plan to handle additional capacity. Will most likely do a POC on cloud technology later this year to determine long-term strategy. |
| Metadata 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 | |||
| Migration of BLISS to DWQuery | |||
| WebPan Archive Decoupling from WebEDB/PPS | The Payroll office and the campus needs to continue viewing archived Web Pans after PPS is decommissioned. Currently, WebPanArchive is tightly coupled with the PPS web application for the user interface, authentication and authorization. Development work will need to be done to decouple the application from PPS, and switch authorization from SAMS/PPS to KSAMS. | In Testing | Development is done and we are working with the Payroll office to begin user acceptance testing |
| 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) |
Projects on Hold
Project (ServiceNow Link) | Description | Start | Current Status | Comments |
|---|---|---|---|---|
| KFS Historical Chart of Accounts | Enhancement of KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements. | 9/1/2015 | On Hold | Awaiting implementation requirements from functional office. |
| KFS Pending Entries | New addition to KFS data warehouse to include pending entries. Modify or develop reports based on requirements. | 9/1/2015 | On Hold | |
| KFS Kuali Budget (KBM) | New addition to KFS data warehouse to include Kuali Budget Module (KBM) documents, attributes and transactions. Develop reports based on requirements. | 5/1/2016 | On Hold | Awaiting resource availability |
| /wiki/spaces/SIS/pages/21103609 (SIS) | Work with Ellucian to implement Banner ODS, EDW and reporting for SIS and related student systems. This project also includes integration of historical student data into the ODS, as well as Canvas, DegreeWorks, GradAid and other student systems as needed. | On Hold | Project put on hold |