FRC Case Study – DataActs

Flow Research Collective

Harnessing the power of flow state

Introduction

Overview:

The Flow Research Collective is a research and training organization. Their mission: understand the science behind ultimate human performance and use it to train up individuals and organizations.

Objectives:

To enhance the data infrastructure and analytical capabilities of FRC by implementing a modern data stack, incorporating tools such as Google BigQuery, Dataform, and Google Data Studio. This setup enables robust data processing, seamless data transformation, and dynamic visualization of key business metrics. The objective of this integration is to provide accurate and timely business intelligence, facilitate data-driven decision-making, and support strategic initiatives. By leveraging advanced analytics and statistical methods, the goal is to answer critical business questions efficiently, build comprehensive dashboards, and drive insights to foster growth and innovation within the organization.

Methodology

Tools & Technologies:

Data Sources :

Marketing Data Sources : Meta Ads, Google Ads, Bing Ads, Youtub
Operations Data Sources : Hubspot , Samcart , Shopify , Google Sheets
Other Data Sources : Typerform, Google Search Console, Google Analytics

Data Connector :

Keboola & Fivetran

Data Transformation :

Dataform (Google Cloud PlatformTool)
SQL , Javascript and YAML

Data Visualization :

Streamlit
Metabase
ThoughtSpot

Processes:

To meet FRC’s needs, we began by thoroughly analyzing the existing data infrastructure and identifying key requirements for a modern data stack. In the first few months, we focused on setting up the foundation by implementing ETL pipelines to seamlessly integrate data from various sources into Google BigQuery. We then utilized Dataform to perform data transformations, ensuring data consistency and accuracy. Concurrently, we developed comprehensive BI dashboards tailored for the Sales and Marketing team as well as key business stakeholders, providing them with real-time insights and actionable metrics.

Following the successful implementation of the data stack, our efforts shifted towards addressing the analytics needs of team members. We actively collaborated with them to solve complex data queries, delivering precise answers and insights. Additionally, we created new charts and dashboards tailored to their evolving requirements, ensuring that all stakeholders had access to the information they needed to make informed decisions. This continuous engagement and adaptation fostered a data-driven culture within FRC, driving strategic growth and innovation across the organization.