Building with the WrenAI API: Applications, Charts, and NL to SQL Training Course
The WrenAI API serves as a robust interface for converting natural language into SQL queries, facilitating the creation of bespoke applications, and embedding charts directly into internal platforms.
This instructor-led, live training session (available online or onsite) is designed for intermediate-level engineers aiming to leverage the WrenAI API for practical implementations, encompassing SQL generation, data visualisation, and application integration.
Upon completing this training, participants will be equipped to:
- Authenticate and link applications to the WrenAI API.
- Generate SQL queries from natural language prompts.
- Design and embed charts using specific API endpoints.
- Integrate WrenAI solutions into backend systems and internal tools.
Course Format
- Interactive lectures and discussions.
- Practical exercises involving API calls and integrations.
- Hands-on projects that connect applications, visualisations, and data pipelines.
Customisation Options
- For those seeking a tailored training experience for this course, please contact us to make arrangements.
Course Outline
Introduction to the WrenAI API
- Overview of API features and capabilities.
- Basics of authentication and security.
- Navigating the API documentation.
Working with Data and SQL Generation
- Submitting natural language queries.
- Interpreting and validating the generated SQL.
- Optimising SQL outputs for performance.
Building Applications with the API
- Connecting backend services to WrenAI.
- Developing data-driven endpoints.
- Implementing error handling and logging.
Charting and Visualisation via API
- Retrieving chart objects through the API.
- Embedding charts within internal applications.
- Customising chart appearance and interactivity.
Integration with Internal Tools
- Embedding dashboards into team portals.
- Automating workflows using WrenAI endpoints.
- Use cases for operations and reporting teams.
Advanced Usage and Scaling
- Handling batch queries and bulk data processing.
- Managing concurrency and rate limits.
- Scaling integrations within enterprise environments.
Security and Governance
- Managing API keys and permissions.
- Audit logging and compliance considerations.
- Best practices for secure integrations.
Future Roadmap and Extensions
- AI-assisted enhancements in query generation.
- Extending applications with advanced endpoints.
- Exploring upcoming WrenAI features.
Summary and Next Steps
Requirements
- A foundational understanding of REST APIs.
- Experience working with SQL databases.
- Familiarity with backend programming languages.
Target Audience
- Backend engineers.
- Platform engineers.
- Teams responsible for internal tools.
Open Training Courses require 5+ participants.
Building with the WrenAI API: Applications, Charts, and NL to SQL Training Course - Booking
Building with the WrenAI API: Applications, Charts, and NL to SQL Training Course - Enquiry
Building with the WrenAI API: Applications, Charts, and NL to SQL - Consultancy Enquiry
Upcoming Courses
Related Courses
Governance and Security Patterns for WrenAI in the Enterprise
14 HoursWrenAI is an AI-driven analytics platform built to link data, model insights, and create dashboards. In enterprise settings, strong governance and security measures are essential for ensuring safe and compliant implementation.
This instructor-led, live training (available online or onsite) targets advanced enterprise professionals looking to deploy governance, compliance, and security patterns for WrenAI on a large scale.
Upon completing this training, participants will be able to:
- Design and implement permissioning models within WrenAI.
- Apply auditability and monitoring practices to meet compliance requirements.
- Establish secure environments with enterprise-grade controls.
- Safely roll out WrenAI across large organisations.
Course Format
- Interactive lectures and discussions.
- Hands-on labs focused on governance and security configurations.
- Practical exercises simulating enterprise rollout scenarios.
Course Customisation Options
- To request customised training for this course, please contact us to arrange.
Modernizing Legacy BI with WrenAI: Adoption, Migration, and Change Management
14 HoursWrenAI empowers organisations to transition from static dashboards to conversational analytics and embedded generative BI. Achieving this shift demands thoughtful adoption planning, asset migration, and robust change management strategies.
This instructor-led, live training (available online or onsite) is tailored for intermediate-level BI and data platform professionals seeking to modernise their legacy BI systems using WrenAI.
Upon completion of this training, participants will be equipped to:
- Assess legacy BI environments and pinpoint opportunities for modernisation.
- Plan and execute the migration from static dashboards to WrenAI.
- Implement conversational analytics and embedded GenBI capabilities.
- Drive organisational change management efforts for BI modernisation.
Course Format
- Interactive lectures and discussions.
- Practical exercises focused on migration and adoption planning.
- Hands-on labs covering conversational analytics and embedded GenBI.
Customisation Options
- For bespoke training requests, please reach out to us to make arrangements.
Quality and Observability for WrenAI: Evaluation, Prompt Tuning, and Monitoring
14 HoursWrenAI facilitates the conversion of natural language into SQL and provides AI-driven analytics, streamlining and simplifying data access. For enterprise environments, robust quality assurance and observability practices are crucial to guaranteeing precision, reliability, and regulatory compliance.
This instructor-led, live training (available online or onsite) targets advanced data and analytics professionals seeking to assess query accuracy, implement prompt optimisation techniques, and deploy observability practices to monitor WrenAI within production environments.
Upon completion of this training, participants will be capable of:
- Assessing the accuracy and reliability of natural language to SQL outputs.
- Applying prompt optimisation methods to enhance system performance.
- Tracking data drift and query behaviour over time.
- Equipping WrenAI with logging and observability frameworks.
Course Format
- Interactive lectures and discussions.
- Practical exercises focusing on assessment and optimisation techniques.
- Hands-on labs covering observability and monitoring integrations.
Customisation Options
- To arrange a tailored training session for this course, please contact us to discuss your requirements.
WrenAI Cloud Essentials: From Data Sources to Dashboards
14 HoursWrenAI Cloud serves as a contemporary platform designed to facilitate the connection of data sources, structuring of data, and the creation of interactive dashboards.
This instructor-led live training, available both online and onsite, targets beginner to intermediate data professionals seeking to master the setup of WrenAI Cloud, data modelling, and the visualisation of insights within dashboards.
Upon completion of this training, participants will be equipped to:
- Set up and configure WrenAI Cloud environments.
- Connect WrenAI Cloud to a variety of data sources.
- Model data and define relationships for analytical purposes.
- Create interactive dashboards to derive business insights.
Course Format
- Interactive lectures and discussions.
- Hands-on experience with cloud platform configuration and data modelling.
- Practical exercises focused on dashboard construction and visualisation.
Course Customisation Options
- To request a customised training version of this course, please contact us to arrange.
WrenAI for Financial Analytics: KPI Modeling and Regulatory-Aware Dashboards
14 HoursWrenAI equips finance teams with the capability to model KPIs, integrate standardized metrics, and design dashboards that align with regulatory requirements and audit standards.
This instructor-led, live training (available online or onsite) is designed for intermediate-level to advanced-level finance professionals who wish to utilize WrenAI for building compliant financial data models and dashboards that support decision-making and risk management.
By the end of this training, participants will be able to:
- Model financial KPIs and metrics in WrenAI.
- Build dashboards aligned with regulatory and audit requirements.
- Integrate WrenAI with finance data sources for real-time reporting.
- Apply best practices for financial analytics and risk monitoring.
Format of the Course
- Interactive lecture and discussion.
- Hands-on exercises with financial data models.
- Practical labs on dashboard design and compliance reporting.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
WrenAI OSS Deep Dive: Semantic Modeling, Text to SQL, and Guardrails
21 HoursWrenAI is an open-source generative BI tool that enables natural language to SQL conversion and semantic data modeling.
This instructor-led, live training (online or onsite) is aimed at advanced-level data engineers, analytics engineers, and ML engineers who wish to build robust semantic layers, tune prompts, and ensure reliable SQL generation.
By the end of this training, participants will be able to:
- Implement semantic models for consistent metric definitions across teams.
- Optimize text-to-SQL performance for accuracy and scalability.
- Configure and enforce guardrails to avoid invalid or risky queries.
- Integrate WrenAI OSS into data pipelines and analytics workflows.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
WrenAI for Product Teams: Conversational Analytics and Self-Service BI
14 HoursWrenAI serves as a conversational analytics platform that converts natural-language queries into trustworthy analytics, empowering non-technical teams to derive insights rapidly and consistently.
This instructor-led, live training (available online or onsite) targets intermediate-level product managers, analysts, and data champions looking to adopt conversational analytics and develop self-service BI capabilities using WrenAI.
By the conclusion of this training, participants will be equipped to:
- Design conversational analytics workflows that reveal reliable product insights.
- Create and maintain a standardized metrics layer to ensure consistent reporting.
- Effectively utilise natural-language to SQL features to address product-related inquiries.
- Integrate WrenAI-driven self-service dashboards and guardrails into product workflows.
Format of the Course
- Interactive lectures and discussions.
- Hands-on labs involving Wren AI and sample datasets.
- Workshop: constructing a self-service dashboard and conversational query set.
Course Customization Options
- For those seeking customized training for this course, please contact us to make arrangements.
Deploying WrenAI for SaaS: Embedded GenBI in Customer-Facing Products
14 HoursWrenAI empowers SaaS providers to seamlessly embed generative business intelligence (GenBI) directly within their customer-facing applications. This course equips SaaS teams with the essential skills to integrate Wren AI via its Embedded API, configure white-label analytics, and manage multi-tenant deployments effectively.
Delivered through instructor-led live training (available online or onsite), this programme is designed for intermediate to advanced-level SaaS product leaders, data engineers, and full-stack developers looking to deploy WrenAI as an embedded analytics solution within their SaaS environments.
Upon completion of this training, participants will be able to:
- Integrate WrenAI using the Embedded API for customer-facing applications.
- Implement white-label conversational BI with tailored branding and customization.
- Design secure and scalable multi-tenant deployments.
- Monitor usage, optimize performance, and ensure compliance in SaaS environments.
Course Format
- Interactive lectures and discussions.
- Hands-on labs utilizing the WrenAI Embedded API.
- Workshop: Design and deploy a white-label analytics feature for a specific SaaS use case.
Customization Options
- For customized training requests, please contact us to arrange.
Operational Analytics with WrenAI Spreadsheets and Metrics Library
14 HoursThe WrenAI Spreadsheets and Metrics Library facilitate rapid reporting by leveraging AI-driven spreadsheet workflows and a repository of pre-built, cross-platform business metrics.
This instructor-led live training, available both online and onsite, is designed for beginner to intermediate operations professionals seeking to expedite their reporting and analytical processes using WrenAI Spreadsheets alongside the Metrics Library.
Upon completion of this training, participants will be equipped to:
- Construct AI-enhanced spreadsheets for data analysis and reporting purposes.
- Utilise the WrenAI Metrics Library to establish standardised Key Performance Indicators (KPIs).
- Link spreadsheets to various data sources to ensure live data updates.
- Develop automated workflows to streamline operational reporting.
Course Format
- Interactive lectures and discussions.
- Practical, hands-on spreadsheet creation using WrenAI.
- Applied exercises focused on metrics and KPI reporting.
Customisation Options
- To arrange tailored training for this course, please get in touch with us.