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 QueryPractitioner
M Language Performance Patterns and Anti-Patterns: Optimize Power Query for Speed
Master the performance patterns that make M Language queries blazingly fast and eliminate the anti-patterns that kill query folding. Learn memory management, join optimization, and debugging techniques for production-ready Power Query solutions.
15 min read
Power QueryFoundation
Working with JSON and XML Data Sources in M: Complete Foundation Guide
Master Power Query's M language functions for parsing and transforming JSON and XML data into analysis-ready tables. Learn practical techniques for handling nested structures, missing fields, and common data quality issues.
13 min read
Power QueryExpert
Advanced JSON and XML Processing in Power Query M Language
Master sophisticated techniques for processing semi-structured data in M, including recursive navigation, namespace handling, performance optimization, and building resilient transformation pipelines for production systems.
27 min read
Power QueryFoundation
Dynamic Queries with M: Build Flexible, Reusable Transformations
Learn to create Power Query transformations that adapt based on parameters, building reusable data processing engines that scale across different scenarios and requirements.
14 min read
Power QueryExpert
Error Handling and Try-Otherwise Patterns in M: Building Production-Ready Power Query Solutions
Master advanced error handling in M language with comprehensive strategies for building robust, production-grade Power Query solutions that gracefully handle failures and adapt to changing data conditions.
29 min read
Power QueryPractitioner
Advanced Table Operations: Group, Join, and Transform in M Language
Master sophisticated table manipulation in Power Query M including custom aggregations, complex joins, and dynamic transformations for professional data analysis workflows.
15 min read
Power QueryFoundation
List and Record Operations in M: Transform, Select, and Combine Data Structures
Master the fundamental list and record operations in Power Query's M language. Learn to transform nested data, select specific elements, and combine complex data structures with practical, real-world examples.
14 min read
Power QueryPractitioner
Writing Custom M Functions from Scratch in Power Query
Master the art of building reusable, production-ready M functions that transform how you work with Power Query. Learn advanced parameter handling, error management, and optimization techniques through practical examples.
13 min read
Power QueryFoundation
M Language Fundamentals: Syntax, Types, and Expressions for Power Query
Master the building blocks of M Language with practical examples. Learn syntax rules, data types, and expression construction to write powerful Power Query transformations.
12 min read
Power QueryFoundation
Power Query Performance: Master Folding, Buffering & Optimization Techniques
Learn how query folding works, when Power Query buffers data, and optimization techniques that transform slow refreshes into lightning-fast data pipelines. Essential skills for building scalable Power Query solutions.
13 min read
Power QueryExpert
Loading Data from APIs and Web Pages with Power Query
Master advanced techniques for building robust, automated pipelines that extract data from any web source, handle authentication complexities, and maintain themselves even when APIs evolve.
23 min read
Power QueryPractitioner
Power Query Best Practices for Maintainable ETL
Build Power Query ETL solutions that your future self will thank you for. Learn modular design, parameter management, error handling, and testing strategies that create robust, scalable data pipelines.
24 min read