Project: Data Warehouse Expansion

Project: Data Warehouse Expansion

Reporting Period: March19 – March 23, 2018

Status Item / Current Status / Status Notes
Overall Project Status / / The project is in a status of “Good”. The schedule compression that was occurring is ended. Scope containment will be the focus in the coming weeks in order to protect the project goals and objectives.
Schedule / The schedule compression issues have been resolved and the timeline recovery is underway. A “Good” schedule status is expected within 2 or 3 weeks barring negative emergent issues arise.
Scope / The data warehouse expansion project/scope was presented to, and approved by Cabinet and the Board of Trusteesin Feb 2018.A better quantification of scope is a needed.
Budget / / The Board of Trustees approved the project funding in the amount of $838,388. Expenditures to date equal $11,705. The estimated run rate is $105,600 per month for the next 3 months.

KEY TARGET DATES

Project Plan Milestones/Deliverables / Target Date / Status / Activities / Target Date / Status
Project Kick-Off / 01/01/18 / C / Install SAS / 03/02/18 / C
BOT/Cabinet Expansion Approval / 02/09/18 / C / Configure SAS Server / 03/02/18 / C
Accreditation Data / 02/19/18 / C / Onboard SAS Development Resources / 03/01/18 / C
Scope Finalized / 03/02/18 / C / Onboard WebFocus Dev Resource / 04/01/18 / C
Architecture Finalized / 04/06/18 / O / Scope Finalized / 03/02/18 / C
Accreditation Dashboard / 03/14/18 / B / Risk/Issue Management / 03/02/18 / C
Enrollment Mgt. Dashboard / 04/06/18 / O / Team Meetings Scheduled / 03/05/18 / C
Retention Dashboard / 04/06/18 / O / Sierra-Cedar SoW / 03/07/18 / C
Pipeline Dashboard / 04/06/18 / O / Consultant Logistics / 03/08/18 / C
ASL/College/Program (SOE) / 04/06/18 / O / Consultant Work Areas / 03/12/18 / C
University Metrics (M26) / 09/15/18 / O / Consultant Accounts & Access / 03/12/18 / C
Training Complete / 09/30/18 / O / Final Project Plan / 03/16/18 / O
Self-Service Analytics Online / 10/01/18 / O / Architecture Finalized / 04/16/18 / O
Data Warehouse Complete / 10/31/18 / O / SAS Training Complete / 04/16/18 / O
Project Close / 11/15/18 / O / Accreditation Dashboard / 03/14/18 / O

* Adjusted Date

Schedule Adherence / Overall Project Health
Ahead of Schedule / Behind Schedule / Complete / At Risk / On Schedule /
/ /
A / B / C / ! / O
Activity & Task Tracking:
With the on-boarding of three consultant developers, the focus will be on the development of files, dashboards and soon dimensions. Current estimates are 21 data files and 88 dashboards. These development activities are being actively managed to expedite and ensure a good schedule recovery and solid cost containment.

2/21/2018

Changes/Issues/Decisions
This section is provided as a point of reference forchanges, issues or decision relating to project, policy, procedure or process that may require stakeholder review, advisement, approval or escalation.
Recommendation / Key Decisions and Resolution
Infrastructure/Server configuration cannot be accomplished with skills available / Engage vendor (SAS) for assistance; / No Fee contract signed; Scheduling SAS resource for 3/16/18; Issue is resolved.
Compute and storage capacity limitations prohibit best practice development environments. / Identify, size and procure compute and storage hardware needed.
Faculty Data (TT/NTT, Degrees held, admin positions, rank, etc) is not in alignment with reporting requirements. / Document discrepancies, formulate options and escalate for decision.

Risk Management

This section is provided as a point of reference for identified risks to the project, their potential impact, probability of occurring and mitigating actions recommended or initiated.

Risk / Impact / Probability / Mitigating Action
Data Warehouse design is more complex than anticipated / High / Med / Acquire skills necessary to achieve proper design; Training; Scale back functionality;
Department data corrections are extensive / High / Med / Training; Communication; Provide support to departments in the form of scripts to expedite changes and reduce workload;
Data requirements lead to departmental process or policy change / High / ? / Development has not progressed to a point where we can test the transactional data systems. Until that happens this probability is unknown.

2/21/2018