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.

Face-to-Face Nov 19-20, 2026 9:00 AM - 5:00 PM Mohammad Mehdi Lotfinejad
updated
intermediate
Data Transformation and Analytics Engineering with dbt
We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 6200 ++

Features

2 days
16 modules
7 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
q&A

Subsidies

HRDC Claimable logo

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
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Testing & Production Deployment
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
108 Courses
18 Years

Instructor

Loading...
Mohammed Al-obaydee AI & Data Science Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Mohammed Al-Obaydee is a distinguished academic and industry professional with extensive expertise in artificial intelligence, machine learning, deep learning, and data science. As an Adjunct Associate Professor at Taylor's University Malaysia and a certified Train the Trainer professional, he brings a unique blend of academic rigor and practical industry experience to his teaching and consulting engagements. With a Ph.D. in Information Science from Universiti Kebangsaan Malaysia (UKM) and over two decades of experience spanning academia and industry, Dr. Al-Obaydee has established himself as a leading authority in advanced computing technologies. His research excellence is evidenced by multiple best paper awards, including recognition at IEEE ACSAT2014 and ITNG 2023 conferences, along with an impressive publication record featuring over 149 citations and an h-index of 6. His research focuses on medical image analysis, computer vision, machine learning applications, and deep learning techniques. As a founder of INNOEYETIVE and AIC4ALL, Dr. Al-Obaydee demonstrates entrepreneurial acumen in leveraging AI and immersive technologies for digital transformation. His industry experience includes successful training and consultation projects with major corporations such as HSBC Bank, OCBC Bank, DELL Malaysia, Amway Malaysia, and EtiQa, where he has delivered specialized programs in data science, analytics, and applied AI engineering. His ability to bridge the gap between theoretical concepts and practical applications makes him an exceptional trainer for professionals seeking to upskill in emerging technologies. Dr. Al-Obaydee's teaching portfolio encompasses a comprehensive range of subjects including Machine Learning, Deep Learning, Data Analytics, Data Engineering, Parallel Computing, and Advanced Data Structures. He has supervised numerous master's students and research projects at both Taylor's University and the International Islamic University Malaysia (IIUM), focusing on cutting-edge topics such as deep reinforcement learning, medical image classification, fraud detection, and natural language processing. His international speaking engagements and extensive training experience across multiple organizations demonstrate his exceptional communication skills and ability to make complex technical concepts accessible to diverse audiences.
113 Courses
English
21 Years

Required Software

dbt

Instructor Reviews

ML

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

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
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Testing & Production Deployment
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2

Instructor Reviews

ML

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."

We price match

Public Pricing

MYR 3500

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 13000 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 6200 ++

Features

2 days
16 modules
7 intakes
Full life-time access
English
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
q&A

Subsidies

HRDC Claimable logo

Instructors

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
108 Courses
18 Years
Loading...
Mohammed Al-obaydee AI & Data Science Expert
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Dr. Mohammed Al-Obaydee is a distinguished academic and industry professional with extensive expertise in artificial intelligence, machine learning, deep learning, and data science. As an Adjunct Associate Professor at Taylor's University Malaysia and a certified Train the Trainer professional, he brings a unique blend of academic rigor and practical industry experience to his teaching and consulting engagements. With a Ph.D. in Information Science from Universiti Kebangsaan Malaysia (UKM) and over two decades of experience spanning academia and industry, Dr. Al-Obaydee has established himself as a leading authority in advanced computing technologies. His research excellence is evidenced by multiple best paper awards, including recognition at IEEE ACSAT2014 and ITNG 2023 conferences, along with an impressive publication record featuring over 149 citations and an h-index of 6. His research focuses on medical image analysis, computer vision, machine learning applications, and deep learning techniques. As a founder of INNOEYETIVE and AIC4ALL, Dr. Al-Obaydee demonstrates entrepreneurial acumen in leveraging AI and immersive technologies for digital transformation. His industry experience includes successful training and consultation projects with major corporations such as HSBC Bank, OCBC Bank, DELL Malaysia, Amway Malaysia, and EtiQa, where he has delivered specialized programs in data science, analytics, and applied AI engineering. His ability to bridge the gap between theoretical concepts and practical applications makes him an exceptional trainer for professionals seeking to upskill in emerging technologies. Dr. Al-Obaydee's teaching portfolio encompasses a comprehensive range of subjects including Machine Learning, Deep Learning, Data Analytics, Data Engineering, Parallel Computing, and Advanced Data Structures. He has supervised numerous master's students and research projects at both Taylor's University and the International Islamic University Malaysia (IIUM), focusing on cutting-edge topics such as deep reinforcement learning, medical image classification, fraud detection, and natural language processing. His international speaking engagements and extensive training experience across multiple organizations demonstrate his exceptional communication skills and ability to make complex technical concepts accessible to diverse audiences.
113 Courses
English
21 Years

Required Software

dbt

FAQ

Frequently Asked Questions About This Course

Close menu