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
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 DataShiftMore projects
See full portfolio
Aviation
Aviation Integration & Reporting
Legal
Law Firm Integration & Reporting
Property
Property Development & Rental Management
Engineering
Dust Extraction Flow Automation
All industries
Document Signing Solution
Government council
Sportsground Auditing
Automotive
Automotive – Electric Vehicles
Farming
Farm Worker Staff Tracking
Mining
Australian Mine Form Automation
Healthcare & more
Remote Appointment Management
Retail
Retail Data Warehouse & Reporting
Group of companies
Multi-Company ERP Integration
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!