Tutorials — Data, Architecture & Cloud
Practical technical tutorials on Power BI, DAX, Azure, Databricks and much more.
ELT
How to flatten nested JSON in ELT: step by step
Learn to flatten nested JSON in ELT with SQL Server's OPENJSON function: load the raw JSON and turn it i…
How to do an idempotent upsert in ELT with MERGE
Learn to build idempotent ELT loads with the MERGE statement: a practical SQL upsert example to update a…
How to audit data loads in ELT: step by step
Learn how to audit data loads in ELT using audit columns and a SQL log table. Track the source, row coun…
How to test data quality in ELT: step by step
Learn to test data quality in ELT with simple SQL queries: nulls, duplicates, integrity and freshness, c…
How to implement SCD Type 2 in ELT: step by step
Learn how to implement an SCD Type 2 dimension in ELT with SQL and store the full history of changes, wi…
How to Remove Duplicates in ELT: Step by Step
Learn how to remove duplicates in ELT in the transformation layer with ROW_NUMBER() and QUALIFY. Practic…
Need expert implementation?
Our team delivers end-to-end data projects — BI, cloud architecture and AI.
Book a free meeting →