WELBEE PARTNER WITH RITTMAN ANALYTICS TO BRING AI-DRIVEN INSIGHTS TO THEIR Edu Intelligence platform

TECHNOLOGIES USED

Tim Handley,
Chief Product and Technology Officer, Welbee

“Working with Rittman Analytics to develop the AI capability of our new Edu Intelligence platform has been transformative for Welbee and our customers”

VITAL STATS

Website:
https://welbee.co.uk/

Industry:
EduTech

Company size:
2-10 employees

Headquarters:
Liverpool, United Kingdom

RITTMAN ANALYTICS SERVICES

Data Analytics
Data Enablement
Generative AI

THE DOWNLOAD

Welbee is a multi-award-winning company that helps schools improve staff well-being and transform school culture. 

They offer a systemized process, "The Welbee Way," to help schools measure and track, take action, and embed well-being into their culture. Their new platform, Welbee Insights with Edu Intelligence, lets users create, run and analyse any survey for staff, students or parents. 

Welbee offers a suite of products to help schools achieve this goal including Welbee Survey,  an evidence-built survey that uses the Health and Safety Executive’s six Management Standards for assessing workplace well-being and managing the risks of workplace stress. 

Schools receive scores against the six Management Standards, benchmarks against other schools and cross-sector organization and crucially,  a set of recommended actions.  In Welbee Insights, schools can analyse their survey data alongside all data they already own, for example attendance, special education needs or attainment. 

THE CHALLENGE

Although Welbee's staff well-being survey product was already highly successful, they identified an opportunity to make their data more accessible and actionable for users. Their goal was to deliver the same award-winning insights and recommendations from their Wellbeing product within the Edu Intelligence platform.

Their existing process relied heavily on manual analysis and interpretation of survey results, which created delays for schools eager to take action based on their data. Welbee also wanted to empower schools with more dynamic and interactive ways to explore their data beyond static charts.

Achieving this required moving beyond traditional reporting methods by leveraging AI to create a conversational experience that could uncover hidden trends and deliver actionable, data-driven recommendations for improvement.

Finally, Welbee aimed to integrate the new AI-powered analysis into a chatbot interface within their existing Looker platform, ensuring a seamless and intuitive user experience within a familiar environment.

THE SOLUTION

Rittman Analytics partnered with Welbee to create an AI-powered proof of concept (POC) that added AI-driven insights into  Welbee's Edu Intelligence platform. This POC served as the foundation for Intelligent Ed, an AI-powered staff well-being assistant for the education sector. 

The POC solution was made-up of three core components:

  1. AI-Driven Pre-Analysis: This component automated survey data processing using Google BigQuery, and Vertex AI. It leveraged Google's Gemini 1.5 large language model (LLM) to generate insights and highlight differences between subgroups within survey respondents. This automated pre-analysis was integrated into Welbee's existing data pipeline, orchestrated by Google Cloud Composer, ensuring real-time insights as soon as a survey closed.

  2. Text-to-SQL Chatbot: Rittman Analytics used Langchain and Langsmith to develop a text-to-SQL agent that allowed users to query survey data conversationally. The agent interpreted natural language questions, broke them down into relevant components, and generated SQL queries to retrieve data from BigQuery. This functionality was deployed as a Cloud Function triggered by a Pub/Sub message from Welbee's data pipeline. Welbee developed the user-facing chatbot interface using React.

  3. RAG Integration: This component integrated Welbee's existing RAG (Retrieval-Augmented Generation) system with the chatbot, as part of a wider LangGraph implementation. RAG enhanced the chatbot's responses by retrieving relevant contextual information from external knowledge sources, such as Welbee's Wellbeing Toolkit. This integration enabled the chatbot to provide more comprehensive answers and actionable suggestions.

Built on  Google Cloud Platform (GCP) technology, Welbee's survey data was stored and processed in BigQuery while Vertex AI provided the machine learning capabilities for AI-driven pre-analysis and natural language understanding for the chatbot. Cloud Functions served as the serverless execution environment for the text-to-SQL agent, triggered by Pub/Sub messages from Welbee's data pipeline, which was orchestrated by Cloud Composer. Welbee's existing RAG system was integrated to provide access to external knowledge sources, enriching the chatbot's responses.

FASTER, MORE ACTIONABLE INSIGHTS

“Rittman Analytics’ expertise in AI and Google Cloud allowed us to help our customers unlock the true potential of their data, delivering faster, more actionable insights.  The Ritman team is a pleasure to work with, and they have a great level of knowledge, skill, and expertise in all things data analytics. We are thrilled with the results of this project and look forward to continuing to work with the Ritman team in the future” - Tim Handley, Chief Product and Technology Officer, Welbee

BENEFITS DELIVERED

The collaborative nature of the project leveraged the combined expertise of Rittman Analytics in AI and Google Cloud Platform with Welbee's in-depth knowledge of their platform and users' needs, delivering the following benefits to the business:

  • Faster Time to Insights: The AI-driven pre-analysis eliminates manual analysis and provides insights immediately upon survey closure, allowing schools to act on their data more quickly, leading to faster improvements in staff well-being.

  • Enhanced User Experience: The Text-to-SQL chatbot enables users to interact with their data conversationally and obtain insights in real-time without needing technical expertise. This intuitive approach to data exploration empowers schools to make better use of their survey results.

  • Deeper and More Actionable Insights: The combination of AI-powered analysis and RAG integration provides richer context and surfaces hidden trends that might be missed with traditional reporting. This leads to more informed decision-making and targeted interventions to address specific areas of concern within a school.

  • Competitive Advantage: Intelligent Ed, its underlying concepts proven by this POC, will position Welbee as an innovator in the education technology sector by offering a cutting-edge solution that sets them apart from competitors. 

INTERESTED? FIND OUT MORE

Rittman Analytics is a boutique analytics consultancy specializing in Google Cloud Platform, modern data stack and generative AI technologies. Our services can help you create, summarise, discover and automate your discovery of analytics insights, augmenting your data analysis capabilities while governing your data and AI models responsibly.

If you’re looking for help building out your data team and generative AI vision then contact us now to organize a 100%-free, no-obligation call — we’d love to hear from you!

MORE CASE STUDIES