Kahan Data Solutions

How to Enable SSO on Snowflake | Azure AD

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

Add Calculated Columns to a SSAS Tabular Model

Load CSV files with the Upload feature on Fivetran

A typical GitHub workflow // what to expect

Getting Started w/ Metabase | Open Source Data Visualization Tool

Data Modeling Tutorial: Star Schema (aka Kimball Approach)

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

Easily import CSV data using SSIS

YAML Tutorial | Learn YAML in 10 Minutes

Set environment variables // GitHub Actions

Create Functions in SQL Server using T-SQL

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

Configure SQL Server Reporting Services (SSRS)

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

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

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

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

Common Data Team Structures (Engineer vs Analyst vs Scientist)

What is Data Mesh?

Data Warehouse Security w/ 4 Simple Roles

Data Modeling in the Modern Data Stack

Best Practices for Managing Azure Resources

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

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

Understanding access control & roles on Snowflake

Snowflake vs BigQuery | What's Different?

Using variables and parameters in SSIS

Install SQL Server Management Studio // SSMS

Working with JSON in Snowflake

How to use the For Each Loop in SSIS

Getting started w/ Snowflake!

ETL vs ELT | Modern Data Architectures

Using Parameters in Power BI

How to Use Azure Data Factory

Execute SQL commands through SSIS

Install Visual Studio & SQL Server Data Tools

Add Partitions to a SSAS Tabular Model

How to use the Performance Analyzer on Power BI

Add a Hierarchy to a SSAS Tabular Model

Relationships in SSAS Tabular Models

Measures and Measure Groups on SSAS Tabular Models

Improve SQL Performance w/ Indexes

Simplify dbt documentation with docs blocks

Use the Cache transform for faster look-ups in SSIS

Load CSV data to create a new table in Snowflake

Use variables to simplify your Terraform code

What skills do you need as a Data Engineer?

What is a GIST on GitHub?

How to Use CSV's on SQL Server

Python virtual environments // best practice