Chick-fil-A Transforms Analytics with Alteryx and Amazon Redshift
Chick-fil-A has been a familiar brand across American cities for decades. What started out as a single Dwarf Grill in Hapeville, GA, in 1946 has grown to become the largest quick-service chicken restaurant chain in the United States, based on domestic annual sales. In 2015, annual sales exceeded $6 billion. The company has more than 2,000 locations in 43 states and Washington, D.C.1
Deeper Insights: Massive data stockpiles could finally be meaningfully incorporated into key business decisions.
Hours vs. Weeks: Time for all analytics efforts was cut drastically, from “previously impossible” to returning information in 20 seconds, freeing time for high-level exploration and innovation.
Repeatable Workflow: Chick-fil-A staff were freed from the need for extensive IT assistance and coding thanks to an intuitive user interface and the ability to easily join data from multiple sources.
Like so many mature companies with decades of expansion, Chick-fil-A’s data had become a patchwork of siloed pockets spread across the organization. Collective company data was often inaccessible to analytics staff, or required notable IT assistance. There were also frustrating instances of large transactional data sets going unused because even seasoned staff were uncertain how to realistically process them given the constraints of an aging legacy toolset. And as Chick-fil-A Manager of Supply Chain Analytics Justin Winter relates, the pressures of modern analytics had ultimately caught up with the company. “You have to constantly figure out how to reinvent. How do you reinvent as a leader, as an analyst, and also the tools in the system and the processes? How do you continue to innovate to stay on top of growth in the business?”
Regarding the supply chain department, Winter states, “the business is demanding the insight. Like tell me why this matters, point it out to me, and I want it real time and I have 45 other questions I want you to provide information for. So we really had to change and adapt to be able to answer these questions and more.”
Chick-fil-A analysts in the trenches felt that even the simplest data query had grown too time-consuming, and called for a solution that could deliver deeper insights fast. Also, many analysts felt particularly handcuffed by existing tools because they weren’t coders. They had lots of data, but couldn't use it effectively. The team wanted the ability to rapidly process large amounts of data without writing any code.
Winter didn’t want to introduce a tool that would complicate his staff’s lives and introduce even more complexity to Chick-fil-A’s existing analytics toolkit. He knew that Chick-fil-A needed to be able to easily join data from multiple sources and empower both data analysts and line-of-business users to perform their own analytics quickly and be able to explore their data more to enable innovation.
“We had all these reams of transactional data from stores and, literally, just had no way to do anything of any value with it. I suggested let’s figure out if in 24 hours, we can take all that data, load it into [Amazon] Redshift and have responsive reporting and analytics on that. And sure enough, in 24 hours our IT group, which has just been an incredible partner for us, actually pulled it off. It was great because they got all the data there, and you could get a response as long as you could write SQL code.”
The Chick-fil-A team has marketing analysts who have smart business skills, but are not trained in complex SQL and hierarchical queries. “We sat down to answer a specific question, and it would take four hours with any one of the three tools that we were using. How do you connect the skills that the analyst has with the availability of the systems? We tried directly connecting Tableau to it, but when you try to do a filter on Tableau on five billion records, it just doesn’t work well.”
Winter remembered hearing about another company using Alteryx to prep, blend, analyze, and do analytics on data in preparation for using Tableau to report on it, and he decided to download a free trial of Alteryx. “I built a workflow in 10 minutes on our first day that queried five billion records in 20 seconds. And immediately I realized there is something going on here that is really cool and powerful.” Through this exploration and discovery, Winter and his team committed to adopt Alteryx and test the collective ways it could be used across the organization.
Winter’s team was also excited to find the necessary path for them to fluidly integrate Amazon Redshift and Tableau reporting. They use Amazon Redshift for data warehousing, Alteryx for extraction and manipulation, and then Tableau Server for presentation.
“That first risk score in Alteryx took me three hours to build. And that was while we were in our Alteryx trial period. We were trying to make a business case to the C-level staff to show the real value in this tool.”
Manager, Supply Chain Management
Watch Justin Winter’s presentation from Inspire 2016.
Alteryx has transformed the amount of time required for core analytics activities, easing Winter and his team’s workflow and enabling rich, new insights by opening up more data for effective cleansing and blending. Winter relates, “We’re creating dashboards in minutes to hours, versus a six-month development cycle. This is game changing. Everything automatically refreshes so analysts are focusing more on the creation, rather than on the refreshing activities. It’s really just changed the way that we work from a business analytics standpoint, which has been great.”
Ultimately, Winter and his colleagues are saving time and energy, and love their jobs even more than before. Winter said, “I’m a father of four little kids. Alteryx has been huge in not just my professional life, but also in my personal life, making sure that there’s balance and ability to scale since both aspects are really important to me.” Plus, Alteryx is helping ensure stability and growth for all of their analytics projects, including developing and launching the new Chick-fil-A One™ loyalty app. Now poised for even more innovation and discovery, Chick-fil-A is entering the next chapter of data-driven success.