Course Overview
This mentor-led dbt Analytics Engineering programme focuses on building reliable, maintainable, and scalable data transformation workflows using modern ELT practices. Learners explore how dbt enables analytics teams to take ownership of data modelling, testing, and documentation within cloud data platforms.
Through practical scenarios, participants implement modular SQL transformations, apply testing frameworks, and generate automated documentation. The course emphasises version control, collaboration workflows, and lineage tracking, ensuring transparency and trust in data pipelines.
By the end of the programme, learners will be able to design and manage dbt projects, enforce data quality, and maintain clear lineage across transformations. The course is aligned with modern analytics engineering practices used across high-performing data teams.
Hands-On Learning
Build dbt models, tests, and documentation through guided labs and scenario simulations.
Mentor-Led Sessions
Mentors guide learners through real-world ELT workflows and dbt project implementation.
Career-Ready Skills
Develop production-ready dbt workflows with testing and lineage tracking.
Learning Outcomes
Build and manage ELT pipelines using dbt
Design modular and scalable data models
Implement data testing and validation
Generate documentation and track lineage
Deploy dbt workflows in production environments
Apply best practices for analytics engineering
Prerequisites
Basic knowledge of SQL
Understanding of data pipelines or data analysis
Familiarity with data warehouses helpful
Detailed Syllabus
Organized by professional domains with comprehensive coverage
Topics Covered:
- •What is dbt
- •ELT vs ETL concepts
- •Role of analytics engineering
- •Modern data stack overview
Skills You'll Gain
Master these in-demand skills through hands-on practice
Career Progression
A clear view of the roles this programme supports, what typically comes next, and where learners progress over time
Ways to Learn
Choose the learning format that works best for you and your team
Live Online
Instructor-Led Training
Join live instructor-led sessions from anywhere. Interactive, engaging, and flexible.
- Live instructor interaction (real-time)
- Trainer-led walkthroughs and real examples
- Guided resources and session notes provided
- Structured Q&A and practical discussion
Price per person
Group enrolments and early planning options available.
All prices are exclusive of VAT where applicable. Group enrolments and custom packages available on request.
Prefer a Faster, Personalised Route into IT?
Not everyone learns best in a group. If you want focused guidance, faster clarity, and confidence you can use on the job, our 1-to-1 Fast-Track Training gives you private, mentor-led support tailored to your experience and goals.
"Many learners choose 1-to-1 when they want understanding, not memorisation."
Exam & Certification Information
Everything you need to know about the certification exams
Credential
Certificate of Completion
On successful completion of dbt Analytics Engineering, learners receive an Xcademia Certificate of Completion. This standalone certificate is issued directly by Xcademia and is aligned with globally recognised frameworks and best practices.
Frequently Asked Questions
Everything you need to know about this course
dbt (data build tool) is a framework for transforming data in warehouses using SQL-based workflows.
Ready to Start Your Learning Journey?
Take the next step in your professional development