Kahan Data Solutions

Managing the "End" of a Data Pipeline

The Missing Piece in Many Data Pipelines

How to Pick Tools for a Data Stack (considerations)

The Power of Naming in Data Projects (especially dbt)

Getting Buy-In for Data & Analytics Projects (what to focus on)

You Don't Need to Learn Every Data Tool & Skill

How to Use Jinja w/ dbt Macros (3 Examples)

4 Reasons Why You Should STILL Learn SQL

Data Warehouse Security w/ 4 Simple Roles

How to Create a Data Modeling Pipeline (3 Layer Approach)

What is Data Mesh?

How to Build Incremental Models | dbt tutorial

Modern Data Engineering Workflows, Explained

Data Architecture 101: Kappa (Real-Time Data)

How to Refresh Data Models Daily (for free)

How to Sync PostgreSQL Data w/ Airbyte

Data Architecture 101: The Lambda Strategy

How to Run Queries from the Terminal (dbt Show Command)

Common Data Team Structures (Engineer vs Analyst vs Scientist)

Data Architecture 101: The Modern Data Warehouse

Why Data Migrations Go Wrong (3 reasons)

What are "intermediate" models in dbt?

dbt Environments vs Targets | What's the Difference?

Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault)

Data Automation (CI/CD) with a Real Life Example

3 Ways to Deploy Data Projects

The Importance of Virtual Environments for Data Engineers

How to Create a Virtual Machine (VM) on Google Cloud Platform (GCP)

Data Engineer | Employee vs Consultant (4 differences)

Modern vs Traditional Data Stacks (3 differences)

Why Your Data Team Needs Version Control

How to use dbt Snapshots to track data history

Getting Started with Prefect | Task Orchestration & Data Workflows

dbt Project Naming Conventions (recommended approach)

How to use dbt Operators to run dynamic commands

How to use Exposures in dbt

The Hidden Cost of Open Source

Stand Out as a Data Engineer w/ Free Tools

Data Modeling Tutorial: Star Schema (aka Kimball Approach)

3 Time-Saving dbt Cloud Features (for free)

Snowflake vs BigQuery | What's Different?

The 3 Pillars of Data Engineering

Cloud Data Storage Temperatures, explained

Send Slack Messages from your Data Warehouse (no code)

Write better SQL with a Style Guide | 3 Things to Consider

Getting Started w/ PostgreSQL! | Download, Install & Add Data

Intro to dbt Cloud // Use Free for Life

Getting Started w/ BigQuery!

What do you actually do as a data engineer?

How to Enable SSO on Snowflake | Azure AD