Modern Data Stack Helps Supr Daily Improve its Operational Efficiency

Mashal Kumar, Lead Analyst at Supr Daily uses a combination of Hevo, Snowflake, dbt, and Sisense to power their analytics infrastructure and helps their business teams meet the operational SLAs by providing accurate, unified, and real-time data.

Get a Demo

100% Data Accuracy

Hevo’s fault-tolerant architecture ensures that Supr Daily’s operations team gets fully accurate data always

3 Months Saved

Supr Daily saved 90 days bandwidth of 5 data engineers by eliminating the need for writing and maintaining custom scripts

50k+ Charts

Hevo and Snowflake powers 50k+ charts built on Sisense with accurate data

The overall data analytics team at Supr Daily consists of 12 members and they are responsible for supporting the analytics needs of 6 different teams such as customer app, growth, customer interaction, category management, procurement, and last-mile delivery. Meet Mashal Kumar who works as a lead analyst and takes care of the data warehousing and the entire analytics infrastructure at Supr Daily. He is responsible for setting up the org-wide analytics on top of their business data to support both internal or external use cases.

Mashal Kumar
Mashal Kumar

Lead Analyst

Supr Daily’s business model is very unique and they follow stringent SLAs. The customers can place orders on their mobile app anytime before 11 PM and they get the next day delivery between 5 AM to 7 AM at their doorstep. Every order goes through procurement, packaging, transportation, and last-mile delivery to reach the customer.

Data Challenges

The analytics team at Supr Daily was using a single BI tool to perform data integration, data processing, analytics, and reporting functions. This tool was primarily used for ingesting data from their backend database to a data warehouse and creating reports on top of it. This data warehouse was created on Snowflake but it was fully managed by their BI tool.

To keep a track of their day-to-day business operations, different teams at Supr Daily were heavily dependent on the reports that used to get generated on this tool. In 2019-20 Supr Daily’s business grew multifold and so did their data. That was the time when they realized that they can cover a lot more use cases with their data and hence they needed to upgrade the infrastructure to support their futuristic data and analytics plans.

We had few limitations with an existing data warehouse. Major ones being the ability to create limited processed datasets and their refresh. Refreshes were always full-load and not incremental. We were also having difficulties in consuming this data outside the SQL environment. Processing via R/Python/Scala was difficult. We’ve created almost 50k charts for different teams to monitor business KPIs but in a single day we could only refresh 20k charts due to the compute bandwidth limitations.

- Mashal Kumar, Lead Analyst, Supr Daily

It was becoming extremely difficult for their business teams to trust the data and charts because of the latency and refresh issues. Their analytics team realized the limitations and hence they decided to look for a specialized cloud data warehousing platform and a data integration solution that can help them achieve a lot more with their data.

The Solution

While evaluating the different data warehousing platforms, Mashal decided to settle with Snowflake. Having previously worked with Snowflake, they had confidence in Snowflake with respect to its query execution time and compute requirements. After setting up the data warehouse and migrating all their data sets to Snowflake, Mashal started evaluating the specialized data integration tool to unify their data from multiple sources.

We didn’t want to spend a lot of time integrating our data, cleaning it, and making it ready for analytics. We’re looking for a plug-and-play solution that can ease our efforts in building data pipelines without writing any code. We tried Hevo and decided to go ahead with it primarily for 3 reasons - high data accuracy, prompt customer support, and no-code data platform.

- Mashal Kumar, Lead Analyst, Supr Daily

The migration of their org-wide engineering & analytics data and charts from their BI tool to Snowflake took almost 3 months but Mashal could set up their data pipelines on Hevo within a week’s time. They use Hevo to connect and load their data from Postgres and MySQL, Google sheets, and S3 to Snowflake. They use Sisense as their BI dashboard tool and created multiple reports to track their key metrics related to orders and inventory. They also use MoEngage to run their marketing campaigns for better conversion and customer engagement.

Hevo Supr Daily's Data Stack

Data plays a very crucial role in streamlining our day-to-day operations. It helps multiple teams to make important decisions at the right time. We can’t afford even a single error in our day-to-day operations as it can lead to delivery issues and impact customer satisfaction. We use dbt to build predictive models to forecast the demand-supply for the next few days and reduce wastages or leakages happening on a day-to-day basis to save cost. We are extremely happy with the quality of data that we get from Hevo and it definitely helps our teams take the data-driven decisions faster.

- Mashal Kumar, Lead Analyst, Supr Daily

Key Results

Switching to a modern data stack has helped Supr Daily cover multiple use cases with more data sets. They are now able to power all their 50K+ charts with the most accurate, unified, and real-time data. Building automated, no-code data pipelines using Hevo helped Supr Daily save the bandwidth of 5 data engineers and almost 90 days of time which otherwise would have been spent in writing and maintaining custom scripts.

Hevo’s support team has answers to all our questions, they are super helpful and respond quickly to all our queries. I would definitely recommend Hevo to anyone who is looking for an advanced data integration tool. It’s definitely a cost-effective tool that can do all the heavy lifting without the hassle of writing or maintaining any code.

- Mashal Kumar, Lead Analyst, Supr Daily

Supr Daily is expanding its operations in the already existing cities with more inventory and wider reach to individual houses and aiming to cross a 100M customer base this year, Hevo is happy to be a part of their growth journey and looking forward to strengthening this partnership in the years to come.

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.