EdTech Leader Vedantu Extracts Value from Data with Skyvia

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.

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.

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.

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.

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.