CUSTOMER STORIES

KFC ENHANCES DATA SHARING CAPABILITIES AND IMPROVES REPORTING WITH SNOWFLAKE

Discover how KFC Australia uses Snowflake to improve actionable data sharing, collaboration and reporting capabilities.

KEY RESULTS:

70%

Fewer database operational costs

500K+

Order transactions processed daily

Data scientists looking at data on a laptop
KFC Logo
Industry
Retail & Consumer
Location
New York, NY

Growing a franchise worldwide

Story Highlights
  • Data sharing that enables informed decisions: Snowflake’s data sharing capabilities allow KFC to readily make key sales, inventory and operational data available to external parties, such as suppliers and agencies. The number of parties with which data is shared has grown from three to more than 30.

  • High-performance database platform with over 2 million transaction records: By building its database platform on Snowflake, KFC has created a powerful data management and analysis infrastructure that supports the company’s operational and marketing activities.

  • Significantly lower operational IT costs: Migrating all data to Snowflake has allowed KFC to reduce its database operation costs by 70%.

A high-performance platform for data management and data sharing

In May 2019, after evaluating a range of alternatives to its legacy database, the KFC IT team made the decision to migrate to Snowflake. “Snowflake appealed to us because we could see we would be able to undertake initial testing without incurring a lot of upfront costs,” says Bastos. “Also, we were already familiar with cloud platforms as we had been using Azure for some of our workloads. We could see, though, that Azure would not be the  best fit for our core database.” 

The Snowflake deployment began with a proof of concept that involved running the same set of reports that had proven too great a burden for the SQL database. Instead of the reports being delivered in hours or even days, they were generated in just 20 seconds—without requiring any additional steps to enhance the process. Once they were completed, the reports  could be generated almost instantly.

Significantly streamlined reporting

Once the Snowflake platform was fully operational, KFC’s IT team quickly began to notice significant benefits. 

In some ways, it’s not even fair to compare the performance of KFC’s legacy database with Snowflake. Snowflake is a totally different generation of technology for KFC, which now supports more than 10,000 data extractions and reports every day.

Greatly enhanced data sharing

Snowflake has also significantly improved the way in which KFC shares data with its franchisee partners and with other external parties who undertake analysis work. 

Prior to the deployment, data sharing required large data sets to be copied to an instance within Azure, which was then made available to approved parties. This was a cumbersome process that put a lot of strain on the in-house SQL database. 

With Snowflake, the same set of data is shared so there is no need to copy it or move it to a different location. It also ensures that all parties are looking at the most up-to-date data available.

At that time, Bastos was the only Data Architect in the IT team, and he was tasked with sharing data with external companies. “KFC’s data sharing processes changed from taking days to being completed in just seconds,” says Bastos. “This allows access to more data faster and allows us to achieve greater insights and enhance our advanced analytics capabilities.”

The shift to Snowflake has also resulted in a reduction in KFC’s overall database operational costs of around 70%.

KFC’s data sharing processes changed from taking days to being completed in just seconds. This allows access to more data faster and allows us to achieve greater insights and enhance our advanced analytics capabilities.”

Luis Bastos
Data Architect, KFC

Improved customer service

The Snowflake platform is also allowing KFC to improve its service to customers by better understanding their preferences. Data is collected securely from a range of sources, including the company's mobile app, the KFC website and in-store point-of-sale terminals.  

According to Bastos, “This allows us to build a profile of customers and gain an insight into their ordering habits. This, in turn, ensures that our menu of offerings is always in line with what our customers expect and want.”

Expanding use of predictive tools

In coming months, the KFC team plans to focus its attention on data science initiatives. The team intends to improve innovation levels within the company through the use of predictive and advanced analytics, which is anticipated to enhance internal automation processes. 

There are also plans to extend the partner ecosystem with access to data through Snowflake Secure Data Sharing. This will further increase efficiency and save time as data won’t have to be anonymized before it is used.

Now that we have all the power and scalability of Snowflake, we want to use our vast data sets to empower our internal users with artificial intelligence tools. Our aim is to transform our data-driven organization into one that is more AI-driven.”

Luis Bastos
Data Architect, KFC

Start your 30-DayFree Trial

Try Snowflake free for 30 days and experience the Data Cloud that helps eliminate the complexity, cost and constraints inherent with other solutions.