Data Transformation and Analytics Engineering with Data Build Tool
Master the art of data transformation and analytics engineering with our expertly designed course on dbt. Gain specialized skills in bridging data engineering with analytics under expert guidance. Enroll now to elevate your capabilities in advanced model development, materialization techniques, Jinja templating, custom macros creation, package management, documentation best practices, testing strategies, environment management, deployment orchestration, performance optimization, source configuration, exposure definition, project governance, and collaborative workflows.
- Available in:
- Malaysia
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

What you'll learn
- Understand the role of dbt in modern analytics engineering workflows
- Manage packages effectively in both dbt Core and Cloud environments
- Optimize performance by identifying bottlenecks and refining queries
- Develop advanced skills in building modular SQL transformations
- Master materialization techniques including incremental models
- Establish comprehensive testing frameworks for data quality assurance
- Implement Jinja templating for dynamic SQL generation
- Create custom macros for standardized data transformations
Why should you attend?
This course offers a comprehensive exploration of data transformation and analytics engineering using dbt, focusing on bridging the gap between data engineering and analytics. Participants will delve into the analytics engineering workflow, understanding dbt's pivotal role in modern data practices. The course provides insights into choosing between dbt Core and dbt Cloud, equipping learners with the knowledge to select the best approach for their needs. Advanced model development is a key component, where learners will build modular SQL transformations and implement effective model hierarchies. The course emphasizes optimizing model dependencies and includes hands-on exercises to refactor existing SQL into structured dbt models. Materializations are explored in depth, covering trade-offs, incremental models, performance optimization techniques, and ephemeral models. The curriculum also covers Jinja templating for dynamic SQL generation, custom macro development for standardized transformations, and package management strategies in both dbt Core and Cloud environments. Participants will learn documentation best practices to create comprehensive model documentation and implement data dictionaries. Advanced testing strategies are introduced to build robust testing frameworks and ensure data quality. Environment management is addressed with a focus on CI/CD implementation and managing configurations across different environments. Deployment strategies include job scheduling options, integrating dbt with Airflow, and handling external system dependencies. Finally, the course explores performance optimization techniques to identify bottlenecks and optimize queries. Learners will work with sources and seeds for reference data management while defining exposures and metrics for downstream consumers. Project governance is emphasized through style guides, code review practices, collaboration features, and debugging complex issues.
Course Syllabus
Day 1 - dbt Fundamentals & Development
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Day 2 - Testing & Production Deployment
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 2
Ratings and Reviews
Instructor
Instructor
Instructor Reviews
Mohammad Mehdi Lotfinejad
Chief Data Officer & Data Science Trainer"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."
"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."
"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."
FAQ
Frequently Asked Questions About This Course
- Public pricing: applies for individuals signing up from different companies.
- Corporate pricing: applies if a company wants to have an intake for its employees only.
- Training provider pricing: applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.
We will keep you updated on the status of the intake after you enroll.
Why should you attend?
This course offers a comprehensive exploration of data transformation and analytics engineering using dbt, focusing on bridging the gap between data engineering and analytics. Participants will delve into the analytics engineering workflow, understanding dbt's pivotal role in modern data practices. The course provides insights into choosing between dbt Core and dbt Cloud, equipping learners with the knowledge to select the best approach for their needs. Advanced model development is a key component, where learners will build modular SQL transformations and implement effective model hierarchies. The course emphasizes optimizing model dependencies and includes hands-on exercises to refactor existing SQL into structured dbt models. Materializations are explored in depth, covering trade-offs, incremental models, performance optimization techniques, and ephemeral models. The curriculum also covers Jinja templating for dynamic SQL generation, custom macro development for standardized transformations, and package management strategies in both dbt Core and Cloud environments. Participants will learn documentation best practices to create comprehensive model documentation and implement data dictionaries. Advanced testing strategies are introduced to build robust testing frameworks and ensure data quality. Environment management is addressed with a focus on CI/CD implementation and managing configurations across different environments. Deployment strategies include job scheduling options, integrating dbt with Airflow, and handling external system dependencies. Finally, the course explores performance optimization techniques to identify bottlenecks and optimize queries. Learners will work with sources and seeds for reference data management while defining exposures and metrics for downstream consumers. Project governance is emphasized through style guides, code review practices, collaboration features, and debugging complex issues.
What you'll learn
- Understand the role of dbt in modern analytics engineering workflows
- Manage packages effectively in both dbt Core and Cloud environments
- Optimize performance by identifying bottlenecks and refining queries
- Develop advanced skills in building modular SQL transformations
- Master materialization techniques including incremental models
- Establish comprehensive testing frameworks for data quality assurance
- Implement Jinja templating for dynamic SQL generation
- Create custom macros for standardized data transformations
Course Syllabus
Day 1 - dbt Fundamentals & Development
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Day 2 - Testing & Production Deployment
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 2
Instructor Reviews
Mohammad Mehdi Lotfinejad
Chief Data Officer & Data Science Trainer"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."
"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."
"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

Ratings and Reviews
Instructors
FAQ
Frequently Asked Questions About This Course
- Public pricing: applies for individuals signing up from different companies.
- Corporate pricing: applies if a company wants to have an intake for its employees only.
- Training provider pricing: applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.
We will keep you updated on the status of the intake after you enroll.
Our Offers
Academy for Trainers Academy for Trainers
Teach what you love. Abundent Academy gives you the tools you need to run your own trainings! We provide you with the platform, the students, the materials, and the support you need to succeed!
- Higher trainer payouts
- Ready-made course materials
- Student management system
- AI digital marketing assistant
Academy for Corporates Academy for Corporates
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to learning paths and roles! Perfect for companies looking to upskill their workforce and stay ahead in the tech industry.
- Carefully curated courses
- Role-based learning paths
- Team progress tracking
- Gap Identification and Analysis
Academy for Partners Academy for Partners
White-label IT training delivery for training providers. We become your behind-the-scenes delivery arm so you can say yes to more clients without hiring more trainers.
- Expand your training catalog
- 40+ expert trainers ready
- White-label delivery
- You keep client relationships