Power Query Toolkit

Use plug-and-play Power Query patterns for faster, more reliable data preparation in Excel or Power BI.

Best for

Beginners who want production-style examples
Analysts and BI developers who need reusable ingestion, cleaning, and transformation patterns

What you get

CSV, Excel, and SharePoint readers
Type-safe casting, text cleanup, error handling, dynamic expansion, and prefix-based unpivoting
Buffering examples, a staging model, and a bonus calendar generator
A sample sales dataset, JSON theme, and PDF guide

Why it helps

Build common transformations once, reuse them across projects, and reduce fragile manual query steps.

Compatibility & requirements
Requires Power Query in Microsoft Excel or Microsoft Power BI Desktop.
Sample asset note
The included sample report theme contains a placeholder logo. Replace it with your own brand before publishing a report.

€0.00

Compatibility & requirements