Master Dbt Core Fundamentals Part 1

What you'll learn
Understand the core concepts and principles of dbt (data build tool), including the concepts of models, sources, and tests.
Gain proficiency in writing dbt models to transform raw data into meaningful and analytically valuable datasets.
Learn how to structure dbt projects effectively and use version control to manage changes in your analytics codebase
Understand the importance of data testing in the analytics workflow and how to create and execute tests in dbt.
Requirements
Basic SQL Knowledge
Basic Data Warehousing Understanding (snowflake) - not mandatory
For beginners or those without the specified prerequisites, don't worry! The course is designed to be accessible to learners at various levels
Description
Course Description:Unlock the full potential of your data analytics workflow with our comprehensive "dbt Core Fundamentals part 1" course. In this hands-on and accessible learning experience, you'll dive into the world of dbt (data build tool) to revolutionize the way you transform and model data for analytics.Course Highlights:Build a Solid Foundation: Gain a deep understanding of dbt's core concepts, including models, snapshots, seeds, and tests. Learn how to structure dbt projects for maximum efficiency and maintainability.Efficient Data Transformations: Master the art of crafting efficient and scalable data transformations using dbt. Explore advanced techniques, optimize queries, and apply best practices for top-notch analytics.Data Quality Assurance: Learn the importance of data testing and validation in the analytics pipeline. Develop skills to create and execute tests, ensuring the integrity and accuracy of your transformed data.Collaborative Development: Elevate your collaborative analytics development skills. Work seamlessly with teammates, manage codebase changes using version control, and create impactful documentation to enhance team collaboration.Hands-On Practice: Apply your knowledge through hands-on exercises and real-world scenarios. Gain practical experience in a dbt environment to reinforce your learning and build confidence in your analytics capabilities.Who Should Enrollata Analysts, Data Scientists, and Business Intelligence ProfessionalsData Engineers and Database AdministratorsAnalytics Managers and Team LeadsSQL Practitioners and Beginners in AnalyticsPrerequisites:Basic SQL knowledgeFamiliarity with data conceptsUnderstanding of data warehousing (not mandatory)Basic command line interface (CLI) skills (useful)Course Outcome:Upon completion, you'll be equipped with the skills to transform raw data into actionable insights efficiently, collaborate effectively in a team environment, and ensure the quality and reliability of your analytics data. Empower your analytics journey - enroll in the "dbt Core Fundamentals part 1" course and take your data transformation skills to the next level!
Overview
Section 1: Introduction to dbt
Lecture 1 what is dbt
Lecture 2 Key Features
Lecture 3 why dbt
Lecture 4 what is analytical Engineering
Section 2: set up dbt core
Lecture 5 list of set up tools
Lecture 6 set up dbt core
Lecture 7 how to sign up for snowflake (optional)
Section 3: dbt project setup
Lecture 8 dbt project setup
Lecture 9 what is dbt project.yml file
Lecture 10 load sample data into snowflake
Section 4: Models
Lecture 11 model definition
Lecture 12 what is model in dbt
Lecture 13 what is config in dbt
Lecture 14 what is ref function
Lecture 15 reorganize your project
Lecture 16 building stg_payments model
Lecture 17 building fact_orders model
Lecture 18 configure your materializations
Section 5: sources
Lecture 19 what is sources in dbt
Lecture 20 creating source for payment
Lecture 21 what is source freshness
Section 6: Tests
Lecture 22 what is dbt test
Lecture 23 types of dbt test
Lecture 24 generic test
Lecture 25 singular test
Lecture 26 testing sources
Section 7: Documentation
Lecture 27 dbt documentation
Data Analysts and Data Scientists,Business Intelligence Professionals,Data Engineers,Beginners in Analytics


Homepage