The Library · Insights
Deep dives across data, automation & AI
978 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Microsoft FabricPractitioner
Configuring OneLake Shortcuts to a Fabric Lakehouse as the Data Source for a Fabric Warehouse: Avoiding Data Duplication While Enabling T-SQL Queries Across Both Engines
Learn how to create OneLake shortcuts in a Fabric Warehouse that point to lakehouse Delta tables — enabling T-SQL queries across both engines with zero data duplication. This lesson covers the full pattern from shortcut creation to cross-engine joins, security configuration, metadata sync, and performance tuning.
24 min read
Power AutomateExpert
Automating Outlook Desktop Client Operations with Power Automate Desktop: Reading Emails, Extracting Attachments, and Triggering Actions Based on Message Content Without Cloud Connectors
Learn how to build production-grade desktop flows that read Outlook emails, extract attachments, parse message content with regex, and trigger downstream actions — all through COM automation without requiring cloud connectors or Exchange API access. A complete expert-level guide covering edge cases, error handling, and enterprise hardening.
27 min read
Microsoft FabricExpert
Automating Fabric Lakehouse Metadata Refresh with Semantic Link: Syncing Delta Table Schema Changes to a Direct Lake Semantic Model Using Python and the Fabric REST API
Delta tables evolve constantly, but Direct Lake semantic models don't automatically follow. Learn how to detect schema drift between your gold-layer tables and your Power BI model, then trigger a targeted metadata refresh using Python, sempy, and the Fabric REST API — all from inside a Fabric notebook you can drop into any pipeline.
27 min read
Power AutomateExpert
Automating Windows Credential Manager and Vault Operations in Power Automate Desktop: Storing, Retrieving, and Rotating Application Passwords for Secure Unattended Bot Authentication
Hardcoded passwords in RPA bots are a security crisis waiting to happen. Learn how to use Windows Credential Manager and PowerShell P/Invoke to store, retrieve, and rotate application credentials securely inside Power Automate Desktop flows — with automatic rollback when rotation fails.
27 min read
PythonExpert
Segmenting Customers with RFM Analysis in pandas: Calculating Recency, Frequency, and Monetary Scores from Transaction Data
Learn how to transform raw transaction data into a fully scored, segmented customer table using RFM analysis in pandas. This lesson covers every step — from groupby aggregation to quantile scoring to production-ready pipeline design — with realistic code and edge case handling that most tutorials skip entirely.
28 min read
Microsoft FabricPractitioner
Implementing a Fabric Notebook-Based Data Quality Framework: Validating Row Counts, Null Thresholds, and Referential Integrity Across Medallion Layers Before Pipeline Promotion
Bad data that passes silently through your medallion pipeline is worse than a pipeline that fails loudly. This lesson walks you through building a reusable PySpark quality framework in Microsoft Fabric that validates row counts, null rates, and referential integrity at each layer — and wires the results into your pipeline so failures actually stop promotion.
22 min read
Power AutomateExpert
Automating FTP and SFTP File Transfers in Power Automate Desktop: Connecting to Remote Servers, Uploading Batch Files, and Handling Transfer Errors in Unattended RPA Workflows
FTP and SFTP automation in Power Automate Desktop goes far beyond drag-and-drop upload actions — production-grade workflows require protocol awareness, secure credential management, per-file verification, and layered error handling. This lesson teaches you to build unattended transfer automation that handles real-world failures reliably, including the PowerShell/WinSCP path for SFTP that PAD's native actions don't cover.
29 min read
Microsoft FabricExpert
Unpivoting, Aggregating, and Reshaping Lakehouse Data in Dataflow Gen2: Advanced Power Query Transformations Before Writing to Delta Tables
Learn how to use advanced Power Query M techniques in Dataflow Gen2 to unpivot wide source data, aggregate with Table.Group, and reshape tables into clean, typed Delta table schemas in your Microsoft Fabric lakehouse. This lesson covers the full M query structure, type-fixing patterns, and the honest trade-offs between Dataflow Gen2 and Spark for complex transformations.
27 min read
PythonExpert
Building a Self-Updating Sales Dashboard in pandas and openpyxl: Automated Charts, Conditional Formatting, and Named Ranges from a Live Data Source
Learn how to build a professional Excel sales dashboard that regenerates itself from a live data source using pandas and openpyxl. Covers automated chart generation, four types of conditional formatting, named ranges, and Excel Tables — all from a clean, schedulable Python script.
24 min read
Power AppsExpert
Configuring Dataverse Managed Properties and Solution Component Locking: Controlling Customizability, Preventing Downstream Modifications, and Enforcing ISV-Grade Solution Boundaries in Model-Driven Apps
Managed properties are Dataverse's mechanism for declaring exactly what downstream consumers can modify after your managed solution is installed — and most ISVs configure them wrong. This expert-level lesson covers the full component taxonomy, XML-level configuration, solution layering interactions, and a practical boundary strategy for building platform-grade solutions.
28 min read
Microsoft FabricExpert
Joining Multiple Delta Tables Across Fabric Lakehouses and Warehouses in a Single Spark Notebook: Cross-Workspace Queries, OneLake Paths, and Writing Results to a Gold Layer Table
Learn how to read Delta tables from multiple Fabric workspaces — across lakehouses and warehouses — in a single PySpark notebook. This expert lesson covers OneLake ABFS path construction, programmatic GUID resolution, multi-table joins with broadcast optimization, and writing results to a gold-layer Delta table using overwrite and MERGE patterns.
24 min read
Power AutomateExpert
Implementing Dynamic Selector Repair and Fallback Strategies in Power Automate Desktop: Detecting Broken UI Elements at Runtime and Switching to Alternative Identification Methods Without Flow Failure
UI changes break RPA bots — but they don't have to break your flows. This expert-level lesson teaches you how to build cascading fallback chains in Power Automate Desktop that detect broken selectors at runtime, attempt dynamic repair, and gracefully degrade through image recognition and OCR before ever raising a fatal error.
25 min read