The Library · Insights
Deep dives across data, automation & AI
1253 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power QueryExpert
Implementing Custom OData Feed Clients in Power Query M: Handling Service Metadata, Entity Expansion, and Filter Pushdown for Enterprise API Integration
Go beyond the built-in OData.Feed connector and build a custom OData v4 client in Power Query M that parses service metadata, constructs filter expressions that actually push down to the server, and handles entity expansion and pagination for enterprise APIs like Business Central and Dynamics 365. This lesson teaches you the protocol-level understanding and M implementation skills to solve the real-world OData integration problems that generic connectors can't.
27 min read
Power QueryExpert
Implementing Table Relationship Validation and Referential Integrity Checks in Power Query M: Detecting Orphaned Keys and Broken Joins Before Load
Orphaned foreign keys and duplicate dimension keys silently corrupt your data model — and Power Query won't warn you. Learn to build a complete referential integrity validation framework in M that detects broken joins, surfaces diagnostic audit reports, and conditionally aborts load when violations are found.
26 min read
Microsoft ExcelExpert
Building a VBA-Powered Excel Configuration Management System: Store, Retrieve, and Version-Control Workbook Settings Using a Dedicated Config Sheet and INI-Style Architecture
Stop hardcoding paths, connection strings, and settings into your VBA procedures. This expert-level lesson walks you through building a complete, production-ready configuration management system in Excel — with INI-style architecture, type-safe retrieval, and full version history with rollback.
29 min read
Microsoft ExcelExpert
Mastering Excel's XLOOKUP with Multiple Criteria, Wildcards, and Error Handling for Professional-Grade Lookups
Go beyond basic XLOOKUP to master multi-criteria lookups using array concatenation, wildcard fuzzy matching, cascading fallback error handling, and binary search optimization. Build lookup formulas that work reliably at enterprise scale.
26 min read
Power AutomatePractitioner
Automating Recurring Team Status Reports with Power Automate: Forms, SharePoint, and Teams
Stop manually chasing weekly updates. This hands-on lesson walks you through building a complete Power Automate system that collects responses via Microsoft Forms, aggregates them in SharePoint, and delivers a formatted Adaptive Card summary to Teams every Friday — fully automated.
22 min read
Power AutomateFoundation
Establishing Power Automate Maker Onboarding Controls: Configuring Default Environment Restrictions, First-Party Connector Policies, and Trial License Boundaries
Before your first citizen developer builds their first production flow, your governance baseline needs to be in place. This lesson walks through configuring Default Environment DLP policies, classifying Microsoft first-party connectors, setting trial license boundaries, and enabling Managed Environments — so makers can move fast without creating compliance risk.
20 min read
Microsoft FabricExpert
Configuring Fabric Capacity Bursting, Throttling Behavior, and Smoothing Windows: Tuning Workload Settings to Prevent Job Failures Under Heavy Pipeline and Spark Load
When pipelines and Spark jobs collide under shared Fabric capacity, the result isn't graceful degradation — it's cascading failures. This deep-dive lesson teaches you exactly how Fabric's 10-minute smoothing window, throttling stages, and Capacity Admin settings work, and how to tune them to prevent job failures under real production load.
31 min read
PythonExpert
Detecting Seasonality and Trend Breaks in pandas: Using Rolling Z-Scores and Period-over-Period Variance to Flag Anomalies in Time Series Data
Most anomaly detection methods assume your data is stationary — but real business time series have trends, seasonality, and regime changes that make naive z-scores worse than useless. This lesson builds a complete, production-ready anomaly detection pipeline in pandas that adapts to local context, catches gradual trend breaks, and combines multiple signals into a prioritized alerting system.
28 min read
Power AppsFoundation
Configuring Dataverse Status Reasons and State Transitions: Controlling Record Lifecycle Stages and Valid Status Paths in Model-Driven Apps
Every Dataverse record has a lifecycle — but without configuration, users can jump between stages in ways that break your business rules. Learn how to define meaningful Status Reason values, enable transition enforcement, and build a governed record lifecycle that the system itself polices. Practical, from first principles, with a full hands-on exercise.
16 min read
Power AutomateFoundation
Scheduling Desktop Flow Runs with Windows Task Scheduler and the Power Automate Machine Runtime
Learn how to trigger Power Automate Desktop flows on a schedule using Windows Task Scheduler and the PAD Machine Runtime. This lesson covers session configuration for attended and unattended bots, PowerShell-based run logging, and common scheduling failure modes — with step-by-step setup you can apply immediately.
19 min read
Career DevelopmentFoundation
How to Create a Freelance Data Services One-Pager: The Single-Page PDF That Explains What You Do, Who You Help, and What to Do Next — Without a Website
Most freelancers wait for a website before marketing themselves. This lesson shows you how to build a single-page PDF that opens doors, gets forwarded by referrals, and closes discovery calls — built from a proven four-section structure with real examples throughout.
18 min read
Career DevelopmentExpert
How to Negotiate Flexible Work Arrangements, Hybrid Schedules, and Remote Options in Your First Data Role Offer Without Losing the Job
Getting a data job offer is hard enough — but asking for remote or hybrid work as a first-time hire can feel like walking a tightrope. This deep guide teaches you exactly how to research a company's real flexibility culture, frame your request to reduce hiring manager risk, time the conversation correctly relative to salary negotiation, and protect the offer even if the answer is no.
34 min read