Projects in Progress
Project (ServiceNow Link) | Description | Current Status | Comments |
|---|
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| Analytics Use & Adoption Reporting | Develop a set of reports/dashboards to track adoption & usage trends in services & tools provided by D&IM. First deliverables will be adoption of community of practice training and tools for Compass and the Student Data Warehouse. | In Progress | Student hired on 6/24, requirements gathering in progress |
| PowerBI Evaluation & Adoption | In Progress | ||
| Cybersecurity Awareness Training Compliance Data & Report | In Progress | ||
| Informatica IDMC Implementation & Training | 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 |
Project (ServiceNow Link)
DescriptionStart
Current Status
Comments
KFS Historical Chart of AccountsEnhancement of KFS data warehouse to track changes on the chart of accounts attributes. Develop reports to display historical attributes based on requirements.9/1/2015On HoldAwaiting implementation requirements from functional office.
KFS Pending EntriesNew addition to KFS data warehouse to include pending entries. Modify or develop reports based on requirements.9/1/2015On 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/2016On HoldAwaiting 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 HoldProject put on hold| . | In Progress |
Projects on Hold
| Website build complete, waiting on release date | |||
| Access Request Process (SN Project) | Design and implement a process for requesting and granting access to BI/Data Warehouse assets. 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 for Student Data |