• views: 139
• date: 4 May 2025
• posted by: AD-TEAM

Analytics Engineering Bootcamp to take you from beginner to advanced dbt, and get hands-on with dbt Cloud!

What you'll learn

How to build a complete dbt project from scratch

The main benefits of dbt, and a bit of background as to how it came about

All of the dbt fundamentals: sources, models, tests, documentation, snapshots, seeds, macros, hooks, and operations

How to structure a dbt project

How to version control changes to your code with GitHub

Advanced dbt testing - creating your own custom singular & generic tests, setting severity, and setting warn/error thresholds

Advanced dbt data modelling - including incremental and ephemeral models and what type to use (& when)

Advanced dbt commands - how to use different selectors, different profiles, tags, indirect test selection and building a local dbt documents site

Advanced dbt jinja & macros - creating your own macros to use in hooks / functions / operations, using jinja for loops and variables, and the target function

How to deploy your project on dbt Cloud, how to use the dbt Cloud UI, and using environment variables

How to use tests & macros from external packages to supercharge your dbt project

Best practises to use when running a dbt project (based on lots of experience!)

How to create a complete setup for Mac or Windows: installing all of the tools and getting a dbt specific VSCode setup!

Requirements

Basic SQL

No Python experience needed

Mac / Windows machine which is capable of installing Python, Git, and VSCode (we'll run through all of this in the course!)

Description

Welcome to the 2023 Mastering dbt (data build tool) course!Thank you for taking the time to look at my course! I have over 7 years of experience across Analytics / Analytics Engineering / Data Science, including 4 years using dbt on a daily basis. I was also involved in the rollout of dbt in my time at Monzo.MY APPROACH TO THIS COURSE:This course is designed to take you from only needing beginner SQL to being comfortable with everything in dbt: from the basic data modelling right through to all of the advanced features such as creating custom tests and macros. We'll be doing this step by step, and build from the basics upwards.It's focused on practical outcomes - we won't be spending ages on database theory, or going into lots of detail on the dataset, instead we'll be aiming to get you up to advanced dbt levels as quickly as possible.For this course, we'll be using a free public dataset in Google BigQuery centred around a fictional eCommerce business.Use Snowflake, Redshift, Databricks, or anything other than BigQuery? Don't worry! I've used dbt with both BigQuery and Snowflake myself and all of the knowledge you learn on this course will be transferable.The focus of this course is not around exploring the entire dataset - instead I've tried to keep it to the minimum number of data models needed to get the core concepts across.Access to this dataset is free, and the amount of data you'll be using in BigQuery will be free. I go into this a bit more in the course - but please don't worry about any additional costs.For every video where we're writing code, I've created lesson attachments with the final outputs. This means you can either code as you go along, or watch the videos and look at the handouts afterwards! I've also included some theory with these handouts to help hammer home the points made in the videos.This course isn't static! I'd love to hear your feedback and will be updating this course on an ongoing basis.COURSE STRUCTURE:This course focuses on first getting a good understanding of what problems dbt solves, then building a basic dbt project, before layering on more advanced concepts and finally deploying our project with dbt Cloud.IntroductionA bit of theory (

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.