Cleaning messy CSV exports with Power Query
A detailed guide to cleaning messy csv exports with power query that explains setup, design choices, common mistakes, and how to build a more reliable workflow around CSV cleanup.
Data & Automation
Power Query
Reusable data cleanup, transformation, and reporting workflows. Each article has a visible post date and longer-form editorial content.
Merging tables in Power Query while protecting data quality
A detailed guide to merging tables in power query while protecting data quality that explains setup, design choices, common mistakes, and how to build a more reliable workflow around table merges.
Reusable Power Query steps for monthly reporting workflows
A detailed guide to reusable power query steps for monthly reporting workflows that explains setup, design choices, common mistakes, and how to build a more reliable workflow around monthly refresh.
Power Query data types that quietly break downstream reports
A detailed guide to power query data types that quietly break downstream reports that explains setup, design choices, common mistakes, and how to build a more reliable workflow around data types.
When to load Power Query results to a table, the data model, or connection only
A detailed guide to when to load power query results to a table, the data model, or connection only that explains setup, design choices, common mistakes, and how to build a more reliable workflow around load destination.