About

Technocentrum Utrecht (TCU), a partnership of business and technical training centers, focuses on knowledge reinforcement and renewal, as well as on better integration between vocational technical education.

challenge

To store a large amount of diverse data on the educational system, the Client was continuously creating temporary data tables. Such ineffective storage of information prevented getting valuable insights based on the data. Therefore, the Client needed to systematize all the available data, enable data import as well as create statistical reports.

Solution

VolgoTechnologies designed a website that allowed users to create statistical reports on the educational system development at the country level. The website was complemented with a specially developed database. Now reports are built based on given criteria and parameters and are presented as tables or graphs. The dynamic query generator allows users to set the necessary parameters in a form and dynamically change additional parameters.

Staging

Staging a 24/7 L1 Support implementation for an educational company operating in 39 countries involves planning around global operations, multilingual support, and technology platforms that facilitate seamless communication and troubleshooting across diverse regions and time zones. The focus for L1 (Level 1) support is on quick resolution of common technical issues, escalation processes, and providing exceptional service to students, educators, and staff around the clock.

Dataware House

Dataware House

Desktop Application

Results

The website allowed to decrease the number of data tables by 3 times and the amount of duplicated data by 5 times; data storage, analysis and visualization were improved via the implementation of the database, the dynamic query generator and a special module for data manipulation. VolgoTechnologies team introduced a feature for protection from improper user actions, "incomplete" and / or "incorrect" data entry in the database/PHP content. Overall, VolgoTechnologies agile website development team managed to improve the system stability and performance.

Technologies and Tools

CMS: Drupal 6 Additional modules: Taxonomy, CCK Database: MySQL 5.x Language: PHP 5.2.x Webserver: Apache 2.x Frontend: AJAX, JavaScript/JQuery, XHTML IDE: Eclipse, NetBeans Operating system: Linux, Windows