Current BI/DW Projects

Projects in Progress

Project (ServiceNow Link)	Description	Current Status	Comments
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
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