Customer Stories / Software & Internet
Deputy Helps Customers Reduce Data Query Time by 70% and Improve Business Insights Capabilities with Amazon OpenSearch Service
Deputy uses AWS to drive 70 percent faster data request times for customers, scale to support hundreds of millions of data points, save time by eliminating management and maintenance, and lower costs. Deputy, based in Australia, provides software that automates scheduling and facilitates workforce management for global customers.
More than 320,000 workplaces and 1.3 million shift workers in over 100 countries use Deputy software to automate scheduling and facilitate workforce management. Many of these customers, including Fortune 500 companies, use Deputy’s Business Insights Dashboard to access analytical data about their organization. Caesar Li, senior product manager at Deputy, says, “Business Insights uses historical information to forecast projected future sales, allowing customers to make smarter, data-driven scheduling decisions.” The tool integrates point-of-sale data with wage and shift data, with up to 4,000 monthly active users depending on these combined data sets to streamline their scheduling.
However, the solution's MySQL-based database struggled to scale as the business experienced rapid growth and data sets expanded to millions of records. This resulted in customers reporting delays in page load times. Jack Marchant, technical lead at Deputy, says, “Our customers experienced slow page loading times for their data, sometimes waiting 2 minutes for queries to complete.” This load time delay was unacceptable for customers requiring fast data snapshots. “Our customers benefit from viewing all their data in one place so they can reduce labor-intensive, manual scheduling processes. They need to visualize their weekly data in under 30 seconds to update their employee work schedules,” Marchant says.
Opportunity | Improving Application Performance with Amazon OpenSearch Service
This is just the beginning. We have so many other use cases to solve with Amazon OpenSearch Service, especially unlocking predictive analytics and ML capabilities for scheduling.”
Vice President of Engineering, Deputy
Solution | Driving 70% Faster Data Request Times
Outcome | Saving Time and Money by Eliminating Management and Maintenance
To learn more, visit aws.amazon.com/opensearch-service/.
Read about the Deputy OpenSearch service here, visit https://www.deputy.com/features/demand-forecasting
Deputy is on a mission to Simplify Shift WorkTM for millions of workers and businesses worldwide. The company streamlines scheduling, timesheets, tasks, and communication for business owners and their workers. More than 300,000 global workplaces use Deputy to schedule and effectively communicate with employees, providing millions of shift workers with more flexibility and control over their schedules.
AWS Services Used
Amazon OpenSearch Service
Amazon OpenSearch Service makes it easy for you to perform interactive log analytics, real-time application monitoring, website search, and more. OpenSearch is an open source, distributed search and analytics suite derived from Elasticsearch.
AWS Lambda is a serverless, event-driven compute service that lets you run code for virtually any type of application or backend service without provisioning or managing servers.
Amazon Kinesis Data Streams
Amazon Kinesis Data Streams is a serverless streaming data service that makes it easy to capture, process, and store data streams at any scale.
Organizations of all sizes across all industries are transforming their businesses and delivering on their missions every day using AWS. Contact our experts and start your own AWS journey today.