Multinational Fast Food Corporation: Analytics Technical Architecture
Our client has become one of the leading multinational companies in the restaurant industry, managing a vast network of franchisees worldwide.
Challenge
To meet the reporting needs of restaurant management and franchisees, our client has invested heavily in data and analytics platforms. In 2023 they made the decision to shift their main analytics platform from MicroStrategy to Domo, to improve response times, reduce development costs and improve user experience.
As Domo’s premier integrations partner in Australia, 9X5 Consulting was approached to support this uplift.
Solution
The Fast Food Corporation’s existing reporting dashboards had grown from an original number of 250 cards, to well over 2000. Many of these reports had been created to solve ad-hoc issues, and were not known or shared outside of departmental teams.
9X5 Consulting initially conducted an audit of these reports, which looked at metrics used, data sources required, ETL requirements, report usage, sharing and privacy, and business requirements, creating a matrix of reports with an estimated effort to recreate per dashboard. This formed the basis of our scope of works, which was then presented to the client.
With a strong understanding of the business requirements and the capabilities of Domo, 9X5’s Architect started with an assessment of the current solution including data sources, ETL processes, data warehouses, BI tools, and reporting mechanisms.
9X5 identified technical debts and performance issues around the utilisation of Snowflake as a data store, so upgrading this was also included in scope.
Once this was completed, 9X5 then defined the target data architecture, data pipelines and ingestion methods as well as user access controls.
Impact
With the initial approach agreed upon, 9X5 have assmebled a large team of Domo and Snowflake Developers to undertake the large task of moving reporting Dashboards across to the Domo platform. Work is being conducted in sprints with dashboards and cards being validated before redeveloped, ensuring that we only redevelop cards being used, and ensure that only the right users have access.
Concurrently 9X5 is involved in establishing and conducting Domo training for staff across both head office, regional offices and stores and will continue these activities throughout 2024/25.
Client Overview
Our client has become one of the leading multinational companies in the restaurant industry, managing a vast network of franchisees worldwide.
They have achieved success through a mix of well-established brand identities, coupled with the implementation of unified global systems and support services.