Building with the WrenAI API: Applications, Charts, and NL to SQL Training Course
The WrenAI API serves as a robust interface designed to convert natural language into SQL queries, facilitate the creation of custom applications, and embed visual charts within internal platforms.
This instructor-led training, available both online and on-site, is designed for intermediate-level engineers looking to leverage the WrenAI API for practical use cases, such as generating SQL, visualizing data, and integrating applications.
Upon completion of this training, participants will be capable of:
- Authenticating and linking applications to the WrenAI API.
- Generating SQL queries from natural language inputs.
- Creating and embedding charts via API endpoints.
- Integrating WrenAI into backend systems and internal tools.
Course Format
- Interactive lectures and discussions.
- Practical exercises involving API calls and integrations.
- Real-world projects that connect applications, charts, and data pipelines.
Customization Options
- For inquiries regarding customized training for this course, please contact us to arrange details.
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
- Sending natural language queries.
- Interpreting and validating generated SQL.
- Optimizing 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 Visualization via API
- Requesting chart objects through the API.
- Embedding charts into internal applications.
- Customizing chart appearance and interactions.
Integration with Internal Tools
- Embedding dashboards into team portals.
- Automating workflows using WrenAI endpoints.
- Exploring 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 features of WrenAI.
Summary and Next Steps
Requirements
- Understanding of REST APIs.
- Experience with SQL databases.
- Familiarity with backend programming languages.
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-powered analytics platform designed to connect data, model insights, and generate dashboards. In enterprise environments, robust governance and security are critical to ensuring safe and compliant adoption.
This instructor-led, live training (available online or on-site) is tailored for advanced-level enterprise professionals who aim to implement governance, compliance, and security patterns for WrenAI at scale.
By the end of this training, participants will be able to:
- Design and implement permissioning models within WrenAI.
- Apply auditability and monitoring practices to meet compliance requirements.
- Configure secure environments with enterprise-grade controls.
- Safely deploy WrenAI across large-scale organisations.
Course Format
- Interactive lectures and group discussions.
- Hands-on labs focused on governance and security configurations.
- Practical exercises simulating real-world enterprise deployment scenarios.
Course Customisation Options
- To request a customised version of this course, please contact us to make arrangements.
Modernizing Legacy BI with WrenAI: Adoption, Migration, and Change Management
14 HoursWrenAI empowers organisations to move beyond static dashboards toward conversational analytics and embedded generative BI. This transition demands careful adoption planning, asset migration, and effective change management practices.
This instructor-led, live training (available online or on-site) is designed for intermediate-level BI and data platform professionals seeking to modernise legacy BI systems using WrenAI.
By the end of this training, participants will be able to:
- Evaluate legacy BI environments and identify modernisation opportunities.
- Plan and execute migrations from static dashboards to WrenAI.
- Adopt conversational analytics and embedded GenBI capabilities.
- Lead organisational change management for BI modernisation.
Course Format
- Interactive lectures and discussions.
- Hands-on exercises covering migration and adoption planning.
- Practical labs focused on conversational analytics and embedded GenBI.
Course Customisation Options
- To request a customised training session for this course, please contact us to arrange.
Quality and Observability for WrenAI: Evaluation, Prompt Tuning, and Monitoring
14 HoursWrenAI transforms natural language into SQL and powers AI-driven analytics, making data access more intuitive and rapid. For enterprise deployments, rigorous quality assurance and observability standards are vital to guarantee accuracy, reliability, and regulatory compliance.
This live, instructor-led training (available online or onsite) is designed for advanced data and analytics professionals who aim to assess query precision, optimize prompts, and establish observability protocols for monitoring WrenAI in production environments.
Upon completing this training, participants will be equipped to:
- Assess the precision and dependability of Natural Language to SQL outputs.
- Implement prompt tuning strategies to enhance system performance.
- Track performance drift and query patterns over time.
- Equip WrenAI with logging and observability frameworks.
Course Structure
- Engaging lectures and interactive discussions.
- Practical exercises focused on evaluation and tuning techniques.
- Hands-on labs covering observability and monitoring integrations.
Customization Options
- To arrange a tailored training session for this course, please reach out to us.
WrenAI Cloud Essentials: From Data Sources to Dashboards
14 HoursWrenAI Cloud is a contemporary platform designed for linking data sources, structuring data, and constructing interactive dashboards.
This instructor-led, live training session, available either online or onsite, targets beginner to intermediate data professionals eager to master setting up WrenAI Cloud, modeling data, and visualizing insights through dashboards.
Upon completing this training, participants will be capable of:
- Setting up and configuring WrenAI Cloud environments.
- Linking WrenAI Cloud to various data sources.
- Modeling data and defining relationships for analytics.
- Creating interactive dashboards to derive business insights.
Format of the Course
- Interactive lectures and discussions.
- Practical cloud platform configuration and data modeling.
- Hands-on exercises in dashboard creation and visualization.
Course Customization Options
- For a customized training version of this course, please contact us to arrange.
WrenAI for Financial Analytics: KPI Modeling and Regulatory-Aware Dashboards
14 HoursWrenAI enables finance teams 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 on-site) is designed for intermediate to advanced-level finance professionals who wish to leverage WrenAI to build 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 using WrenAI.
- Develop dashboards aligned with regulatory and audit requirements.
- Integrate WrenAI with finance data sources for real-time reporting.
- Apply best practices in financial analytics and risk monitoring.
Course Format
- Interactive lectures and discussions.
- Hands-on exercises using financial data models.
- Practical labs focused on dashboard design and compliance reporting.
Course Customization Options
- To request a customized version of this training, 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 facilitates natural language to SQL conversion and semantic data modeling.
This instructor-led, live training (available online or onsite) is designed for advanced data engineers, analytics engineers, and ML engineers aiming to build robust semantic layers, tune prompts, and ensure reliable SQL generation.
Upon completing this training, participants will be able to:
- Implement semantic models to establish consistent metric definitions across teams.
- Optimize text-to-SQL performance for enhanced accuracy and scalability.
- Configure and enforce guardrails to prevent invalid or risky queries.
- Integrate WrenAI OSS into data pipelines and analytics workflows.
Course Format
- Interactive lectures and discussions.
- Numerous exercises and practical sessions.
- 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 is a conversational analytics platform that translates natural-language queries into reliable analytics, enabling non-technical teams to generate insights quickly and consistently.
This instructor-led, live training (online or onsite) is aimed at intermediate-level product managers, analysts, and data champions who wish to adopt conversational analytics and build self-service BI capabilities with WrenAI.
By the end of this training, participants will be able to:
- Design conversational analytics workflows that surface reliable product insights.
- Create and maintain a standardized metrics layer for consistent reporting.
- Use natural-language to SQL features effectively to answer product questions.
- Embed WrenAI-driven self-service dashboards and guardrails in product workflows.
Format of the Course
- Interactive lecture and discussion.
- Hands-on labs with Wren AI and sample datasets.
- Workshop: build a self-service dashboard and conversational query set.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Deploying WrenAI for SaaS: Embedded GenBI in Customer-Facing Products
14 HoursWrenAI empowers SaaS providers to seamlessly integrate generative business intelligence (GenBI) directly into their customer-facing applications. This course provides SaaS teams with the essential skills to connect Wren AI via its Embedded API, configure white-label analytics, and manage multi-tenant deployments effectively.
This instructor-led, live training (available online or onsite) is designed for intermediate to advanced SaaS product leaders, data engineers, and full-stack developers aiming to deploy WrenAI as an embedded analytics solution within SaaS environments.
Upon completion of this training, participants will be capable of:
- Integrating WrenAI via the Embedded API for customer-facing applications.
- Implementing white-label conversational BI with tailored branding and customization.
- Designing secure and scalable multi-tenant deployments.
- Monitoring usage, optimizing performance, and ensuring 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.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Operational Analytics with WrenAI Spreadsheets and Metrics Library
14 HoursWrenAI Spreadsheets and Metrics Library enable fast reporting through AI-powered spreadsheet workflows and a library of pre-built, cross-platform business metrics.
This instructor-led, live training (available online or on-site) is designed for beginner to intermediate-level operations professionals who aim to accelerate reporting and analysis using WrenAI Spreadsheets and the Metrics Library.
By the end of this training, participants will be able to:
- Build AI-powered spreadsheets for data analysis and reporting.
- Leverage the WrenAI Metrics Library for standardized KPIs.
- Connect spreadsheets to multiple data sources for live updates.
- Create automated workflows to streamline operational reporting.
Course Format
- Interactive lectures and group discussions.
- Hands-on spreadsheet building using WrenAI.
- Practical exercises focused on metrics and KPI reporting.
Customization Options
- To request a customized training session for this course, please contact us to arrange.