About the Customer
CampusIL is Israel’s national digital learning platform, led by the Israel National Digital Agency, set out to strengthen its data-driven decision-making capabilities. It provides open, high-quality online courses to millions of learners, teachers, and organizations nationwide.
Through a modern, data-driven approach, CampusIL enables personalized learning experiences, supports educational institutions with rich analytics, and fosters lifelong learning for students and professionals.
Customer Challenge
As a growing online education platform, CampusIL generates an enormous amount of learning data — from user engagement, course activity, and content interaction.
To manage and analyse this data, CampusIL, in collaboration with MidLink Cloud’s team, had already deployed a powerful Business Intelligence (BI) environment built on a customized version of the OpenEdx Aspects project. This implementation captures every student event from the CampusIL platform and stores it in ClickHouse, while Apache Superset provides advanced data visualization and dashboarding capabilities.
While this large-scale BI system delivered valuable insights, the analytics teams at CampusIL faced several challenges:
- Complex Querying: Creating new dashboards and visualizations in Superset required SQL and ClickHouse expertise, limiting data-driven exploration to technical users.
- High Data Volume: The platform’s large stream of learning events – representing millions of interactions – made manual query building slow and error-prone.
- Static Insights: Users wanted a more dynamic, conversational way to request insights without navigating Superset’s interface or writing queries.
CampusIL sought a trusted partner, MidLink Cloud, to extend its BI environment with an AI-driven assistant that could automatically generate, validate, and execute data queries – making analytics accessible to everyone while maintaining full security and compliance.
Partner Solution
MidLink Cloud partnered with CampusIL to design and deploy an intelligent, AI-assisted analytics solution that integrates AWS Bedrock with Apache Superset and ClickHouse, seamlessly extending the existing Aspects-based BI platform. Through this integration, users can simply use the chat prompt within Superset to generate charts, insights and visualizations based on real-time data stored in ClickHouse, without needing to write any SQL queries.
The implementation included:
- AI Chart Assistant: Leveraging AWS Bedrock’s generative AI capabilities to interpret natural-language prompts from Superset users and automatically generate accurate ClickHouse queries and Superset charts and insights.
- Seamless Integration: Building a modern solution tightly integrated into the existing Apache Superset environment of CampusIL. This enables users to interact with AWS Bedrock through a chat prompt (based on a React frontend and Python backend) directly within the Superset UI.
- Automated RAG Pipeline: Implementing a cron-based Retrieval-Augmented Generation (RAG) process that continuously updates the AI’s knowledge-base with the latest ClickHouse schema and metadata, ensuring accurate and context-aware query generation.
- Data Connectivity & Governance: Enforcing secure, role-based access between Bedrock, ClickHouse, and Superset, fully aligned with CampusIL’s data governance and privacy standards.
- Data Residency & Privacy: Ensuring that all data processing remains within AWS boundaries and that no sensitive educational data leaves the environment.
- Automation & Scalability: Streamlining DevOps workflows to support continuous schema ingestion, AI updates, and analytics at scale.
Results & Benefits
The AI-powered solution, which was deployed to production in July 2025, delivered transformative results for CampusIL:
- Faster Insights: Administrators can now generate complex charts and insights using natural language, dramatically reducing time-to-insight.
- Democratized Data Access: Non-technical users can easily explore data without writing SQL, promoting a data-driven culture across CampusIL.
- Up-to-Date Knowledge: The automated RAG pipeline keeps the AI model synchronized with the latest database schemas and datasets.
- Improved Efficiency: Reduced dependency on BI developers for dashboard creation and query debugging.
- Future-Ready Foundation: The scalable, AWS-native architecture supports future enhancements such as multi-language support, automated dashboard recommendations, and real-time analytics.
“The insights made available to the CampusIL team and its partners enable maximization of pedagogical investment by identifying the preferred courses. Thus, the preferred ones can be further refined, invested in, and replicated to create future offerings. This directly enhances CampusIL’s ability to optimize its active courses catalogue, thereby increasing the number of learners and encouraging more active learning. Ultimately, this supports CampusIL’s broader vision of reducing educational gaps across diverse populations.” Shachar Prizat, Technology & Software Development Manager at Campus IL at Israel National Digital Agency
About the Partner – MidLink Cloud
MidLink Cloud specializes in Cloud Data Management, Big Data & AI Cloud, and Cloud Modernization on AWS. Its customer-centric approach combines technological excellence with tailored managed services and a culture of continuous learning.
By leveraging deep AWS expertise and a focus on data-driven innovation, MidLink Cloud empowers public sector and government entities and institutions as CampusIL to unlock the full potential of their data ecosystems and accelerate innovation through the cloud.