| | |
|---|
| Analytics Use & Adoption Reporting |
| /wiki/spaces/adcom/pages/68026129 (ServiceNow) | Accounting is requesting the ability to run specific Cognos reports in batch mode and burst the output to a secure location where campus fiscal officers can review their reports. For a later phase, Accounting wants fiscal officers to be able to annotate and/or sign-off on the burst reports. | 3/1/2016 | Ready for deployment | |
| 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 | In Testing | Data model design and ETL complete, changes will be implemented in Fall 2016 |
| KFS Pending Entries | New addition to KFS data warehouse to include pending entries. Modify or develop reports based on requirements. | 9/1/2015 | In Testing | Data model design and ETL complete, changes will be implemented in Fall 2016 |
| KFS Purchasing/Accounts Payable | New addition to KFS data warehouse to include purchasing and accounts payable documents, attributes and transactions. Develop reports based on requirements. | 9/1/2015 | In Progress | Requirements gathering and functional specification development in progress. |
| 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 | In Progress | Requirements gathering and functional specification development in progress. Data model design in progress. |
| 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/ |
68037251Develop an ad-hoc prompting interface for Cognos that provides more usability and flexibility than the current tool, which is simpler to use and guides the user more than Workspace Advanced. This interface should address immediate needs for KFS GL ad-hoc prompting, and also be generalizable for other KFS data sets and other subject areas, including HR/Payroll (UCPath) and student (Banner). | 4/1/2016 | In Progress | Proof of concept in development using Data Insight | UCPath | 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 | |
| Re-design process for loading Administrative LDAP | As the first phase of the Internal Directory decommission, re-design the ETL process to load tables used to load employees, guests, and group accounts into the Administrative LDAP. Maintain and track historical changes. | | In Progress | |
| Office of Research | 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 | 3/2/2015 | In Progress | Phase I is complete. Phase II requirements gathering is in progress. |
| Student Information Systems | | | In Progress | |
Implement metadata maintenance using Data Cookbook (ServiceNow) | | | | | 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 |
|
| 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. | In Progress | 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 |