As a Data Engineer, I collect, extract and transform raw data in order to provide clean, reliable and usable data.
📘 Introduction In this hands-on tutorial, we’ll walk you step-by-step through how to orchestrate your dbt workflows using Dagster. Combining Dagster’s robust orchestration capabilities with dbt’s transformation power allows you to build reliable, maintainable, and observable data pipelines. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv)...
📘 Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through generating and serving interactive documentation for your dbt project. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts you one step closer to passing the exam and leveling up your...
📘 Introduction In this hands-on dbt tutorial, we'll walk you through why data contracts are critical for your dbt models — and how to add them to your dbt models step by step. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts...
📘 Introduction In this hands-on dbt tutorial, we'll walk you through how to add and run generic data tests in dbt using YAML configuration. These built-in tests help ensure your data quality and integrity, without writing any custom SQL. 📌 This is a must-know topic for the dbt Analytics Engineering...
📘 Introduction In this hands-on dbt tutorial, we'll walk you through how to use Common Table Expressions (CTEs) effectively in dbt models - an essential concept for modular, readable, and testable SQL. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts...
📘Introduction In this hands-on dbt tutorial, we'll walk you through how to describe and document your data models using schema.yml in dbt. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts you one step closer to passing the exam...
📘Introduction In Software Engineering, DRY stands for Don't Repeat Yourself — a fundamental principle aimed at reducing repetition, improving maintainability, and increasing code clarity. In the world of data transformation with dbt (data build tool), applying DRY principles helps ensure that your SQL code is modular, reusable, and easy...
📘 Introduction The dbt Analytics Engineering Certification Exam can be challenging—but with the right preparation strategy, you can pass with confidence. This guide brings together the best official resources and practical tutorials to help you stay focused, study smarter, and succeed. 📋1️⃣ Read the official dbt Study Guide Begin with...
📘 Introduction dbt gives you the power to transform raw data into clean, trusted models. But writing SQL is just the starting point. To truly get value from dbt, you need practices that keep your code organized, your models reliable, and your team moving fast. Whether you're a beginner...