Sitemap - 2023 - Learn Analytics Engineering

Best Advice for Growing in Your Career

How to Use dbt Pre and Post-Hooks

How to Prepare for a SQL Take-Home

Is dbt's Hype Waranted?

How to Explain What You Do for a Living

5 Data Things I'm Grateful For

I Missed a Week of Posting.

Sunk-Cost Fallacy of a Data Stack

Data Mesh 101

SQL Order of Execution (with Examples!)

How I Migrate Legacy Code to dbt

Data Engineer vs Analytics Engineer

I'm a grad school dropout.

Data Contracts & Constraints

Continuous Integration 101

How to Find a True Analytics Engineering Role

When to Use Each dbt Materialization

5 Need-to-Knows About the Modern Data Stack

A Different Way to Document

Tutorial: Write a Custom Generic dbt Test

Laying a Strong Foundation

Reverse ETL 101

Discipline > Motivation

To EXISTS or NOT EXISTS...

dbt Core vs dbt Cloud

Are Data Conferences Worth Going to?

Data Things You Probably Didn't Learn in School...

dbt Features You Never Knew About

Tips for Passing the Data Presentation Interview

Fail More Often

How to Use dbt Snapshots

Choosing the Right Data Ingestion Tool for You

Are You a Data Consumer or Data Producer?

Tutorial: Automatically Push dbt docs to Notion Using a Github Action

Back to the Basics With SQL- Date Functions

Mastering the SQL Technical Interview

The Power of DAGs

Spring Cleaning Your Data Environment

Off the Beaten Path: Mary MacCarthy

What the Heck is a Modern Data Stack Engineer!?

SQL Functions to Make Messy Data Clean

Podcast #2: Data Quality Through the Lens of an Analytics Engineer

Tutorial: Customize Your dbt Schemas

Off the Beaten Path: Salma Bakouk

How to Build A Personal Brand

Analytics Engineer- A Glorified BI Engineer?

Tutorial: Using dbt to Test for Schema Changes

Back to the Basics With SQL- Aggregates

Back to the Basics with SQL- Joins

W is for Warehouse