9 Jul 2020

Across industries, all modern organisations are fueled by data, and learning from that data is a natural pursuit to grow and optimise, especially in higher education. Harnessing data on attendance, dropout rates, and classroom participation help institutions proactively engage with students to keep them on a path to graduation.

For one university, leveraging their data required migrating two on-premise data centres to Microsoft Azure cloud services with ongoing optimisation, a big demand on their internal IT team’s bandwidth and expertise.

Data architecture

To realise the potential benefits of their data, the organisation needed extra data architecture and database support. The university recognised that a senior database architect and administrator would bring value to every aspect of the data lifecycle:

  • Assessing the environment
  • Architecting the future state
  • Implementation of the future state
  • Management of the environment
  • Leveraging the data for business insights

To fill the database expertise gap, the university found a partner with Ntirety’s Remote Database Administrator (DBA) and OnDemand services.

Solution: database services

Remote DBA and OnDemand services stepped in for Data Factory, Databricks, machine learning, and Azure services

By supporting every aspect of the data lifecycle, Ntirety’s database services were foundational in helping the university gather the insights needed to make an impactful outreach to students.

To let their internal IT teams and data scientists focus on other their core functions, Ntirety’s Remote DBA and OnDemand services stepped in as the university’s IT research and development staff for Data Factory, Databricks, machine learning, and other Azure services. Acting as a liaison between Microsoft and the university and with their goals in mind, Ntirety provided guidance and training for internal developers as new products and tools became available.

OnDemand solution

Ntirety’s highly flexible OnDemand solution supplied the Azure, database, and business intelligence expertise needed to tackle different projects week to week. These various projects included continuously optimising queries to improve the performance of the database environment, make more efficient use of resources, and help reduce costs.

In one such instance, Ntirety tuned a critical query’s runtime from minutes to seconds. Ntirety’s Remote DBA support allowed the university to truly start leveraging its data by providing the ongoing implementations and 24×7 management aspects of the data lifecycle.

AI initiatives

Once the future state was deployed and managed to ensure availability and performance, Ntirety helped spearhead the direction of the university’s business intelligence and AI initiatives.

By performing much of the technological roadmap design and the associated data engineering, Ntirety helped the university’s Data Scientists focus on building algorithms and gleaning insightful data from the information they had.

Results

By standardising data, scientists could evaluate a more complete picture of student success criteria

Leveraging data to make more accurate and more informed business decisions is the most beneficial point in the data lifecycle for almost every organisation, and the university’s data scientists were ready to start gathering more sophisticated insights.

By collecting and standardising data from a variety of different systems, data scientists could evaluate a more complete picture of student success criteria including class attendance, participation levels, interaction rates with advisors, and more.

Forecasting models, IT initiatives

Through the IT architecture designed and constructed by Ntirety’s database experts in conjunction with the university’s internal tech team, the university was able to implement forecasting models to determine those students who were at-risk and proactively engage them earlier in their academic careers to help them stay in their programs and achieve their degrees at a higher success rate.

The university was able to effectively implement its own IT initiatives in part due to the foundational database services Ntirety consistently provided. From the smooth migration from on-premise to Microsoft Azure cloud and ongoing OnDemand support services, Ntirety helped enable continuous success for the university’s data scientists and ultimately their students as well.