ITPC-0621 Data Warehouse and BI Architecture Replacement Analysis

Project Sponsor

  • Kelly Block – Associate Vice President, AITS

  • Nyle Bolliger – Senior Assistant Vice President, AITS

  • Dimuthu Tilakaratne – Assistant Vice President of Decision Support, AITS

Project Scope

Project Description

Perform analysis on and recommend next generation solutions to deliver enhanced Decision Support capabilities to the University of Illinois system.

Project Deliverables and Objectives

Analysis of new, modern, technologies to determine a road map for platforms that enable analytics solutions into the next decade and beyond. The analysis project will lead to decisions on which tools to implement and how to use those at the University of Illinois to meet the analytics needs. Procurement and implementation recommendations and project plans will be output for future implementation efforts.

In Scope

  1. Identify and Investigate next generation solutions to enable streamlined and integrated data analytics including cloud-hosted options:
    • Ad Hoc reporting capabilities and published reports
    • Data visualization and delivery platforms
    • Data Migration (ETL or ELT) solutions
    • Data Virtualization
    • Data Architecture (Database, Data Lakes, Storage, etc.)
  2. Determine Roadmap for Analytics platform
    • Gather requirements and select tools for implementation and procurement recommendations
    • Create and submit project proposals for one or more implementation projects


8/1/2020 - 12/18/2020
Explore Technologies/Set up Vendor Demos

11/15/2020 - 2/15/2021
Develop and refine Requirements and Use Cases

  • Publish AITS Requirements
  • Gather feedback and additional requirements from stakeholders
  • Finalize Requirements based on feedback

2/15/2021 - 2/24/2021
Select vendor tools for Proof of Concept (POC)

  • Gather feedback on vendors
  • Prioritize vendors for POC

2/24/2021 - 5/28/2021
POC and Evaluation of Vendor Tools

  • Stakeholders score vendors

5/31/2021 - 6/30/2021

  • Select Vendor Tools based on POC scores

7/1/2021 - 7/30/2021

  • Implementation Planning
  • Submit Project Proposals to ITPC for implementation project(s)
  • Begin Organizational Change Management Plans – Impact Assessment & Reduction

For questions about this project, please contact Rick Getty or Dimuthu Tilakaratne.