Posts
All the articles I've posted.
Optimizing Power Query Buffer vs Table SelectRows Performance for Enterprise Datasets
Master Power Query buffer vs Table SelectRows performance. Learn when to materialize memory and filter efficiently to accelerate enterprise data pipelines.
Master VBA Optimize Large Dataset Copy Paste Arrays Performance for Enterprise Excel Models
Learn how to optimize large dataset copy paste operations in Excel VBA using arrays. Eliminate screen flicker, reduce execution time, and scale enterprise models.
Excel VBA: Automate SAP GUI Scripting to Export Data at Enterprise Scale
Master enterprise Excel VBA to automate SAP GUI scripting export data workflows with robust error handling, session binding, and zero clipboard dependency.
Enterprise Masterclass: Building a Power Query Recursive Function for Paginated REST API Pagination
Master Power Query recursive functions and List.Generate to ingest paginated REST APIs into Excel and Power BI with industrial robustness.