
Analytics Engineering with dbt on Snowflake
Udemy · English
About this course
- Language
- English
- Category
- Provider
- Udemy
- Data updated
Analytics engineering is one of the fastest-growing roles in data, and dbt on Snowflake is one of its most in-demand skill sets. This course takes you from your first SQL query to deploying a tested, production-ready dbt project on Snowflake. Most dbt tutorials stop at "run your first model." This course goes further. You'll learn how real data teams structure, test, document and deploy their transformation layer, and you'll build a complete e-commerce analytics project step by step. What you'll work through: Analytics Engineering Overview: what the role is, where it sits in a data team, and how data moves from source systems into warehouses, lakes and lakehouses through ETL and ELT pipelinesData Modeling: the Medallion architecture, star and snowflake schemas, fact and dimension tables, slowly changing dimensions, Data Vault and the BEAM methodologySQL Crash Course: filtering, aggregations, joins, subqueries, CTEs and window functions, with five hands-on assignmentsSnowflake Fundamentals: architecture, virtual warehouses, loading data with stages, COPY INTO and Snowpipe, Time Travel, zero-copy cloning, Streams, Tasks and Stored ProceduresAnalytics Engineering with dbt: models and the DAG, ref() and source(), materializations and incremental strategies, unit tests, data tests, data contracts, snapshots, Jinja, macros, packages, documentation, and running dbt in production with Git and CI/CDLearn by doing. The course includes 16 hands-on assignments with clear success criteria, so you can check your own work as you go. Your instructor: Ricardo Gonçalves has more than 10 years of experience working with data as a Data Analyst, Data Scientist and Data Engineer. The course reflects how these tools are used in real projects, not only how they're describe…











