Tutorials — Data, Architecture & Cloud
Practical technical tutorials on Power BI, DAX, Azure, Databricks and much more.
ETL
How to clean and normalize text data in an ETL with pandas
Learn to clean and normalize text data in an ETL with pandas: trim spaces, fix capitalisation, remove ac…
How to process large CSV files in ETL with pandas
Learn how to process large CSV files in ETL with pandas and chunksize without running out of memory. A h…
How to implement SCD Type 2 in ETL: step by step
Learn to implement SCD Type 2 in an ETL pipeline to keep your dimension history. A practical, step-by-st…
How to add logging to an ETL pipeline: step by step
Learn how to add logging and monitoring to an ETL pipeline in Python: log levels, log files, metrics and…
Idempotency in ETL: re-run safely without duplicating data
Learn to make an ETL pipeline idempotent with a business key and MERGE so you can re-run it without dupl…
How to validate data quality in an ETL pipeline
Learn to validate data quality in ETL with Python and pandas: split valid rows from invalid ones and sen…
Need expert implementation?
Our team delivers end-to-end data projects — BI, cloud architecture and AI.
Book a free meeting →