ezCater Feeds the Need for Instant Data Access

ezCater is an online marketplace that connects business people with 62,000+ catering partners who provide and deliver food. As the only nationwide option for business catering, ezCater has doubled its business year-over-year for seven years in a row to meet the high demand for its services.  

Supporting company-wide data insights

When Josh Zalinger arrived at ezCater in 2016, Sisense for Cloud Data Teams had just recently been implemented but was only being used actively by one marketing analyst. A year and a half later, he became one of the first members of the data team and the first data scientist. Since then, the company has skyrocketed from around 120 employees to more than 700 across multiple offices, and its data team has grown to eleven full-time analysts and data scientists. Sisense for Cloud Data Teams initially served as just a tool to measure marketing data but has proven to be the best tool to support data analysis across every department.

“From sales to marketing to product to finance, Sisense for Cloud Data Teams is really impacting the entire company today,” said Zalinger. “We’re supporting the entire company to use data to drive all of the decisions that we’re making. If something seems off, we’re going to use Sisense for Cloud Data Teams to dig into the data and see exactly what’s going on there. And if something’s going really well, we’re going to do the same thing to analyze it deeply and see how we can take advantage of it further.”

For example, ezCater’s finance team tracks hiring projections in Sisense for Cloud Data Teams to map out future employee count and what the long-term costs will be. For ezCater’s customer success team, Sisense for Cloud Data Teams helps discover opportunities for their catering partners to be more successful, like decreasing order minimums or expanding the delivery radius to land more customers. 

“ezCater is incredibly transparent, and really anyone in the company can access all kinds of powerful data tools that we’ve built for them. The power users of Sisense for Cloud Data Teams are definitely the data team, in terms of building dashboards and advanced visualizations,” said Zalinger.“But there are plenty of other users across the company who modify existing charts or use Sisense for Cloud Data Teams’s filters to grab information.”

The ezCater data team reserves much of its time to work on large-scale projects like machine learning models or measuring causal impact of major marketing initiatives. But on a day-to-day basis, it also handles ad hoc requests. When a manager on any team wants to understand what actionable data is available on any topic, Zalinger’s team jumps into action building charts and dashboards to support anyone’s needs.

“One of the great things about Sisense for Cloud Data Teams is it just gets out of the way when I need to focus and just lets me work,”said Zalinger. “It’s fast and it’s easy. In real time in the middle of a meeting, I can write some quick SQL and the results are right there on the same screen. The speed and ease of sharing is just incredibly handy.”

Simplicity and speed

Each week, ezCater’s data team leads an executive-tier meeting by walking through high-level dashboards about the overall health of the company and issues on the horizon. Sisense for Cloud Data Teams’s ability to combine multiple data sources into one place means the data team can quickly get answers for executives, live in the meeting.

“We start by reviewing high-level dashboards in that meeting, and inevitably we’ll have specific questions like ‘Oh, that number is interesting, can you tell me more?’ and three seconds later, I have a more detailed dashboard up on the screen ready to go,” said Zalinger. “You can scroll through a dashboard with 60 charts on it and have them appear in real-time with the most recent data – that rapid iteration is incredibly helpful at every step of the process.”  

One of the most powerful features ezCater leverages in Sisense for Cloud Data Teams is SQL snippets, which lets users create a simple string of SQL that can be reused in as many charts as desired. Snippets are one of several features that minimize the number of steps needed to explore data in more depth.  

“I can really just dive right in,” said Zalinger. When I grab a set of data and select a bar chart, it’s instantly got the X and Y axes at the right scale with a good color scheme. I don’t have to spend 10 more minutes transforming it – I can finish getting the data and 30 seconds later be showing it to someone in a finished and polished form.”

The ezCater data team reserves much of its time to work on large-scale projects like machine learning models or measuring causal impact of major marketing initiatives. But on a day-to-day basis, it also handles ad hoc requests. When a manager on any team wants to understand what actionable data is available on any topic, Zalinger’s team jumps into action building charts and dashboards to support anyone’s needs.

“One of the great things about Sisense for Cloud Data Teams is it just gets out of the way when I need to focus and just lets me work,”said Zalinger. “It’s fast and it’s easy. In real time in the middle of a meeting, I can write some quick SQL and the results are right there on the same screen. The speed and ease of sharing is just incredibly handy.”

“I can really just dive right in,” said Zalinger. When I grab a set of data and select a bar chart, it’s instantly got the X and Y axes at the right scale with a good color scheme. I don’t have to spend 10 more minutes transforming it – I can finish getting the data and 30 seconds later be showing it to someone in a finished and polished form.”

Josh Zalinger
Josh Zalinger, Data Scientist at ezCater

ezCater recently made a transition to pair Sisense for Cloud Data Teams’s analytics platform with a warehouse from Snowflake Computing. With Snowflake on board as their data warehouse, ezCater was able to separate compute and storage costs, then scale their deployment on demand of each.  

“Switching to Snowflake gave us a big advantage by letting us throw a lot of CPU power at major data problems without prematurely optimizing them,” said Zalinger. “That was really useful for us for handling the bigger, more difficult queries we’re running in Sisense for Cloud Data Teams.”

Zalinger says the transition to Snowflake has helped them more quickly process powerful queries.

“The Sisense for Cloud Data Teams and Snowflake combination definitely gives us the most speed,” said Zalinger. “Running a query and having to wait an hour for the results isn’t helpful for anyone. That doesn’t keep your work flowing, but we’ve fixed that with Sisense for Cloud Data Teams and Snowflake.”  

As ezCater’s rapid growth continues, its data team expects to continue scaling up. Zalinger’s data team is considering adding more data analysis tools, including Sisense for Cloud Data Teams’s Data Discovery functionality to scale data exploration efforts for non-technical users across the whole company, and Sisense for Cloud Data Teams’ R and Python integration.

“There’s always more demand for data and data specialists,” said Zalinger. “We just want to continue making sure every individual contributor, every customer service agent and every manager has access to properly measure their KPIs and goals and have all the data they need to succeed at their jobs.”