Analytical reports preparation was carried out with the help of complex files created on the basis of Microsoft Excel. They were very difficult to make changes within, and their performance left much to be desired. The Marketing Director struggled to understand the impact of marketing campaigns, what menu items were ordered together most regularly and how each location performed against its counterparts. Maxim knew exactly what BI requirements that Burger King would need.
Both Maxim and Qlik wasted no time in getting to work: creating multiple sales analysis applications. The creation of these applications was no small task: the checks analysis app spanned 20 million rows of data. Information on transactions as far back as 2014 totaled a staggering 170 million rows. Aggregated data on each of the regional restaurants as far back as 2011 occupied 600,000 more. Despite this daunting task: Qlik opened up a whole new view into the business.
“The solution turned out to be very flexible and easily customized to suit our requirements. Now we can see the breakdown of revenue by receipts or separate meals, carry out a comparative analysis of each restaurant for the selected period or all of the restaurants in the region."
With these new parameters established for sales and finance, other departments within Burger King sought to find new ways to take advantage of singular access to all this data. Here are just a few they have planned:
This singular source of truth has not only allowed for better data access and insights, but now everyone internally from managers to executives can truly “have it their way”.