Explore Tools tutorials, practical examples, and interview preparation guides from SQLPad.
Validate each Excel file before Power Query combines a folder. Use schema checks, raw-value audits, and a gate that blocks incomplete reporting batches.
SQLPad Author
Unpivot changing month columns in Power Query with schema checks, protected dimensions, no duplicated totals, and explicit null-versus-zero rules.
SQLPad Author
