Cde Bid Data Education
The Context
Our client is a publisher of Spanish origin that stands out for its commitment to education and cultural dissemination. Its mission is to bring its products and educational content to as many people as possible, promoting diversity, integration and the development of knowledge with all its publications.
Faced with the challenge of being able to exploit the information generated by the use of educational products that are hosted on its own platforms as well as those that are distributed to third parties, NEORIS developed a solution capable of centralizing all the information in a single database, in addition to improving the company's control over its educational content.
The Challenge
The company's objective was to create a tool that would allow it to automate and control the obtaining of information about the use of its digital products on its own and on various external platforms where the materials are hosted. To do this, it was necessary to develop a project that would:
- Standardize traceability information to control everything that happens when students interact with the different platforms.
- Create an infrastructure that brings together, in a single database, all the information generated by students.
- Exploit all the information obtained to make reports and improve business decision making.
The Solution
Through collaboration with NEORIS, a solution was carried out that improves control over digital products, in addition to making it more efficient to obtain key indicators for the business, such as the results of the distribution of content to third parties, the analysis of its consumption or the evaluation of their understanding by the students, among other objectives.
An end-to-end digital project in every sense
The NEORIS solution was developed in three fundamental phases:
- The first stage focused on collecting information from different data sources to centralize and standardize traceability about what students do with the digital educational products. After this, a central database format was defined that, through batch processing, was responsible for reading all the information obtained from its own and third-party systems to destructure it into a relational model and, finally, to classify it into three major divisions:
- Courses and books.
- Visiting students or people who use digital content.
- Activities, customizations and digital educational content.
- Once the relational model was generated, the second phase of the project consisted of developing the entire Cloud infrastructure in AWS for the processing, ingestion and treatment of information, so that a complete data architecture was obtained to support the project.
- In the third stage, data ingestion was carried out and a Big Data architecture was set up to exploit all the information. Specifically, a dashboard was generated in Microsoft Power BI based on Data Storytelling that shows the relevant indicators for the business.
The Results
Once put into production, this solution has been able to concentrate all the information, coming from various sources, into a single database to obtain indicators that best fit the needs of the business.
The company's lack of control over the digital products it shares on third-party platforms was resolved by using a central database model that allows it to know, at all times, how users interact with and utilize its educational content.
Currently, with the premise of working on continuous improvement, work is being done to detect possible aspects of improvement to evolve the dashboards and add new KPIs or metrics. This will be done by incorporating new functionalities that through Artificial Intelligence (AI) and natural language processing models allow for an agile and efficient query of the central database.
Testimonials
“This solution validates our commitment to digitally transform the education sector and reinforces our ability to develop any project of this nature. What’s more, thanks to the solid experience of our professionals and our deep knowledge of the business, we can guarantee outstanding results in every initiative we undertake.”
Miguel Acero – Education Director for NEORIS Spain