The Library · Insights
Deep dives across data, automation & AI
94 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power QueryExpert
Parameterized Queries and Dynamic Data Sources in Power Query
Master advanced Power Query techniques for building flexible, scalable data solutions that adapt to different environments, schemas, and business requirements through intelligent parameterization.
19 min read
Power QueryPractitioner
Working with Dates and Text in Power Query: Advanced Transformation Techniques
Master Power Query's text and date functions through practical examples. Learn to parse multiple date formats, clean messy text data, and optimize performance for production workflows.
14 min read
Power QueryFoundation
Master Custom Columns and Conditional Logic in Power Query
Learn to create powerful conditional logic and custom columns in Power Query that automatically categorize data, apply business rules, and calculate derived values. Transform raw data into actionable insights with practical, real-world examples.
13 min read
Power QueryExpert
Cleaning Messy Data with Power Query: Nulls, Errors, and Type Conversions
Master advanced Power Query data cleaning techniques including error propagation systems, sophisticated null handling strategies, and performance-optimized type conversions for enterprise-scale data pipelines.
22 min read
Power QueryPractitioner
Combining Data from Multiple Sources with Append and Merge Queries in Power Query
Master the essential techniques for combining disparate data sources into unified datasets using Power Query's append and merge operations, with real-world examples and performance optimization strategies.
19 min read
Power QueryExpert
Power Query Transformations: Split, Merge, Pivot, and Unpivot - Advanced Techniques
Master Power Query's core transformation operations with advanced patterns for split, merge, pivot, and unpivot. Learn performance optimization, edge case handling, and enterprise-scale implementation strategies.
17 min read
Power QueryPractitioner
Getting Started with Power Query: Master Connect, Transform, Load for Real-World Data
Learn to build automated data preparation pipelines with Power Query. Connect to multiple sources, apply transformations that handle messy real-world data, and load results efficiently for analysis and reporting.
27 min read
Power QueryFoundation
Combining Multiple Files from a Folder
16 min read
Power QueryExpert
Writing Custom M Functions in Power Query
31 min read
Power QueryFoundation
Power Query 101: Connect, Transform, Load
18 min read