[Kahan Data Solutions] Analytics Engineer with dbt™

Для тех кто не понимает, что такое dbt - это буква T (Transform) в процессе ELT/ETL. Стандарт моделирования данных за рубежом, сейчас уже многие российские компании начали его внедрять у себя и он появляется в вакансиях.

Go from zero to a savvy dbt developer in 4 hours.
Step-by-step. No fluff.


3 Things You'll Learn:

- The Viewpoint
Start designing data workflows with a modern perspective. You'll learn the revolutionary approach behind the tool to maximize its potential.

- How to Build Projects
Create custom data models on nearly any cloud platform. You'll see how to use both the Command Line Interface (CLI) and Cloud versions.

- Ways to Automate
Understand the importance of Version Control and CI/CD. Together we'll see how to use tools like GitHub to trigger deployments and tests.


But how will you actually learn this?

I will be walking you step-by-step through each topic and building a project from scratch along with you.
Here are the tools we will use (all free):

1. Visual Studio Code (editor for writing code)
2. Python (dbt is a Python package)
3. Git (needed for local version control)
4. GitHub (needed for hosted version control and workflow automation)
5. Snowflake - Trial (cloud database for storing data)
6. dbt Cloud - Trial (managed cloud platform for dbt)

If any of this sounds confusing, don't worry - I got you.
My environment will be a blank slate too and the course assumes nothing is installed to start.
You'll also receive pre-built SQL queries that we'll use to quickly configure our Snowflake environment. This will save us setup time so that we can instead focus more on working with dbt.

Язык: английский