ENTERPRISE DATA ECOSYSTEM

In order to build a robust and unified university data/information ecosystem that delivers data as a strategic working asset, Oregon State University is standardizing data across the university with an enterprise information ecosystem that allows for a collective understanding of our data and how to effectively utilize it, while respecting privacy and security. ​

 

The Enterprise Data Ecosystem program aims to:​

  • Reduce complexity and increase consistency in the ability to effectively use data for decision making and critical business functions ​

  • Increase the community's trust and ability to use data effectively through efficient and standardized data management practices

  • Deliver reliable, secure, and accurate data to the institution in a modern, highly available platform

Set the Course

What we've done

The first part of our journey included several foundational steps. We stood up a formal data governance practice, created a new cloud data environment. Through stakeholder and consultant engagements we identified key data needs and piloted a new collaborative approach to build and validate strategic data assets.

Start the Journey

What we're doing

We are taking our work from pilot to production stage. We are providing leadership robust dashboards and their analysts direct access and training to use the underlying reporting models for deeper discovery and analysis. Deployment of initial validated and standardized content will be released on a rolling basis starting in Fall 2022.

Build our Momentum

What we're doing next

We are preparing to embark on the stage of our data ecosystem journey where improve the quality, management and delivery enterprise data. We will design and build the elements of the ecosystem that allow users to access and understand reliable information whether they are connecting data to systems, using it to perform analysis, or running an individual report.

Reach the Top

Our future environment

The future enterprise data ecosystem is a place where users know where to go to securely access the data they need trust in a format that makes sense and can use with confidence. There is a healthy practice of data management and a robust set of technology that support the governance and both the data operations and strategic needs for the university.

What is available now?

 

With the launch of the Enterprise Data Ecosystem program at OSU, we are re-imagining how we build, validate, deliver and empower users to understand and interact with the data they need for strategic and operational decision making. Below are the currently available pilot dashboards in the data ecosystem.

How can I access Tableau Server?

 

In order to access Tableau Server, you will need to be on campus or connected to Oregon State's VPN.

Admissions

The intent is to support the analysis of applicants within the admissions funnel (e.g. applied, admitted, deposit, matriculated, enrolled) and understand features of the applicant pool such as demographics, geography and academic preparedness. ​

     Undergraduate Dashboard

     Graduate Dashboard

Registrations

The intent is to provide users with insights into key student and course registration metrics by primary college and major. Filters enable further examination of student sub-populations. ​

Completions

The intent is to show degree completion trends by major and college and how those degree trends change over time. ​​

Financial Aid

This area is designed to provide users with insight into financial aid metrics as they relate to key applicant and student dimensions. Includes aid package trends and drill down to view individual aid capabilities. ​​

Persistence

Provides visualizations for re-enrollment and cohort-based student persistence trends as well as graduation and time to degree and degree production. ​​

UFM SUITE WEBSITE

This area links to the University Financial Management (UFM) portal with access to reliable, consistent data for university-wide and college level financial-level reporting while also supporting analysis of underlying detail for improved fiscal decision-making. ​​

   

We're here to help

 

As the Enterprise Data Ecosystem program grows and changes we want to help the OSU community understand and use the data and tools. We invite you explore our resources, reach out for help, and give suggestions or make requests as other needs and questions arise.

 

Training

For further information and resources including recorded training sessions, Quick Guides and more, please visit our training page.

Visit Training

Contact us

Want to learn more? Not sure where to start? Have feedback or questions? Feel free to reach out to us!

Contact Us

 

   

More about the Program

 

The way Oregon State University accesses, interacts with, and understands our data is undergoing radical transformation. This year we made substantial progress in building and delivering a modern, flexible, extendible analytical data platform. We successfully piloted the creation and delivery of initial strategic data models and dashboards in our new cloud-based data ecosystem. Through both the University Financial Management (UFM) and the Enrollment and Student Success (HelioCampus partnership) projects, we have worked collaboratively to create and deliver new robust and reliable dashboards that enable leaders to make data informed decisions and provide their analysts access to the underlying validated data models for deeper investigation and generating additional insights.  ​

This work puts actionable data into the hands of decision makers, reduces complexity, increases consistency, and empowers leaders and their teams to spend more time discovering insights in the data and less time trying to prepare and understand it. The UFM project specifically resulted in considerable time and effort savings in budget planning and fiscal management work. Because of the shared ownership built from the co-creation and validation efforts in these projects, there is an increase in trust in the data and enthusiasm to continue to expand this work to develop these types of data assets for all business functions and value streams.

 

  • Fully instantiate a formal data governance body and practice and approve initial reporting model domain architecture

  • Deploy and using a cloud-based data store and production data pipeline to modernize our ecosystem and from which we can build and deliver strategic data assets. 

  • Deliver Strategic Data Assets in the form of Data Models and Dashboards for Student Success, University Financial Management, and Research Operations. This includes:  

    • Data models and dashboards for UFM were created and piloted in winter and spring 2022. New HR and Finance dashboards will be rolled out in the Fall, with access and training.  

    • Research Compliance data mart built and available in Winter 2022.  

    • Enrollment and Student Success data models and dashboards will be complete August 2022. 

  • Develop and test new collaborative agile process for the co-creation and validation of strategic data assets with university leadership and analysts.

  • Formalize a method for giving data access to the analysts who support senior decision-makers in enrollment and student success: efforts are underway and completion is pending Identity, Data, and Integration Hub efforts scheduled for FY23. 

  • Implement new framework for automatic, role-based access to data rather than job title as it is done today: we have streamlined the Banner access to improve role-based functionality. Completion of this effort is pending Identity project. 

  • Formalize Data Management practice to ensure our strategic data is clearly defined, classified, validated, and accessible. This effort requires partnership between Data Governance, Data and Information Architecture group, the Office of Information Security, and the Data Trustees, Data Stewards, and Data Custodians. 

  • Continue development, curation, and deployment of strategic data assets to deliver trusted and secure data to support and inform decisions related to delivering our value and mission. 

  • Continue to deploy validated and leadership-supported dashboards and data models to the new enterprise data ecosystem on a rolling basis starting in Fall 2022 enterprise wide.

The University Financial Management Suite provides a reliable, consistent set of data for university-wide and college level financial-level reporting while also supporting analysis of underlying detail for improved fiscal decision-making. By using the UFM Suite, deans are equipped to effectively manage their resources by understanding revenue sources and drivers to make tradeoffs between highest and lowest priority investments.

This project creates the technological foundation to build our enterprise data ecosystem to allow access to decision makers and provide consistent data to provide information for effective operations, reporting, planning, and strategic action informed by data. The project consists of three main areas that we are partnering with HelioCampus to deliver:

 

1. A secure hosted cloud data store with a production data pipeline (a secure way to get our data into the cloud)

2. A data warehouse with a defined and managed set of data models for enrollment and student success

3. University facing dashboards for leadership related to enrollment and student success

 

Delivery of these dashboards and reporting models is planned for Fall 2022.

 

  

IT Strategic Plan

The Enterprise Data Ecosystem is just one of several key programs in the OSU IT Strategic Roadmap. These programs represent work that is critical to deepening our capacity and creating new capabilities that will enable OSU to deliver on its core mission of teaching and learning, research and extension.

Explore the roadmap