The Client

The Quality Education and Skills Training (QUEST) Alliance is a not for profit organisation that focuses on research-led innovation and advocacy in the field of teaching and learning. QUEST aims to create innovative, engaging learning experiences through the use of modern technology, to enable learners and facilitators to develop 21st century skills in their own time, at their own pace. They engage with multiple stakeholders to demonstrate and enable scalable solutions in education and vocational training using Information and Communication Technology (ICT).

QUEST focuses on children & youth, age 10-30, and provides them with a set of real-world skills along with opportunities to build confidence in a fun and engaging way that prepares them for work and life. QUEST is on a mission to empower 4 million learners & facilitators with 21st century skills for social and economic growth by 2023

Srvices Provided

Tech Stack Used

The Problem

The client had earlier tried multiple reporting tools like Zoho Reports, Tableau and PowerBI to create reports and dashboards. But these initiatives did not yield the expected results as it did not have an integrated workflow and data pipeline. Data was in silos and this presented a significant challenge to the team at QUEST. The client required the following:

  • A well structured analytics system capable of handling large volumes of data.
  • Client preferred moving to an open source solution since they were a not for profit organisation.
  • A future proof architecture that can accommodate the changes to existing applications and new applications.
  • Develop the analytics platform to support multi company architecture in line with the client’s organisation structure.

Implementation & Results

    Implementation was done in the following four phases
    • Implemented the solution using Talend as ETL, MySQL as Data warehouse and Superset as the BI layer.
    • Integration of multiple data sources to the ETL layer.
    • Custom business logic for data processing was integrated into the ETL layer.
    • Creating reports and dashboards using Apache Superset.
    • Testing & QA.

How can we help you?

Get in touch with us to schedule a consultation