The Library · Insights
Deep dives across data, automation & AI
980 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
PythonPractitioner
Working with Dates and Time Series in pandas: Parsing, Resampling, and Rolling Windows
Dates are where real-world data gets messy and where pandas gets powerful. Learn how to parse tricky date formats, resample transactions to any frequency, and compute rolling averages and anomaly-detection bands — with production-ready patterns throughout.
21 min read
Power AppsPractitioner
Dataverse Security: Business Units, Security Roles, and Teams
Learn how to architect a production-grade Dataverse security model using business units, custom security roles, owner teams, access teams, and AAD-linked teams. This complete lesson covers real-world design patterns, privilege configuration, and troubleshooting for multi-team organizations.
24 min read
Power AutomatePractitioner
Subflows and Reusable Logic in Power Automate Desktop
Learn how to architect Power Automate Desktop flows using subflows — named, callable units of logic with formal input and output parameters. Stop copy-pasting actions and start building automations you can actually maintain.
23 min read
Microsoft FabricPractitioner
Transforming Data with Spark Notebooks in Microsoft Fabric: PySpark for Lakehouse Tables
Learn how to use PySpark in Fabric Spark notebooks to clean, enrich, and write production-quality Delta tables to your lakehouse. Covers deduplication, Delta merge, partitioning, and parameterized notebooks that plug into Data Pipelines.
20 min read
PythonPractitioner
Reshaping Data with pivot_table, melt, and stack in pandas
Learn how to transform data between wide and long formats using pandas' pivot_table, melt, and stack functions. This hands-on lesson builds real analyst fluency — with realistic datasets, composable workflows, and production-ready techniques.
19 min read
Power AppsPractitioner
Business Process Flows: Guiding Users Through Multi-Stage Processes in Power Apps
Business Process Flows (BPFs) transform inconsistent, documentation-dependent workflows into structured, in-form guidance that enforces data quality at every stage. Learn how to design, build, and deploy BPFs that actually guide users — including branching logic, stage-gating, and security configuration.
20 min read
Power AutomatePractitioner
Error Handling in Desktop Flows: On Block Error, Retry Policies, and Recovery Screenshots
Learn how to build desktop flows that handle failures gracefully using On Block Error handlers, retry policies, and automatic recovery screenshots. This lesson takes you from brittle proof-of-concept to production-ready RPA with practical, hands-on techniques.
21 min read
Microsoft FabricPractitioner
Orchestrating Loads with Fabric Data Pipelines: Copy Activities, Parameters, and Schedules
Learn how to build reliable, automated data pipelines in Microsoft Fabric from the ground up. This hands-on lesson covers Copy Activities, dynamic parameters, activity chaining with dependencies, and scheduled triggers — everything you need to load data without manual intervention.
19 min read
PythonPractitioner
Joining DataFrames with pandas merge: SQL Joins and VLOOKUP in Python
Learn how to combine DataFrames in pandas using merge() — covering inner, left, right, and outer joins, merging on different column names, and debugging the duplicate key problem that silently corrupts results. Built for Excel and SQL users who want the full picture.
16 min read
Power AppsFoundation
Business Rules in Dataverse: Validation and Field Logic Without Code
Business Rules in Dataverse let you enforce data quality and control form behavior without writing a single line of code—but scope, condition logic, and action types have sharp edges that trip up even experienced makers. This lesson goes deep on every mechanism so you can build rules that actually work in production.
31 min read
Power AutomateFoundation
Automating Legacy Windows Applications with UI Automation in Power Automate Desktop
Legacy Windows applications with no APIs and no modern interfaces are some of the hardest automation targets — and some of the most valuable. This expert-level lesson teaches you to automate them reliably using Power Automate Desktop's UI automation engine, from accessibility tree inspection to production-hardened error recovery.
33 min read
Microsoft FabricFoundation
Ingesting Data with Dataflow Gen2: Power Query Skills in Microsoft Fabric
Dataflow Gen2 is more than a drag-and-drop ETL tool — it's a Power Query runtime with query folding, a staging layer, and Delta table output built into Microsoft Fabric. This deep-dive lesson teaches you how to connect to diverse sources, write effective M transformations, maximize query folding, configure incremental refresh, and troubleshoot the failures that trip up even experienced practitioners.
31 min read