Case study
Learning Progress in Real Time for a Global EdTech Platform
How SquareShift replaced a nightly batch BI process with real-time pipelines on Looker and GCP, so learners and managers finally see the same numbers as the web experience.
Book a session →
Client
A global EdTech company that offers an AI-powered learning platform to enterprises and government organizations.
Industry
Technology
Services
Stack
Looker · Google Cloud · Kafka · BigQuery · dbt
How SquareShift delivered it.
The challenge
The client is a global EdTech company offering an AI-powered learning platform to enterprises and government organizations. Learners and L&D managers needed to see activity and progress as it happened, but BI reporting ran on a nightly batch job, always a day behind, and numbers on the web page never matched the BI reports, undermining trust in both.
What we delivered
SquareShift's Looker-certified solution architects built a serverless blueprint architecture with the client, replacing the nightly batch job with real-time pipelines streaming data from every source. Insight now moves straight from the pipeline into the web experience, with Looker reports embedded directly instead of living in a separate reporting tool. The stack is Looker, Google Cloud, Kafka, BigQuery and dbt.
The outcome
Learners and L&D managers now see their activity and progress in real time, and web numbers finally agree with BI numbers, closing a gap that had never been resolved before. The data science team's models also have real-time data to work with for the first time.
Related Looker work: Looker Studio sales dashboards for a semiconductor maker and daily reporting for 1.5 million learners on Looker.
When a web page and a BI report disagree, nobody trusts either one. Feeding both from the same real-time pipeline is what actually restores confidence, not reconciling the numbers after the fact.
Data & Analytics Practice Lead, SquareShift
