INFORMATION SYSTEM FOR THE COLLECTION AND ANALYSIS OF THE HIGHER EDUCATION ACTIVITIES FINANCIAL AND STATISTICAL DATA

About project
A universal report constructor that combines data from 3 systems:
Unified state electronic database on education "ЄДЕБО"
Automated system of the State Treasury Service of Ukraine "Є-Звітність"
Unified information system Science at Universities "Наука"
Task

Creation of the information system for collecting and analyzing financial and statistical data on the work of higher education institutions in order to improve IT infrastructure in the Ministry of Education and Science of Ukraine was the result of the international technical assistance project "Alliance Promoting Transparent Education Management in Ukraine" (Ukrainian Transparent Education Management Alliance, UTEMA) that was funded by United States Agency for International Development (USAID).
Project Roles
iSKY.SOLUTIONS

development and general management

Institute of Educational Analytics


data structure consultations
Ministry of Education and Science of Ukraine

data structure consultations
United States Agency for International Development

financing
Baseline

You receive statistics data > 9 GB.

It is necessary to structure the data and reports within 10 seconds.

It is also necessary to exclude the human factor working with reports in order to save time for potential users of the system.
Project Goals
Efficient data collection
Data processing
Data storage
Reports creation
Architecture

A microservice architecture was chosen.

The project consisted of three servers, each of which performed its task:

server served the web infrastructure;
server served the database and Hadoop;
server provided backup
Project Technologies
Mysql, Redis, RabittMQ
Hadoop
Laravel & Python, Talend Open Studio
Vue, Vuex, Vuetify, SPA
Result:

1. An effective system for collecting reliable, relevant, evidence-based financial and other data on the system of indicators needed for decision-making.

2. An array of necessary financial and operational statistical information collected in one place in the context of individual universities, educational levels and specialties, which you can rely on when making decisions.

3. The ability to analyze the universities financial state and the effectiveness of their budget funds usage, to plan the costs of higher education.
Reviews
Liliya Grinevich
Minister of Education and Science of Ukraine
This system integrates information from the databases of three electronic systems: the Unified state electronic database on education "ЄДЕБО", automated system of the State Treasury Service of Ukraine "Є-Звітність" and unified information system Science at Universities "Наука". All data is automatically obtained and updated in one place - based on the main directory - the register of universities. It saves much more time for employees, because it is one story when we carry paper documents, and another story is to use electronic devices.
Andrii Lytvynchuk
Deputy Director at State Scientific Institution "Institute of Educational Analytics" of the MINISTRY OF EDUCATION AND SCIENCE OF UKRAINE
Previously, the Ministry of Education could not quickly generate university reports for analytics.
Thanks to the USAID UTEMA project, we, together with the iSKY.SOLUTIONS team, have developed an excellent report constructor. Now the staff of the Institute of Educational Analytics can quickly build almost any necessary report, which significantly saves working time from 1 day up to 1 hour.
Ready to discuss your project?
We can work with large volumes of data and we are ready to develop for you a system for collecting and analyzing data of any complexity
Contacts
+38 (068) 014-97-18
hello@isky.solutions
D.Yavornitskogo Street 111, 49000, Dnipro