EdTech Leader Vedantu Extracts Value from Data with Skyvia

Vedantu is a popular e-learning platform used by 4+ million students in India. The platform is the leader in the K-12 LIVE tutoring and provides a wide range of educational services using proprietary teaching models.

Vedantu

EdTech (Education Technology)

Data Integration

Challenge

Vedantu's knowledge network educates millions of students and employs 2,000+ professionals. As a result, it aims to effectively handle all students' personal and interactional data, educational materials, and the e-learning platform in general.

There is an app for the students to ask questions and queries. There are recorded sessions and live sessions, in multiple categories and types, where students interact with our care team, academy mentors, and teachers."

Chandan Alawadhi

Senior Program Manager at Vedantu

With loads of data to handle, the company's main challenge was building data pipelines between various systems. It was necessary to define which data is requested from Amazon Redshift, where educational materials are stored, and associate it with Salesforce accounts and Google Looker Studio dashboards. The Vedantu team wanted to keep all three tools connected and apply data transformations in the way needed.

There is an app for the students to ask questions and queries. There are recorded sessions and live sessions, in multiple categories and types, where students interact with our care team, academy mentors, and teachers."

Chandan Alawadhi

Senior Program Manager at Vedantu

Solution

When exploring the ETL solutions on the market, Vedantu had three fundamental criteria:

  1. usability
  2. pricing
  3. available connectors

After thorough market research and trial runs, they settled on Skyvia. This solution supports all the company's tools (Redshift, Salesforce, Looker Studio, and Zoho Analytics) and offers a flexible pricing model and a user-friendly interface. In fact, Skyvia is used by around 20% of Verdantu's workforce. Thus, multiple data pipelines are designed for a specific case.

Data Pipeline Diagram

Usually, the company's admins use Skyvia to automate the data flows from their analytics database to the reporting tools (Looker and Zoho Analytics), so there is no data gap. The Vedantu team particularly values the robust transformation settings within Data Flow and uses them regularly alongside other available functions.

We're using the value function in Data Flow where we save a particular value as a variable. And next time, if that particular package is running on a day schedule, we use that value in our query right next day."

Chandan Alawadhi

Senior Program Manager at Vedantu

Skyvia Data Integration product allows to replicate and sync data from QuickBooks Online to the local MySQL database using a convenient GUI wizard. Skyvia Backup comes as a nice bonus allowing to backup the sensitive billing data on the highly secure Microsoft Azure cloud server.

Results

These days, Vedantu team members rely on Skyvia for their daily data transfers between apps and finding solutions to their queries. For instance, if an academic mentor wants to track student attendance, they set up a data flow from Redshift to Salesforce. This helps tutors identify students missing classes, allowing mentors to intervene and address any issues or make program adjustments as needed.

Among the results of implementing, Skyvia helped us remove redundancies in the processes, reduce data gaps, and thus save overall cost."

Chandan Alawadhi

Senior Program Manager at Vedantu

Explore Skyvia features nowGet started for free