Канал: Kahan Data Solutions

How to Pick Tools for a Data Stack (considerations)

How to Pick Tools for a Data Stack (considerations)

The Power of Naming in Data Projects (especially dbt)

The Power of Naming in Data Projects (especially dbt)

What's the value of Analytics? (getting buy-in)

What's the value of Analytics? (getting buy-in)

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

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

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

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

4 Reasons Why You Should STILL Learn SQL

4 Reasons Why You Should STILL Learn SQL

Data Warehouse Security w/ 4 Simple Roles

Data Warehouse Security w/ 4 Simple Roles

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

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

What is Data Mesh?

What is Data Mesh?

How to Build Incremental Models | dbt tutorial

How to Build Incremental Models | dbt tutorial

Modern Data Engineering Workflows, Explained

Modern Data Engineering Workflows, Explained

Data Architecture 101: Kappa (Real-Time Data)

Data Architecture 101: Kappa (Real-Time Data)

How to Refresh Data Models Daily (for free)

How to Refresh Data Models Daily (for free)

How to Sync PostgreSQL Data w/ Airbyte

How to Sync PostgreSQL Data w/ Airbyte

Data Architecture 101: The Lambda Strategy

Data Architecture 101: The Lambda Strategy

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

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

Common Data Team Structures (Engineer vs Analyst vs Scientist)

Common Data Team Structures (Engineer vs Analyst vs Scientist)

Data Architecture 101: The Modern Data Warehouse

Data Architecture 101: The Modern Data Warehouse

Why Data Migrations Go Wrong (3 reasons)

Why Data Migrations Go Wrong (3 reasons)

What are "intermediate" models in dbt?

What are "intermediate" models in dbt?

dbt Environments vs Targets | What's the Difference?

dbt Environments vs Targets | What's the Difference?

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

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

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

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

3 Ways to Deploy Data Projects

3 Ways to Deploy Data Projects

The Importance of Virtual Environments for Data Engineers

The Importance of Virtual Environments for Data Engineers

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

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

Data Engineer | Employee vs Consultant (4 differences)

Data Engineer | Employee vs Consultant (4 differences)

Modern vs Traditional Data Stacks (3 differences)

Modern vs Traditional Data Stacks (3 differences)

Why Your Data Team Needs Version Control

Why Your Data Team Needs Version Control

How to use dbt Snapshots to track data history

How to use dbt Snapshots to track data history

Getting Started with Prefect | Task Orchestration & Data Workflows

Getting Started with Prefect | Task Orchestration & Data Workflows

dbt Project Naming Conventions (recommended approach)

dbt Project Naming Conventions (recommended approach)

How to use dbt Operators to run dynamic commands

How to use dbt Operators to run dynamic commands

How to use Exposures in dbt

How to use Exposures in dbt

The Hidden Cost of Open Source

The Hidden Cost of Open Source

Stand Out as a Data Engineer w/ Free Tools

Stand Out as a Data Engineer w/ Free Tools

Data Modeling Tutorial: Star Schema (aka Kimball Approach)

Data Modeling Tutorial: Star Schema (aka Kimball Approach)

3 Time-Saving dbt Cloud Features (for free)

3 Time-Saving dbt Cloud Features (for free)

Snowflake vs BigQuery | What's Different?

Snowflake vs BigQuery | What's Different?

The 3 Pillars of Data Engineering

The 3 Pillars of Data Engineering

Cloud Data Storage Temperatures, explained

Cloud Data Storage Temperatures, explained

Send Slack Messages from your Data Warehouse (no code)

Send Slack Messages from your Data Warehouse (no code)

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

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

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

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

Intro to dbt Cloud // Use Free for Life

Intro to dbt Cloud // Use Free for Life

Getting Started w/ BigQuery!

Getting Started w/ BigQuery!

What do you actually do as a data engineer?

What do you actually do as a data engineer?

How to Enable SSO on Snowflake | Azure AD

How to Enable SSO on Snowflake | Azure AD

dbt & Reverse ETL | Census Integration & CI Checks

dbt & Reverse ETL | Census Integration & CI Checks

Getting Started w/ Metabase | Open Source Data Visualization Tool

Getting Started w/ Metabase | Open Source Data Visualization Tool

How to Sync Snowflake Users w/ Azure Active Directory

How to Sync Snowflake Users w/ Azure Active Directory

Data Modeling in the Modern Data Stack

Data Modeling in the Modern Data Stack

How to use SnowSQL | Install, Config & Query

How to use SnowSQL | Install, Config & Query

How to Host a Website on GitHub Pages | Step-By-Step

How to Host a Website on GitHub Pages | Step-By-Step

Getting Started w/ Airbyte! | Open Source Data Integration

Getting Started w/ Airbyte! | Open Source Data Integration

Data Warehouse vs Data Lake | Explained (non-technical)

Data Warehouse vs Data Lake | Explained (non-technical)

How to use managed repos on dbt Cloud

How to use managed repos on dbt Cloud

How to use values from a Database | SSIS Tutorial

How to use values from a Database | SSIS Tutorial

How to "Reverse ETL" w/ Census | Census Tutorial

How to "Reverse ETL" w/ Census | Census Tutorial

What tools should you know as a Data Engineer?

What tools should you know as a Data Engineer?

What is Reverse ETL?

What is Reverse ETL?

What skills do you need as a Data Engineer?

What skills do you need as a Data Engineer?

3 Must-Know Trends for Data Engineers | DataOps

3 Must-Know Trends for Data Engineers | DataOps

5 helpful Excel features for data engineers

5 helpful Excel features for data engineers

A simple 4-step process for creating dbt models

A simple 4-step process for creating dbt models

Intro to BASH // Command Line for Beginners

Intro to BASH // Command Line for Beginners

Improve SQL Performance w/ Indexes

Improve SQL Performance w/ Indexes

A typical GitHub workflow // what to expect

A typical GitHub workflow // what to expect

How to use the dbt "analyses" directory

How to use the dbt "analyses" directory

5 Tips for Snowflake (built-in features)

5 Tips for Snowflake (built-in features)

How to Create a Data Extract on Tableau

How to Create a Data Extract on Tableau

Tableau Overview (Crash Course)

Tableau Overview (Crash Course)

How to Become a Data Engineer (with no experience)

How to Become a Data Engineer (with no experience)

A Brief History of Data Engineering | What is Data Engineering?

A Brief History of Data Engineering | What is Data Engineering?

What is Data Streaming?

What is Data Streaming?

How to use ONE dbt project for all environments

How to use ONE dbt project for all environments

ETL vs ELT | Modern Data Architectures

ETL vs ELT | Modern Data Architectures

5 Tips to Improve Your dbt Project

5 Tips to Improve Your dbt Project

YAML Tutorial | Learn YAML in 10 Minutes

YAML Tutorial | Learn YAML in 10 Minutes

Use Outputs to Share Data Between Jobs // GitHub Actions

Use Outputs to Share Data Between Jobs // GitHub Actions

Handle JSON with dbt // jinja & macros

Handle JSON with dbt // jinja & macros

How to use dbt (data-build-tool) on Fivetran!

How to use dbt (data-build-tool) on Fivetran!

Data Transformations on Fivetran // ETL vs ELT

Data Transformations on Fivetran // ETL vs ELT

How to Use Git w/ Azure Data Factory

How to Use Git w/ Azure Data Factory

How to Use CSV's on SQL Server

How to Use CSV's on SQL Server

How to Use Azure Data Factory

How to Use Azure Data Factory

5 Tips for Better SQL

5 Tips for Better SQL

How to Release Code With Github

How to Release Code With Github

How to Create Azure SQL Databases

How to Create Azure SQL Databases

Azure for BIG DATA // blob & file storage

Azure for BIG DATA // blob & file storage

Best Practices for Managing Azure Resources

Best Practices for Managing Azure Resources

How to start using Azure...FOR FREE

How to start using Azure...FOR FREE

How to use the "Q&A" Feature on Power BI

How to use the "Q&A" Feature on Power BI

How to use the Performance Analyzer on Power BI

How to use the Performance Analyzer on Power BI

Discovering the Power BI "Help" ribbon

Discovering the Power BI "Help" ribbon

How to Use Power BI Report Themes

How to Use Power BI Report Themes

How do EPHEMERAL dbt models work?

How do EPHEMERAL dbt models work?

How to set the order of your GitHub Action jobs

How to set the order of your GitHub Action jobs

An EASY way to run/test models in groups

An EASY way to run/test models in groups

Create custom JSON w/ Snowflake

Create custom JSON w/ Snowflake

Set environment variables // GitHub Actions

Set environment variables // GitHub Actions

Get Started With Github Actions

Get Started With Github Actions

How to run SSIS packages

How to run SSIS packages

Data Generation w/ Snowflake

Data Generation w/ Snowflake

How to "clean" your dbt project files

How to "clean" your dbt project files

How to use Variables in Snowflake

How to use Variables in Snowflake

Install dbt in a virtual environment // best practice

Install dbt in a virtual environment // best practice

$Audit your dbt runs by using {{ invocation_id }}$

Audit your dbt runs by using {{ invocation_id }}

The multi-repo approach // how to structure dbt projects

The multi-repo approach // how to structure dbt projects

Load CSV data to create a new table in Snowflake

Load CSV data to create a new table in Snowflake

How to use Snowflake query tags in dbt

How to use Snowflake query tags in dbt

Use the dbt "state" method to only run modified models

Use the dbt "state" method to only run modified models

What is a GIST on GitHub?

What is a GIST on GitHub?

Use templates to standardize your Pull Requests

Use templates to standardize your Pull Requests

Connect to Snowflake as a Linked Server // ODBC

Connect to Snowflake as a Linked Server // ODBC

How to create a new branch on GitHub // Commit & Push

How to create a new branch on GitHub // Commit & Push

Create and clone a new repository on GitHub

Create and clone a new repository on GitHub

Getting started with GitHub!

Getting started with GitHub!

Implement Roles in a SSAS Tabular Cube

Implement Roles in a SSAS Tabular Cube

Store Terraform state in the cloud // configure "backends"

Store Terraform state in the cloud // configure "backends"

Create dynamic labels in Power BI using DAX

Create dynamic labels in Power BI using DAX

Create a drill-through in Power BI

Create a drill-through in Power BI

Process a SSAS Tabular Cube // Multiple Ways

Process a SSAS Tabular Cube // Multiple Ways

How to monitor your source freshness in dbt

How to monitor your source freshness in dbt

Simplify dbt documentation with docs blocks

Simplify dbt documentation with docs blocks

Use the Cache transform for faster look-ups in SSIS

Use the Cache transform for faster look-ups in SSIS

Using Fuzzy Lookup and Grouping in SSIS

Using Fuzzy Lookup and Grouping in SSIS

Working with JSON in Snowflake

Working with JSON in Snowflake

Data visualization in Snowflake // Snowsight

Data visualization in Snowflake // Snowsight

Create an external data stage (Azure) on Snowflake

Create an external data stage (Azure) on Snowflake

Monitor Snowflake query history, execution plan and query profile

Create zero-copy clones on Snowflake

Create zero-copy clones on Snowflake

Use hooks to simplify repetitive dbt run activities

Use hooks to simplify repetitive dbt run activities

Using Parameters in Power BI

Using Parameters in Power BI

How to Sync slicers across pages in Power BI

How to Sync slicers across pages in Power BI

What are Hierarchies in Power BI?

What are Hierarchies in Power BI?

Get started on Power BI! // Get data & create a visual

Get started on Power BI! // Get data & create a visual

What are Relationships on Power BI?

What are Relationships on Power BI?

Ways to customize a Column Chart in Power BI

Ways to customize a Column Chart in Power BI

Bookmarks, Selections and Buttons on Power BI

Bookmarks, Selections and Buttons on Power BI

What is Terraform "state"?

What is Terraform "state"?

Simplify your Terraform code w/ "for_each"

Simplify your Terraform code w/ "for_each"

Understanding access control & roles on Snowflake

Understanding access control & roles on Snowflake

Add dbt project variables & use them in models

Add dbt project variables & use them in models

Create custom tests or override defaults

Create custom tests or override defaults

Connect to Snowflake through Microsoft Excel // ODBC

Connect to Snowflake through Microsoft Excel // ODBC

Load CSV files with the Upload feature on Fivetran

Load CSV files with the Upload feature on Fivetran

Getting Started with Fivetran! // setup connectors

Getting Started with Fivetran! // setup connectors

Working w/ Reader Accounts & Data Shares on Snowflake

Working w/ Reader Accounts & Data Shares on Snowflake

Getting started w/ Snowflake!

Getting started w/ Snowflake!

Use dbt Seeds to work with static CSV data

Use dbt Seeds to work with static CSV data

How to keep your computer active w/ Python! (auto-move mouse)

How to keep your computer active w/ Python! (auto-move mouse)

Python virtual environments // best practice

Python virtual environments // best practice

Get started with Python! // Install, Download & Run

Get started with Python! // Install, Download & Run

5 Ways to Improve Your SQL Queries

5 Ways to Improve Your SQL Queries

How to "Destroy" resources from Terraform

How to "Destroy" resources from Terraform

Use variables to simplify your Terraform code

Use variables to simplify your Terraform code

Initialize a Terraform project & create resources!

Initialize a Terraform project & create resources!

Get started with Terraform!

Get started with Terraform!

Create a Lambda function on AWS!

Create a Lambda function on AWS!

Create a data Firehose on AWS // Kinesis streaming

Create a data Firehose on AWS // Kinesis streaming

Create a data stream on AWS w/ Kinesis!

Create a data stream on AWS w/ Kinesis!

Create an IAM Role and Policy on AWS!

Create an IAM Role and Policy on AWS!

AWS Data Migration Service (DMS) // MySQL to S3

AWS Data Migration Service (DMS) // MySQL to S3

Create a MySQL database on AWS!

Create a MySQL database on AWS!

How to create S3 buckets on AWS // cloud data storage

How to create S3 buckets on AWS // cloud data storage

View your dbt documentation as a website

View your dbt documentation as a website

Package management and dbt Hub // packages.yml

Package management and dbt Hub // packages.yml

Change the materialization (aka how dbt models deploy)

Change the materialization (aka how dbt models deploy)

How to test and debug your dbt models

How to test and debug your dbt models

How does dbt actually compile queries?

How does dbt actually compile queries?

Deploy to custom schemas & override dbt defaults

Deploy to custom schemas & override dbt defaults

Add raw "sources" to your dbt project

Add raw "sources" to your dbt project

Intro to Data Build Tool (dbt) // Create your first project!

Intro to Data Build Tool (dbt) // Create your first project!

How to run Python in SSIS!

How to run Python in SSIS!

How to use the For Each Loop in SSIS

How to use the For Each Loop in SSIS

Using Multicast, Lookups and Union All in SSIS

Using Multicast, Lookups and Union All in SSIS

Using variables and parameters in SSIS

Using variables and parameters in SSIS

Managing environment connections in SSIS

Managing environment connections in SSIS

Create a Derived (custom) Column in SSIS

Create a Derived (custom) Column in SSIS

Easily import CSV data using SSIS

Easily import CSV data using SSIS

Execute SQL commands through SSIS

Execute SQL commands through SSIS

Row-Level Security on a SSAS Tabular Cube

Row-Level Security on a SSAS Tabular Cube

Customize visibility on SSAS Tabular Cubes // Perspectives

Customize visibility on SSAS Tabular Cubes // Perspectives

Relationships in SSAS Tabular Models

Relationships in SSAS Tabular Models

Add a Hierarchy to a SSAS Tabular Model

Add a Hierarchy to a SSAS Tabular Model

Add Partitions to a SSAS Tabular Model

Add Partitions to a SSAS Tabular Model

Add Calculated Columns to a SSAS Tabular Model

Add Calculated Columns to a SSAS Tabular Model

Measures and Measure Groups on SSAS Tabular Models

Measures and Measure Groups on SSAS Tabular Models

Create and deploy a Tabular Cube w/ SSAS!

Create and deploy a Tabular Cube w/ SSAS!

How to Install Report Builder // step-by-step

How to Install Report Builder // step-by-step

Create a Tabular Cube with SSAS! // step-by-step

Create a Tabular Cube with SSAS! // step-by-step

Create data visualizations w/ Power BI

Create data visualizations w/ Power BI

How to use T-SQL to write queries and create objects

How to use T-SQL to write queries and create objects

Create an ETL package with SSIS! // step-by-step

Create an ETL package with SSIS! // step-by-step

Configure SQL Server Reporting Services (SSRS)

Configure SQL Server Reporting Services (SSRS)

Create Views in SQL Server using T-SQL

Create Views in SQL Server using T-SQL

Install Visual Studio & SQL Server Data Tools

Install Visual Studio & SQL Server Data Tools

Create Functions in SQL Server using T-SQL

Create Functions in SQL Server using T-SQL

Create Stored Procedures in SQL Server using T-SQL

Create Stored Procedures in SQL Server using T-SQL