Versions Compared

Version Old Version 33 New Version Current
Changes made by

vjones (Unlicensed)

Valerie Jones

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Projects in Progress

Project (ServiceNow Link)
Description
Start
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 Hold

Awaiting 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 HoldData model design and ETL complete, changes will be implemented in Fall 2016KFS Purchasing/Accounts PayableNew addition to KFS data warehouse to include purchasing and accounts payable documents, attributes and transactions. Develop reports based on requirements.9/1/2015On HoldModeling is complete. ETL is complete, and Cognos Frameworks are in progressKFS 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 HoldRequirements gathering and functional specification development in progress. Data model design in progress.

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 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

3/2/2015In ProgressDevelopment of operational data store and conversion of existing operational reports is complete.  Development of negotiations dimensional model is complete and awaiting feedback from functional staff.  Adjustments to Cognos annual reports are underway as a result of data discovery from the newly developed framework model.  New report development underway for monthly and quarterly reports, in addition to, new ad hoc reports from KC./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. In Progress /wiki/spaces/adcom/pages/68002818 (ServiceNow)Implement Data Cookbook as a metadata management tool.5/1/2016In ProgressFinishing configuration; working with OIR as functional owners to identify data owners & stewards; workflow./wiki/spaces/public/pages/31361193Cognos 11, aka Cognos Analytics, was released in December 2015.   This latest release of Cognos offers a more modern GUI, and consolation of several report development tools. In Progress

Currently migrating KFS reports to Cognos 11 test instance. Planned roll-out for KFS will be in conjunction with the KFS Upgrade in February 2018.

 

Analytics Use & Adoption ReportingDevelop 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 ProgressStudent 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/68014905A 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
roadmap
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.   
12/1/2017
In Progress
 Decision Support Access Request Process    SQL Server Upgrade    Database Planning and Proposal for new Architecture    

 

...


Data Warehouse Website RedesignAs 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 ProgressWebsite 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 ProgressDrafted of process documented for Student Data