Go to main content
Back to Courses
MODULE 16

Analytics Engineering with dbt and Semantic Layer

Transform raw data into reliable, reusable, and governed models with layering, tests, contracts, and semantic layer.

Editorial cover of the Analytics Engineering with dbt and Semantic Layer module
Analytics Engineering - official lesson image on GinnyTech, created by AD
1
Advanced 18 min

What Analytics Engineering Really Is

What analytics engineering really is. Introductory lesson of the Analytics Engineering with dbt and Semantic Layer module.

Go to lesson
Layering dbt - official lesson image on GinnyTech, created by AD
2
Advanced 18 min

'Layering: staging, intermediate, marts'

Layering: staging, intermediate, marts. Lesson on layered design of dbt models.

Prerequisites: 1

Go to lesson
dbt project structure - official lesson image on GinnyTech, created by AD
3
Advanced 22 min

dbt fundamentals and project structure

dbt fundamentals and project structure. Lesson on how to configure and structure a dbt project.

Prerequisites: 1

Go to lesson
Test and data quality - official lesson image on GinnyTech, created by AD
4
Advanced 18 min

Tests, contracts, and trust in models

Tests, contracts, and trust in models. Lesson on how to ensure data quality with dbt.

Prerequisites: 1

Go to lesson
Snapshot and SCD - official lesson image on GinnyTech, created by AD
5
Advanced 18 min

Snapshots and slow change management

Snapshot and slow change management. Lesson on SCD type-2 and snapshots in dbt.

Prerequisites: 1

Go to lesson
dbt Materialization - official lesson image on GinnyTech, created by AD
6
Advanced 18 min

Materialization, incremental, and snapshot for events and customer state

Materialization strategies in dbt to balance cost, freshness, and historical data.

Prerequisites: 1

Go to lesson
Semantic Layer - official lesson image on GinnyTech, created by AD
7
Advanced 18 min

Semantic layer and metric definitions

Semantic layer and metric definitions. Lesson on the semantic layer in dbt and reusable metrics.

Prerequisites: 1

Go to lesson
Collaboration and Git in dbt - official lesson image on GinnyTech, created by AD
8
Advanced 18 min

Git workflow, code review, and technical collaboration

Git workflow, code review, and technical collaboration. Lesson on collaboration practices in dbt projects.

Prerequisites: 1

Go to lesson
Environment and deploy - official lesson image on GinnyTech, created by AD
9
Advanced 18 min

Environments, deployment, and release discipline

Environments, deployment, and release discipline. Lesson on CI/CD and dbt environments.

Prerequisites: 1

Go to lesson
dbt Performance - official lesson image on GinnyTech, created by AD
10
Advanced 18 min

Performance and cost management in transformations

Performance and cost management in transformations. Strategies to optimize queries and reduce costs.

Prerequisites: 1

Go to lesson
Reverse ETL - official lesson image on GinnyTech, created by AD
11
Advanced 18 min

Reverse ETL and activation layer

Reverse ETL and activation layer. Lesson on how to bring warehouse data into operational tools.

Prerequisites: 1

Go to lesson
Cheat Sheet - Analytics Engineering with dbt - official lesson image on GinnyTech, created by AD
12
Advanced 10 min

Cheat Sheet - Analytics Engineering with dbt

Quick reference sheet for layers, naming, tests, materialization, macros, deployment, and review of dbt projects.

Prerequisites: 1

Go to lesson
Final Analytics Engineering Project - Official Lesson Image on GinnyTech
13
Advanced 28 min

'Final Project: A Complete Mini Analytics Stack'

Final Project: A Complete Mini Analytics Stack. Module Integrative Lab.

Prerequisites: 1

Go to lesson

Module connections

Continue hereStatistical Significance, A/B Testing, and Experimentation Science10 lessons

Take experimentation to a serious level with causal design, power planning, variance reduction, and governance.

Same stage of the pathMathematics for Data Analysis10 lessons

Introduces the mathematical rigor that makes models, inference, forecasting, and applied regressions more readable.

Same stage of the pathAdvanced SQL for Analytical Systems14 lessons

Use SQL as a reasoning language, not just extraction, with patterns for cohorts, funnels, experiments, and performance.

Previous moduleCourse Overview and Study Method for Data Work8 lessons

Transform the course from catalog to cognitive system, with study method, technical memory, and professional output plan.

Previous moduleData Collection & Tracking Systems8 lessons

Move from isolated tags and tools to reliable, governed, and observable measurement systems.

Previous moduleMetrics, KPI Trees, and Analytical Foundations6 lessons

Learn to read numbers as systems, with KPI trees, unit economics, correct baselines, and causal signal interpretation.