Data Challenges
The leadership team wanted everyone in the organization to know their numbers and have ready access to data. I was in need of a tool that would solve my data bottleneck and scale with our accelerated growth.
At Meesho, all functions especially category, product, and customer experience teams were heavily dependant on the Data Analytics team for insights on all core metrics. Meesho’s data rested mostly on MySQL, Mixpanel, and Facebook. With data residing in multiple disconnected silos, data collation, transformation, and manual report generation were increasingly becoming a pain. Additionally, creating reports on excel would take hours if not more to churn data, limiting the productivity of the Data team.
It was impossible for someone who does not understand SQL or Advanced Excel to see the data without the help of the Analytics team. We wanted to snap out of this bottleneck.
The Solution
After extensive research, the Data team figured out that to be able to run complex queries on data and build deeper insights, they will have to:
- Set up a Data Warehouse
- Set up a robust ETL solution
- At the back of the head, they also knew that this system had to be implemented in light of costs, skills, and people.
Meesho set up their data warehouse with Redshift which is now their single source of truth. The option to build a custom ETL solution in-house was ruled out as it came with a lot of overheads. The team did not want to move the focus of engineering from core objectives. Meesho decided to look out for a modern ETL solution that would extract the data from siloed sources, transform them on the fly and move into Redshift. Hevo simplified their data integration process with its ready connectors and hassle-free data movement experience.
Bringing in Hevo was a boon. Our data moves seamlessly from all sources to Redshift, enabling us to do so much more with it
Once Meesho settled on Hevo, it took them less than 10 days to set the ball rolling. Chushul himself was able to set up the pipelines without any engineering bandwidth as the set up included only a handful of easy steps: connecting the sources to Hevo, writing relevant transformations, and finally mapping the output to Redshift.
Hevo is very flexible compared to other tools we evaluated. It allows us to handle all exceptions and custom use cases effortlessly.
Hevo streamlined the data pipelines at Meesho, directly impacting the data visibility across all business users. With a front-end reporting tool (Metabase) all teams track their core metrics and create custom reports in real-time on the data made available by Hevo.
By making the data available in real-time, Hevo has enabled us to improve data centricity across the organization and our seller partners. Our meetings are shorter and faster now!
Key Results
Over 40 users generate and track core business metrics on a daily basis. Report generation hardly takes a few minutes and this ensures that all the decisions made are data sound.
Since the implementation of Hevo, the data team focuses on generating extensive reports on customer and seller analytics. The freed-up bandwidth is being used to focus on predictive analytics projects that can bring in futuristic insights to the table.
I love Hevo’s support. Having worked with so many third-party tools, interacting with Hevo has been one of my most seamless experiences.
With a recent Series C funding, Meesho is on its way to becoming India’s largest e-commerce distribution network. Hevo is proud to be a part of this voyage by contributing our bit to help them be more data-driven.
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.
