DoorDash Logs a 30% Increase in Queries while Keeping the Snowflake Cost Constant with Sigma
公司规模
Large Corporate
国家
- United States
产品
- Sigma
- Snowflake
技术栈
- SQL
实施规模
- Enterprise-wide Deployment
影响指标
- Cost Savings
- Customer Satisfaction
- Productivity Improvements
技术
- 分析与建模 - 实时分析
- 平台即服务 (PaaS) - 数据管理平台
适用行业
- Software
- 电子商务
适用功能
- 商业运营
- 销售与市场营销
服务
- 软件设计与工程服务
- 系统集成
- 培训
关于客户
DoorDash is a technology company that connects consumers with their favorite local businesses in 27 countries worldwide. Founded in 2013, DoorDash builds products and services to help businesses innovate, grow, and reach more customers. The company is focused on building infrastructure for local commerce, enabling merchants to thrive in the convenience economy, giving consumers access to more of their communities, and providing work that empowers. DoorDash partners with over 550,000 merchants and has over 25 million consumers using the platform each month. As a lean, data-first, and high-growth company, DoorDash aims to become the leading local commerce platform that people can turn to for all goods.
挑战
DoorDash faced significant challenges with dashboard management and scalability. The existing processes were not conducive to scaling analytics efforts smoothly due to performance and connectivity limitations posed by traditional BI tools. The cost of per-person licenses was high, limiting access and making it difficult to share dashboards and reports with a wider audience. This situation left much to be desired by both creators and consumers of the dashboards. In 2021, Andrew Huynh, Senior Business Intelligence Engineer, and his team at DoorDash began searching for a new BI platform to build a self-service analytics environment and democratize dashboard creation. They evaluated Sigma along with other vendors and ultimately chose Sigma because DoorDash lacked enough data engineers to model and prepare data for all end users, which was a requirement for other tools.
解决方案
Once DoorDash chose Sigma, Andrew and his team spearheaded the implementation, migration, and creation of existing dashboards on the DoorDash side. They rebuilt over 5,000 dashboards in Sigma and onboarded over 30,000 users to the platform. Sigma’s engineers and onboarding team worked closely with DoorDash for a seamless transition through this unprecedented scale of migration. All onboarded users had access to training videos, tutorials, and content tailored to their analytics needs. A community of users was created with open communication, troubleshooting, and support through a shared Slack channel. With Sigma, DoorDash simplified its analytics by reducing the time, costs, and complexity of writing custom SQL. The company saw a 25-30% increase in queries while keeping Snowflake costs constant. Sigma enabled DoorDash to democratize data across the organization, increasing transparency, collaboration, and decision-making. The company could determine which dashboards were essential and decommission others, providing more clarity. Real-time reporting and scheduled exports allowed DoorDash to automate reporting and enable vendors and merchants to self-serve and generate insights. Sigma's role-based permissions ensured GDPR compliance and audit controls for partners, vendors, and affiliates.
运营影响
数量效益
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
相关案例.
Case Study
Digital Transformation of Atlanta Grout & Tile: An IoT Case Study
Atlanta Grout & Tile, a Tile, Stone & Grout restoration company based in Woodstock, Georgia, was facing challenges with its traditional business model. Despite steady growth over the years, the company was falling behind the web revolution and missing out on the opportunity to tap into a new consumer base. They were using independent software from different vendors for each of their department information and workforce management. This resulted in a lot of manual work on excel and the need to export/import data between different systems. This not only increased overhead costs but also slowed down their response to clients. The company also had to prepare numerous reports manually and lacked access to customer trends for effective business decision-making.
Case Study
IFFCO Boosts IT Performance and Innovates Agriculture with Oracle Cloud
Indian Farmers Fertiliser Cooperative Ltd. (IFFCO), the world’s largest manufacturer and marketer of fertilizers in the cooperative sector, was facing several challenges in its quest to innovate and improve the livelihood of farmers in India. The organization had recently launched a new product, nano urea, which brought new demands to IFFCO’s cloud computing needs. The organization needed a reliable cloud vendor to support the processes of 6–7 new manufacturing plants during the upcoming year, enhancing its production capability 300–350 million bottles of nano urea to meet increasing demand. IFFCO’s cloud adoption was driven by a need to innovate. The organization wanted capabilities for a dynamic business that can adapt to the changing needs of the market while growing fast. However, it was inhibited by rigid on-premises data center deployments and the overhead of maintaining legacy systems. IFFCO wanted to apply the elasticity and availability of cloud for improving overall performance of applications at lowest possible operational overhead. Lastly, IFFCO needed to provide the benefits of its technology to all its stakeholders, including employees, members, transporters, and farmers, some of whom have limited literacy. To accommodate all stakeholders, IFFCO wanted to add a voice interface to its applications.
Case Study
7-Eleven Philippines Enhances Customer Support with Freshdesk
7-Eleven Philippines, a pioneer of 24-hour convenience stores in the country, was facing challenges with its customer support system. The customer support was outsourced to an external vendor, which resulted in limited visibility into customer query patterns and performance metrics. The company had no transparency into the vendor's analytics and could not validate their reports. They also had no visibility into the volume of calls, number of abandoned calls, etc. due to the use of the vendor’s telephony solution. This lack of control and visibility into customer support led the team to decide to bring the entire function in-house. They began exploring helpdesk solutions that would enable them to build a strong in-house support team.
Case Study
Cloud4com: Delivering Efficient and Secure SAP HANA Cloud Services
Cloud4com, a leading provider of IT infrastructure and data center services, recognized the challenges and costs companies face when upgrading their on-premises infrastructure to meet the demands of SAP HANA in-memory technology. With the introduction of SAP HANA and SAP's decision to end support for all other databases from 2025, Cloud4com saw an opportunity to expand its services to a larger customer base. However, SAP HANA is a resource-intensive technology that requires companies to deploy powerful and costly hardware platforms. Businesses often overspecify the hardware, resulting in underutilization within the software's lifecycle. To capitalize on the opportunity presented by SAP HANA, Cloud4com aimed to create a cost-effective cloud platform for HANA and began working on obtaining the SAP Tailored Datacenter Integration (TDI) certification. A critical element was selecting the right operating system that would meet SAP’s standards and maximize the availability and performance of their customers’ SAP landscapes.
Case Study
BrewDog's Customer-Centric Approach in Times of Uncertainty
BrewDog, a Scottish-born craft beer business, faced a significant challenge during the COVID-19 pandemic. With their bars closed, the company saw a surge in online orders and customer inquiries. The customer service team, which handles all e-commerce customers and general brand-related queries, was overwhelmed with the sudden increase in activity. The team was dealing with up to 2000 tickets a day during the lockdown, a significant jump from the usual 150-200 tickets. The fast-paced nature of BrewDog's operations, with new projects and initiatives launching daily, further complicated the situation. The company's existing processes, which were fairly manual, were not equipped to handle this surge in volume. The challenge was to quickly adapt and streamline their customer service operations to continue providing excellent service during these uncertain times.
Case Study
Global Timeshare Company Accelerated Its Digital Marketing and E-commerce Engine
The client's go-to-market teams weren't accustomed to attracting new buyers in the digitally networked world. These prospects come from an evolving demographic — millennials and Gen Z who were increasingly adopting the new ways of evaluating options online and making reservations.There were three key challenges that the client was facing.Outdated and aging systems (legacy core)Inadequate web presence and e-Lack of predictive customer understanding and analytics
