After struggling with disparate internal and external reports on sales, marketing and customer insights, our client (a leading global fast-food brand) determined the need to build an in-house reporting capability.
Unsure of where to start and what was feasible, the company reached out to the team at One51 for guidance.
We set out to design and deploy an end-to-end data solution to deliver business-critical insights right to decision makers’ fingertips.
“Siloed reporting was impeding data-driven decision making.”
Turning billions of records across disparate source systems into easy-to-use reporting
It was essential to understand these figures during ad campaigns to gauge whether they achieved the expected targets.
Our team started by plugging all the necessary datasets from disparate sources into a data warehouse to deliver the data capability. We leveraged a number of best of breed technologies, such as Fivetran to ingest data from sources such as Google Analytics and the Google and Apple App stores; Snowflake, for the Event Stream Processing (ESP) of billions of records originating from both the mobile app and the e-comm website.
Another critical component of the project was the implementation of an intuitive dashboard for users to access the data. Given the sheer volume, the dashboard needed to organise information in a consistent and user-friendly way.
We collaborated with stakeholders to provide guidance on the best visualisations for specific metrics, ensure they wouldn’t be overloaded with unnecessary metrics, and interpret relevant information quickly to make decisions in real-time.
The key component for this solution was Fivetran. Fivetran enabled rapid data integration from different sources into the Snowflake data warehouse, which reduced implementation times and eliminated the need for handmade coding. It also allowed our team to focus on the correct implementation of metrics and visualisations for improved reporting and analytics.