Revolutionize the Enterprise Data Ecosystem

Accomplishments

Supported the transition of student data from ODS to RAE by completing 80-90% of ODS objects, assigning Data Stewards and Domains to the new environment, and ensuring key OTDI table needs were met. Communicated with ODS customers to initiate ServiceNow requests for data access, with further details available at the Data Lake service page.

A new IDP Calculator has been developed and deployed to support the community in determining data classifications to ensure that approved tools and required encryption are used for sending and storing data.

The Ohio State data catalog continues to grow as we work with units to onboard contents and automate ingestion with scripts and collectors. New contents included Workday reports, Epic reports, RAE tables and expanded Tableau contents. Plans for continued expansion in FY 26 are in place as are user adoption plans.

A new Primary data domain was added to the university’s data domain structure for IT Security Logs and the assigned data stewards were onboarded. Other domain updates were made as needed and replacement data stewards were onboarded for those who left the university or changed positions.

The Enterprise Architecture & Integrations and Data Visualization teams explored data virtualization to provide real-time access across disparate systems - simplifying integration, enhancing analytics, and supporting a unified data view that simplifies integration and accelerates insights across the university.

Responding to campus-wide user feedback, the Data Visualization team expanded Tableau Server's capabilities by enabling TabPy and RServe. These integrations empower faculty and staff to embed Python and R scripts directly into dashboards, unlocking advanced statistical modeling, machine learning, and predictive analytics to support data-driven teaching, research, and operations.

To promote scalable and consistent use of data tools, the Data Visualization team strengthened Power BI readiness through Enterprise best practices, standardized workspace domains, and reusable DAX libraries. Users may choose between data visualization tools – Tableau or Power BI.

To further strengthen Ohio State’s data infrastructure, the teams collaborated to develop a comprehensive suite of documentation and training resources – including an Enterprise dashboard checklist, process mapping from data ideation through RAE to Tableau, and clearly defined roles within the enterprise reporting structure. These resources support onboarding, governance, engineering, and analytics functions, fostering data literacy and enabling scalable, sustainable reporting practices across the university.

The Data Visualization team is programmatically leveraging the Tableau Server REST API for administrative task automation – ensuring the right users have access to the right, up-to-date data.