This course helps you advance your skills in analytics engineering and gives you the practical abilities required to build scalable and reliable dbt projects. You will begin by strengthening your understanding of reusable SQL development with Jinja and macros and learn how to organize transformation logic for large data systems. From there, you will explore incremental models, snapshots, testing strategies, documentation practices, and core observability concepts that support trustworthy analytics workflows. The course concludes with collaboration techniques and workflow automation, where you will implement Git based version control, continuous integration pipelines, and scheduled dbt jobs.

Gain next-level skills with Coursera Plus for $199 (regularly $399). Save now.

Recommended experience
What you'll learn
Create reusable SQL logic with Jinja and macros to simplify and standardize complex transformations.
Design efficient incremental models and build snapshots that track historical changes for reliable analytics.
Implement schema and custom tests, add rich documentation, and use dbt Docs to strengthen data quality and clarity.
Work with Git based workflows, pull requests, and structured reviews to support team driven development.
Skills you'll gain
Details to know

Add to your LinkedIn profile
December 2025
See how employees at top companies are mastering in-demand skills

There are 3 modules in this course
This module focuses on building reusable SQL logic and creating scalable transformation patterns. It introduces Jinja, macros, incremental processing, snapshots, and project refactoring. Learners implement cleaner SQL queries, optimize performance, and maintain a well structured DAG for long term project growth.
What's included
14 videos6 readings4 assignments3 discussion prompts
This module teaches how to ensure accuracy, reliability, and clarity in analytics workflows. It covers schema tests, custom SQL tests, metadata management, documentation practices, and essential observability concepts. Learners interpret test results, review run logs, and improve data trust across their projects.
What's included
11 videos4 readings4 assignments2 discussion prompts
This module explores team oriented development practices and automated analytics workflows. It covers Git based collaboration, pull requests, branching strategies, continuous integration, and scheduled dbt jobs. Learners implement automated testing, inspect CI artifacts, and set up reliable production pipeline scheduling.
What's included
13 videos5 readings5 assignments3 discussion prompts
Why people choose Coursera for their career





Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
This course is designed for analytics engineers, data analysts, BI developers, and data professionals who already have basic experience with dbt and want to advance their skills. It is ideal for learners who understand core dbt concepts and are ready to build scalable projects, automate workflows, and work in collaborative production environments.
The course covers advanced dbt development techniques, including Jinja templating, macros, incremental models, and snapshots. It also focuses on refactoring dbt projects for scale, implementing robust testing strategies, maintaining documentation and metadata, and building observability into data pipelines. In addition, the course introduces Git-based collaboration, CI workflows, and automated scheduling for dbt runs.
Yes. You will learn Jinja fundamentals, macro patterns for reusable SQL, parameterization techniques, and how to apply macros across multiple models. Hands-on exercises guide you through creating and using macros to reduce duplication and standardize transformations across your project.
More questions
Financial aid available,
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.


