Building with the WrenAI API: Applications, Charts, and NL to SQL Training Course
The WrenAI API offers a robust interface for converting natural language into SQL queries, developing bespoke applications, and embedding data visualizations into internal platforms.
This instructor-led, live training session (available online or on-site) targets intermediate-level engineers seeking to leverage the WrenAI API for practical implementations, such as SQL generation, data visualization, and application integration.
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.
- Hands-on exercises involving API calls and integrations.
- Practical projects that connect applications, visualizations, and data pipelines.
Customization Options
- To request a tailored training session, 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 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 within internal applications
- Customizing chart appearance and interactions
Integration with Internal Tools
- Embedding dashboards in 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 in 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 improvements in query generation
- Extending applications with advanced endpoints
- Exploring upcoming WrenAI features
Summary and Next Steps
Requirements
- A working knowledge of REST APIs
- Experience with SQL databases
- Familiarity with backend programming languages
Audience
- Backend engineers
- Platform engineers
- Teams focused on 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 engineered to link data, model insights, and produce dashboards. Within enterprise settings, strong governance and security measures are essential to guarantee safe and compliant implementation.
This instructor-led, live training (available online or onsite) targets advanced-level enterprise professionals seeking to apply governance, compliance, and security patterns for WrenAI at scale.
Upon completing this training, participants will be able to:
- Design and implement permissioning models within WrenAI.
- Apply auditability and monitoring practices to ensure compliance.
- Establish secure environments with enterprise-grade controls.
- Safely deploy WrenAI across large organisations.
Format of the Course
- Interactive lecture and discussion.
- Hands-on labs focused on governance and security configurations.
- Practical exercises simulating enterprise rollout scenarios.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Modernizing Legacy BI with WrenAI: Adoption, Migration, and Change Management
14 HoursWrenAI empowers organizations to transition from static dashboards to conversational analytics and embedded generative BI. This shift demands meticulous adoption planning, asset migration, and robust change management strategies.
This instructor-led, live training (available online or onsite) targets intermediate-level BI and data platform professionals seeking to modernize their legacy BI systems using WrenAI.
Upon completion of this training, participants will be capable of:
- Assessing legacy BI environments to pinpoint modernization opportunities.
- Planning and executing the migration from static dashboards to WrenAI.
- Implementing conversational analytics and embedded GenBI functionalities.
- Driving organizational change management for BI modernization efforts.
Course Format
- Interactive lectures and discussions.
- Practical exercises focused on migration and adoption planning.
- Hands-on labs covering conversational analytics and embedded GenBI.
Course Customization Options
- For inquiries regarding customized training for this course, please contact us to arrange.
Quality and Observability for WrenAI: Evaluation, Prompt Tuning, and Monitoring
14 HoursWrenAI facilitates the conversion of natural language into SQL queries and supports AI-driven analytics, thereby making data access more intuitive and efficient. For enterprise applications, rigorous quality assurance and observability protocols are critical to guaranteeing accuracy, reliability, and regulatory compliance.
This instructor-led, live training session (available online or onsite) is designed for advanced data and analytics professionals seeking to evaluate query precision, implement prompt tuning strategies, and establish observability practices for monitoring WrenAI in live production environments.
Upon completion of this training, participants will be capable of:
- Assessing the accuracy and reliability of natural language to SQL conversions.
- Utilizing prompt tuning techniques to enhance system performance.
- Tracking query behavior and detecting drift over time.
- Integrating WrenAI with logging and observability frameworks.
Course Format
- Interactive lectures and discussions.
- Practical exercises focusing on evaluation and tuning methodologies.
- Hands-on labs covering observability and monitoring integrations.
Customization Options
- For bespoke training arrangements, please contact us directly.
WrenAI Cloud Essentials: From Data Sources to Dashboards
14 HoursWrenAI Cloud serves as a contemporary platform designed to link data sources, structure data models, and construct interactive dashboards.
Delivered as an instructor-led live session, available either online or at your premises, this training is tailored for data professionals at beginner to intermediate levels. It focuses on equipping participants with the skills to configure WrenAI Cloud, model their data, and visualise key insights through dashboards.
Upon completion of this training, participants will be equipped to:
- Establish and configure WrenAI Cloud environments.
- Link WrenAI Cloud to various data sources.
- Model data and define analytical relationships.
- Develop interactive dashboards to drive business insights.
Course Format
- Engaging lectures and discussions.
- Practical configuration of the cloud platform and data modelling.
- Hands-on exercises focused on building dashboards and visualising data.
Course Customisation Options
- For bespoke training requirements, please get in touch with us to arrange.
WrenAI for Financial Analytics: KPI Modeling and Regulatory-Aware Dashboards
14 HoursWrenAI empowers finance teams to model key performance indicators (KPIs), integrate standardized metrics, and create dashboards that meet regulatory requirements and audit standards.
This instructor-led, live training (available online or on-site) is designed for intermediate to advanced finance professionals looking 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 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 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 embed generative business intelligence (GenBI) directly into their customer-facing applications. This course equips SaaS teams with the necessary skills to integrate WrenAI via its Embedded API, configure white-label analytics, and manage multi-tenant deployments.
This instructor-led, live training, available either online or onsite, is designed for intermediate to advanced SaaS product leaders, data engineers, and full-stack developers looking to deploy WrenAI as an embedded analytics solution within SaaS environments.
By the conclusion 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.
Format of the Course
- Interactive lecture and discussion.
- Hands-on labs using WrenAI Embedded API.
- Workshop: design and deploy a white-label analytics feature for a 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 facilitate rapid reporting by combining AI-driven spreadsheet workflows with a repository of pre-built, cross-platform business metrics.
This instructor-led live training, available online or onsite, targets beginner to intermediate operational professionals seeking to accelerate reporting and analysis processes through the use of WrenAI Spreadsheets and the Metrics Library.
Upon completion of this training, participants will be capable of:
- Developing AI-enhanced spreadsheets for data analysis and reporting purposes.
- Utilizing the WrenAI Metrics Library to establish standardized KPIs.
- Linking spreadsheets to various data sources to ensure real-time updates.
- Establishing automated workflows to streamline operational reporting tasks.
Course Format
- Interactive lectures and discussions.
- Practical sessions involving spreadsheet construction with WrenAI.
- Hands-on exercises focused on metrics and KPI reporting.
Course Customization Options
- For inquiries regarding customized training arrangements for this course, please contact us.
