Data Warehouse

Strategy

The current strategy of the Data Warehouse is to focus on projects that support significant business process improvements. We are particularly interested in supporting units where there is significant need for both ad-hoc analysis and standard reports, or a need for small focused data marts to simplify integration of information for reviewing specific complex or high volume business processes.

Goals

The over-arching goal of the Data Warehouse is to provide a platform for campus constituents to access information relevant to their work. In order to accomplish this, the Data Warehouse is constantly changing in response to the needs of campus units and users. While small changes may be made in the moment, larger projects go through a more formal discussion, planning and vetting process.

To learn more about the two-year project cycle process, please see our Steering Committee page.

Current Projects

We are currently in between user-driven project cycles, but maintenance, clean-up and infrastructure projects are keeping us busy.

  • Hardware Move

The Data Warehouse and FMW infrastructure moved to new and better hardware. This is giving us the opportunity to review many back-end processes and update them accordingly.

  • AIS-Daily

AIS-Daily was one of our biggest implementations yet! The bulk of the work is finished, but we are still finding areas that need optimizing, updating or changing based on user feedback.

  • Small Requests

Some requests are small and do not warrant a full project proposal in our two year cycle. We try to do these as they come if we have time, but sometimes the big projects have to take up our attention. We are still working down our list of existing smaller requests.