Explore Tools tutorials, practical examples, and interview preparation guides from SQLPad.
Choose the right Power BI Excel export, then validate a filtered snapshot with a worked example that catches missing rows and misleading totals.
SQLPad Author
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
Use role-specific measures, event tables, and separate calendars to make Power BI date slicers return the right counts and detail rows.
SQLPad Author
Build a small dynamic RLS model, verify exact rows for each identity, and test consumer permissions before sharing Power BI reports.
SQLPad Author
Diagnose slow Power BI visuals with repeatable interactions, Performance Analyzer, verified totals, and checks for model or capacity bottlenecks.
SQLPad Author
