Pfizer is one of the world’s largest pharmaceutical companies, with revenue of $53.6 billion in 2018.
“Amazon Redshift enables us to provide scientists with near real-time analysis of millions of rows of manufacturing data generated by continuous manufacturing equipment, with 1,600 data points per row. Redshift enables us to query our high-volume data at 10 times the performance of our prior data warehousing solution. Because of the performance and scale Redshift provides, we have increased our manufacturing efficiency by optimizing future manufacturing runs. In addition, we have reduced the time needed to gather and prepare data for regulatory submissions by a factor of five and now avoid repeated experimentation, which would otherwise have taken an extra three weeks of scientists’ time.”
Jim Silva, Director Business Partner, Pfizer Inc.
McDonald’s is one of the world’s leading global foodservice retailers with over 37,000 locations in 120 countries. McDonald’s uses Amazon Redshift to run global workloads for operational reporting and dashboards.
“Amazon Redshift enables faster business insights and growth, and provides an easy-to-manage infrastructure to support our data workloads. Redshift has given us the confidence to run more data and analytics workloads on AWS and helps us meet the growing needs of our customers.”
Abhi Bhatt, Director Global Data & Analytics, McDonald’s
FOX Corporation produces and distributes content through some of the world’s leading and most valued brands, including: FOX News, FOX Sports, the FOX Network, and the FOX Television Stations. FOX empowers a diverse range of story creators to imagine and develop culturally significant content, while building an organization that thrives on creative ideas, operational expertise and strategic thinking.
“Amazon Redshift allows us to ingest, optimize, transform, and aggregate billions of transactional events per day at scale, coming to us from a variety of first and third party sources. We query live data across our data warehouse and data lake, and now with the new Amazon Redshift Federated Query feature we can easily query and analyze live data across our relational databases as well. Our petabyte scale data is rapidly growing, and with the innovation in Amazon Redshift RA3 instances and AQUA (Advanced Query Accelerator) for Amazon Redshift we’re thrilled about the prospect of getting 10x faster performance for our most demanding workloads, while keeping our costs flat. AQUA for Amazon Redshift is a great example of how AWS innovates across every layer of the stack to deliver the best solution for their customers.”
Alex Tverdohleb, Vice President Data Services, Consumer Products & Engineering, FOX Corporation
Amazon.com, one of the world’s largest e-commerce companies, with over $230B in annual revenues, recently migrated all their analytical workloads from Oracle to a data lake architecture on AWS.
“Amazon Redshift has been a key component of our successful migration off Oracle and has enabled us to significantly reduce the cost of our analytics while scaling to support one of the largest analytical workloads in the world. We currently have over 500PB of data in our Redshift clusters and our Amazon S3 data lakes that we analyze to deliver mission critical insights to support all parts of the company. Working in partnership with AWS, we continue to leverage new features such as Redshift Spectrum. Integration with Redshift Spectrum has significantly reduced the cost of analyzing our largest datasets while providing consistently fast performance.”
Dave George, VP of Technology Software & Development, Amazon.com
NTT DOCOMO is the largest mobile service provider in Japan, serving more than 73 million customers.
“Migrating to Amazon Redshift in 2014 allowed us to scale to over ten petabytes of uncompressed data with a 10x performance improvement over our prior on-premises system. Today, it is the center of our analytics environment. Since we started using Amazon Redshift, both our data and number of users have increased dramatically. We are impressed with the flexibility and ease of use, even as we scale users and data. The new Amazon Redshift Data Lake Export feature allows us to simplify our workflows to make use of more data across our data lake. We are excited about the new Amazon Redshift RA3 instances with Managed Storage, enabling us to scale compute and storage separately. We also look forward to realizing the benefits of AQUA, Advanced Query Accelerator, for Amazon Redshift as we continue to increase the performance and scale of our Amazon Redshift data warehouse. We appreciate AWS’s continual innovation on behalf of its customers.”
Takaaki Sato, General Manager of Service Innovation Department, NTT DOCOMO
Intuit is a leading provider of financial management software for consumers, small businesses, and accounting professionals.
“We moved our mission-critical workloads to Amazon Redshift from our on-premises environment to speed development, innovate faster, and better solve customers’ needs. Redshift’s performance allows us to scale our workloads by over 3x in 2019 at no additional cost. With new features such as Auto-Vacuum and Auto-Analyze, we’ve been able to eliminate all of our database maintenance jobs, enabling our team to focus on our customers. More teams at Intuit are looking to use Redshift for an ever-wider array of business opportunities because of its exceptional performance, cost, and elasticity.”
Jason Rhoades, System Architect at Intuit
Yelp’s mission is to connect people with great local businesses; to do so, data mining and efficient data analysis is important in order to build the best user experience.
“We continue to adopt new Redshift features and are thrilled with the new RA3 instance type. We have observed a 1.9x performance improvement over DS2 and 1.5x performance improvement over DC2 in our workload, while keeping the same costs and providing scalable managed storage. This allows us to keep pace with explosive data growth and have the necessary fuel to train our machine learning systems.”
Stephen Moy, Software Engineer, Yelp
Duolingo is the most popular language-learning platform and the most downloaded education app in the world, with more than 300 million users. The company's mission is to make education free, fun and accessible to all.
“We use Amazon Redshift to analyze the events from our app to gain insight into how users learn with Duolingo. We load billions of events each day into Amazon Redshift, have hundreds of terabytes of data, and that is expected to double every year. While we store and process all of our data, most of the analysis only uses a subset of that data. The new Redshift RA3 instances with Managed Storage deliver 2x performance for most of our queries compared to our previous DS2 instances based Redshift cluster. The Redshift Managed Storage automatically adapts to our usage patterns. This means we don't need to manually maintain hot and cold data tiers, and we can keep our costs flat when we process more data.”
Jonathan Burket, Senior Software Engineer, Duolingo
Intermix.io is an analytics platform used by data professionals across some of the world’s most recognizable brands to understand the engagement, cost, and performance of data products built on top of data warehouses.
“Amazon Redshift continues to be the fastest and most popular cloud data warehouse. Our customer’s data volume is growing significantly faster than ever before. They need to get data into the warehouse faster, and store more data without sacrificing cost or performance. The new RA3 instance is a game changer. According to our benchmark of RA3.12xl versus the Amazon Redshift ds2.8xl instance, RA3 improves data ingest speed by over 2x, while doubling storage capacity, for the same price, (see results here). With RA3, handling growing data and query volume becomes a non-issue so customers can focus on building great analytics solutions.”
Paul Lappas, CEO, intermix.io
Western Digital (WD) is a leading global data storage brand that empowers users to create, experience, and preserve digital content across a range of devices. WD enables users to be in control and smartly save what matters to them most in one secure place.
“At WD we use Amazon Redshift to enable the enterprise to gain value and insights from large, complex, and dispersed datasets. Our data is nearly doubling every year and we run six Redshift clusters with a total of 78 nodes and 631+ TB of compressed data stored to get insights that our business analysts and leadership depend on. The new Redshift RA3 instances offer us the ability to process our growing data more cost-effectively while we double our storage capacity compared to our previous Redshift cluster. We also like that our ETL, BI, and data ingestion process did not have to change to take advantage of the RA3 instances with Managed Storage.”
Fayaz Syed, Sr. Manager, Big Data Platform, Western Digital
Sophos is a worldwide leader in next-generation cybersecurity.
“Amazon Web Services, including Amazon Redshift, give us the power to make live data generated by our range of next-gen security solutions available to more than 409,000 organizations for analysis. The new Federated Query feature in Amazon Redshift could help us take this to the next level, allowing us to query data directly across our Aurora and RDS PostgreSQL databases without having to setup workflows for data movement. We’re excited to see how this could speed up our time to insight and help to make it easier to incorporate the most up to date data from a number of transactional databases with the data in our data warehouse and our data lake.”
John Peterson, Vice President, Central Content Group, Sophos
All Nippon Airways (ANA) is Japan’s largest airline, operating domestic and international routes.
“We use Amazon Redshift to analyze ANA’s international and domestic flight reservations, ticket issuing and boarding information, aircraft operation records, and cargo transportation records. Multiple divisions of ANA are able to analyze all of our data in Amazon S3 with Amazon Redshift Spectrum, enabling us to immediately generate unique insights that differentiate our business.”
Hajime Fudeshima, director of Business Intelligence, Innovation, and IT Strategy at ANA
Equinox Fitness is an American luxury fitness company with more than 145 locations within every major city across the United States in addition to London, Toronto, and Vancouver. Equinox Fitness migrated to Amazon Redshift to analyze their clickstream data.
“Moving to Amazon Redshift has helped us reduce our overall maintenance costs by nearly 80% when compared to our legacy data warehouse. By leveraging Redshift Spectrum’s ability to query data directly in our Amazon S3 data lake, we have been able to easily integrate new data sources in hours, not days or weeks. This has not only reduced our time to insight, but helped us control our infrastructure costs. Redshift requires very little maintenance, to the point where we don’t even have a dedicated administrator and spend less than an hour a month on maintenance and administration.”
Elliott Cordo, VP of Data Analytics, Equinox Fitness
Redfin is a technology-powered real estate brokerage, combining its own full-service agents with modern technology to redefine real estate. Redfin can innovate quickly and cost effectively while managing billions of property records.
“Amazon Redshift provides the core analytics infrastructure that we rely on. Using the Elastic Resize feature that was released last year, we can optimize our performance by easily scaling up our cluster when faced with increased demands and scaling down during off-peak hours. Amazon Redshift’s ability to query data across our Redshift cluster and our Amazon S3 data lake, gives us a single view of all our data and makes it easy for our analysts to gain the insights they need seamlessly and quickly.”
Yong Huang, Director of Big Data and Analytics, Redfin
Tableau’s leading analytics platform helps customers derive insights from their data stored within Amazon Redshift.
“Amazon Redshift is one of our customers’ most commonly selected data sources, so we know firsthand the power it provides, enabling customers to create a massively scalable data warehouse with just a few clicks. We are proud to collaborate with the Amazon Redshift team to ensure an optimal customer experience when leveraging Tableau to gain insights that help them drive their business. We’re excited to see the rapid innovation and continuous improvements in performance and scale by the Redshift team and look forward to working together to help more customers realize the power of data.”
Brian Matsubara, Senior Director of Global Technology Alliances at Tableau Software
Informatica provides innovative capabilities to accelerate customer adoption of cloud analytics with AI-driven automation of data management including data migration, data ingestion, data integration, and data quality.
“Informatica Intelligent Cloud Services is loading more than one trillion transactions per month to Amazon Redshift and we are seeing tremendous joint customer momentum and growth. We are excited to leverage the dramatic performance improvement and query throughput increases the Redshift team has delivered as they enable our customers to execute analytics at scale, minimize time to insight, and help our customers accelerate their data-driven digital transformations. The improvements over the last two years have enabled us to grow with confidence knowing that Redshift’s performance will scale as we grow.”
Ronen Schwartz, Senior Vice President and General Manager of Cloud, Big Data, and Data Integration at Informatica
Delivery Hero is a Berlin-based food delivery service that operates in over 40 countries, delivering more than one million orders a day.
“We aggregate over 10 terabytes daily from a diverse set of data sources and APIs from around the world into our Amazon Redshift data warehouse running on AWS. Our daily processing workload has increased by 50 percent over the past 12 months but the performance improvements released by the Redshift team over the same time period have meant that we are actually processing data faster than before and haven’t had to increase the size of our cluster. This has allowed us to stay well within our projected budget while improving our data delivery SLAs.”
Kevin Viraud, Principal Data Engineer (International) at Delivery Hero
Periscope Data helps data professionals across some of the world’s most recognizable brands get full control over the analytics lifecycle — including ingestion, storage, analysis, visualization, and reporting — and gives line-of-business owners and non-technical users the ability to use data to quickly answer questions.
“We’re here to create a more data-driven world, where everyone can understand and unlock the full potential of their data. We operate hundreds of Redshift clusters running tens of millions of queries per day, and our workloads can fluctuate significantly throughout the day. With Concurrency Scaling, Amazon Redshift makes it easy for us to efficiently add query capacity and enables us to deliver a consistently great experience to all of our customers, at any concurrent query load.”
Tom O’Neill, Co-Founder and CTO of Periscope Data
Selected This is My Architecture videos
Tom O'Neill from Periscope Data shows us how they built a data ingestion and modeling engine using the power of Amazon Redshift. Their architecture enables CEOs and data analysts to analyze billions of rows of data at the speed of today's business.
Jun from NTT DOCOMO explains how they built secure and scalable data warehouse to handle over four petabytes of data. You will learn about how to satisfy both security and scalability requirements.
Learn how the London Stock Exchange Group (LSEG) built and secured a data warehouse and a front-end API using Amazon Redshift. The data warehouse stores 20 years of historical data.
Jon explains how Betterment supports advanced metrics and data analysis with Redshift. Learn how they stream data from multiple apps with Kinesis, process with Lambda, and store data in Redshift and Glacier.
Bruno shows us how iflix uses Amazon Redshift to enable real-time streaming analytics using Hadoop, Spark, and Presto and reduce ETL processing time by 40%.
Malaya shares how Manthan built a serverless analytics pipeline for real-time inventory management using Kinesis, DynamoDB, Lambda, API Gateway, RDS MySQL, ElastiCache and Redshift.