How Groww Improved the Accessibility and Availability of Data for Product, Engineering and Data Team

Samarth Kishnani, Product Manager at Groww uses Hevo, a no-code data pipeline platform to automate the process of aggregating data from multiple source systems and storing it in a data warehouse.

Get a Demo

10x Faster Reporting

The data analysts at Groww are now able to generate reports 10 times faster

20 Hours

Data engineers saved 20 hours a week by eliminating the need for writing custom code and queries

30 Minutes

Time required to generate reports got reduced from 2 days to 30 minutes

The data team at Groww primarily consists of 3 members, Samarth Kishnani who is a Product Manager, Ankit Singh is a senior engineer and Kashyap is a data engineer. Samarth and Ankit look at the strategy and data architecture whereas Kashyap single-handedly manages the development and execution.

Meet the Data Team at Groww

Samarth Kishnani

Product Manager

Ankit Singh

Senior Engineer

Kashyap Shreepathi

Data Engineer

Data Challenges

Despite the data-driven culture at Groww, ensuring the availability and accessibility of data across the product and engineering teams was still a huge challenge. Samarth, Ankit, and 50 other users needed access to centralized data almost every day to analyze the important business KPIs such as user behavior, buyer journey, investment graphs, and more. But in order to combine this data from disparate sources to a centralized data warehouse, Kashyap and the team had to manually write multiple custom scripts and queries on Jupyter Notebook and Python.

We were spending almost 20 hours a week on writing and managing these scripts and still we were facing a lot of issues with missing data, inefficient queries, inability to track schema changes, and leverage this data for real-time insights, says Ankit.

In order to present the insights and build dashboards for various stakeholders, analysts at Groww used to take almost 2 days, and also some business-critical reports that should have ideally been available in real-time were prepared only on a monthly basis.

The Solution

About seven months into dealing with scattered data, manual processes, and fragile infrastructure, Samarth and Ankit realized the need for automating their entire process.

They started looking for an automated data pipeline tool that requires zero maintenance, no continuous monitoring and ensures high-level security and compliance. After evaluating a few automated data pipeline platforms, Samarth’s friend at Meesho recommended Hevo to him.

After trying Hevo for about 2 weeks, we were highly impressed with some of the features like easy setup, intuitive UI, end-to-end data encryption, multiple pre-built integrations, and advanced transformation logic and we knew we had a winner, says Samarth.

Using Hevo, Groww built a well-streamlined data and analytics stack where data from MySQL, Freshdesk, Google Ads, Facebook ads flow via the Hevo Automated Data Pipeline Platform to BigQuery Data Warehouse. Groww uses Google Data Studio and Metabase to build reports on the data made available by Hevo.

Hevo Groww Data Stack

Kashyap is one of the heavy users of Hevo and he says What I love the most about Hevo is how it automatically fixes most of the data errors, and when Hevo can't solve the issues, it sends out a notification. Hevo allows me to run transformations like date format conversion, concatenating the values, dimensionality reduction on the fly.

Key Result

With Hevo, Samarth and Ankit could ensure that business teams are having access to accurate and most recent data available for analysis. Also, they were able to drastically reduce the time that was required for generating reports from a few days to just under 30 minutes.

Kashyap says, Building a modern data stack with Hevo helped me not just save a lot of time but it also helped me perform real-time data ingestion that helps our team do the real-time data analysis.

By building a single source of truth, the Groww team could analyze user behavior patterns to create an in-house customer support product. The product intelligently guides new visitors on the platform and addresses the concerns of users by providing personalized answers.

Not just Samarth, Ankit, and Kashyap but the entire product and engineering team at Groww found Hevo as a true savior. With data available in a unified view, they now have deeper insights to develop new products that would have otherwise been impossible.

Excited to see Hevo in action and understand how a modern data stack can help your business grow? Sign up for our 14-day free trial or register for a personalized demo with our product expert.