Delivering Data to Enable Growth
Munchery is reinventing weeknight dinners and making it easy to put healthy meals on the table that are prepared by local chefs using the highest-quality ingredients.
Problem: Difficult to Democratize Data
As a nimble and resource-strapped team focused on scaling their product and operations, Munchery took it upon themselves to build out their own reporting tools in-house using an off-the-shelf SQL. Although the in-house tool allowed them to create basic reports, it had limited sharing capabilities.
Since there was no central way to view and share dashboards with the company, it was extremely difficult to democratize data.
"Since there was no central way to view and share dashboards with the company, it was extremely difficult to democratize data," said Conrad Chu, Chief Technology Officer.
In addition to the obstacles in sharing dashboards, only a select number of individuals at the company were able to create, edit and share those reports-leading to friction between data gatekeepers and business users. On the consumption side, business users were also frustrated because the reports were often static with no ability to explore the data further.
Bringing All the Data Together
With challenges stacking up, Munchery began to evaluate Business Intelligence solutions that would fit their needs and relieve their overloaded Engineering team.
At the time, Munchery data was siloed between MySQL, Google Analytics, Segment.io and Redshift.
"There was too much data and not enough insight to help drive business decisions for our rapidly growing company," said Conrad.
Munchery wanted a solution that would bring together all their disparate data sources and allow them to write queries in SQL.
"Having the Engineering team learn and write in a proprietary language would have resulted in an even larger bottleneck, and it would further push out the company's ability to surface insights and drive towards tangible results," said Conrad.
As the business team that possesses a background in investment banking, Munchery's team was comfortable with simple SQL and Excel functionality, but saw the biggest changes through Chartio's ease of use.
When Munchery found Chartio, it was an instant success. Chartio has eliminated the data bottleneck and enabled our whole team to easily analyze and visualize our data.
"When Munchery found Chartio, it was an instant success. Chartio has eliminated the data bottleneck and enabled our whole team to easily analyze and visualize our data. Now everyone can collaborate and work in real-time to get the insights we need to be successful," said Conrad.
Towards the end of the evaluation process, Munchery brought on Jack Yin to lead Analytics within the company. As the main administrator of Chartio, it was crucial that the company chose a tool that would help Jack succeed in his role.
One of Jack's responsibilities as a Strategy and Business Insights Analyst was to abolish data gatekeepers within the company and truly democratize data. As an expert in SQL, Jack was able to strategically create intuitive dashboards within Chartio and easily distribute it across the company.
"My main responsibility is to handle data complexities, break it down and present the information in a meaningful way that allows the company to do their own analyses and make decisions by interacting with the data," said Jack.
If Munchery's Operations team was looking for a specific trend in one particular neighborhood-instead of asking Jack for help, they're empowered to look at the dashboard, dig into the information and do their own analysis in real-time.
With operations across the nation, real-time analysis is crucial for success.
"The raw data within our MySQL database isn't compelling enough on its own and doesn't give the team the ability to make decisions. But, by using Chartio, Munchery is able to discover food ordering trends, analyze delivery performance and discover opportunities for growth easily, allowing everyone to answer their own questions," said Jack.
Today, at Munchery, Chartio dashboards are public information. As Jack is unburdened with responding to ad-hoc requests, he can now refocus on his role responsibilities and dig deeper into the data.
"Chartio has been instrumental in freeing up my time to perform more substantial analyses rather than being reactive to emergency requests. Because of Chartio, we now have a standard source of information," said Jack.