Skip to content
Inasolve - innovative solutions
← Portfolio

Education

Education Data Warehouse & Access Reporting

A managed data warehouse integrated with TechnologyOne, with reporting on campus and remote access.

Industry
Education
Platform
TechnologyOne & Microsoft
Clients
The King's School · SuniTAFE · University of Canberra
Education Data Warehouse & Access Reporting - Education project

The problem

Schools, TAFEs and universities held student, finance and HR data in TechnologyOne, with more in Microsoft 365 and other systems. Reporting meant pulling extracts from each one and reconciling them by hand, every upgrade risked breaking the reports people relied on, and there was no clear view of how systems and services were being accessed on campus and remotely.

The Inasolve solution

We integrated TechnologyOne with each institution's Microsoft environment, using SQL Server, SSIS and Azure Data Factory to feed a central data warehouse on a schedule. Data is cleaned and matched on the way in, so student, finance and staff records line up across systems, and access data sits alongside it so on-campus and remote use can be seen side by side.

We continue to maintain and extend the warehouse as an ongoing service: monitoring the loads, adapting to TechnologyOne and Microsoft updates, and adding new data sources and reports as needs change. Staff get trusted, up-to-date reporting in Power BI, including usage trends, busy periods and unusual access, without manual extracts.

More about DataShift

More projects

See full portfolio

Have a similar challenge?

Tell us what you'd like to achieve. We'll come back to you to talk it through: no obligation, just practical ideas.

Let's get it done!

Adam, the Inasolve mascot

Secure by design ยท security has been our top priority from day one