The Library · Insights
Deep dives across data, automation & AI
979 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
PythonPractitioner
Ranking and Window Calculations in pandas: Running Totals, Cumulative Averages, and Percent Rank with groupby and transform
Learn how to compute running totals, cumulative averages, rolling windows, and within-group rankings in pandas using groupby and transform. Practical examples using realistic sales data, with full copy-paste code and a complete weekly performance report you can adapt immediately.
19 min read
Microsoft FabricFoundation
Scheduling Dataflow Gen2 Refreshes and Chaining Them into a Fabric Data Pipeline for End-to-End Orchestration
Manual refreshes don't scale. Learn how to schedule Dataflow Gen2 refreshes automatically and chain them into a Fabric Data Pipeline alongside Copy Activities and Spark Notebooks — so your data is ready before your team arrives each morning.
17 min read
Power AppsExpert
Configuring Dataverse Many-to-Many Relationships with Intersect Tables in Model-Driven Apps: Custom Junction Table Attributes, Filtered Subgrids, and Advanced Relationship Behaviors
Native Dataverse M:N relationships fall short the moment your junction needs to carry data, enforce business rules, or support granular security. This expert-level lesson teaches you to design custom intersect tables from scratch — with columns, cascade behaviors, filtered subgrids, and validation logic that the platform's auto-generated junction table simply can't provide.
31 min read
Power AutomateExpert
Deploying Unattended Desktop Flows at Enterprise Scale: Machine Group Load Balancing, Queue Management, and Run Concurrency Strategies in Power Automate
Learn how Power Automate's unattended execution engine distributes work across machine groups, how to design queue policies that honor business SLAs, and how to prevent resource conflicts when dozens of bots run simultaneously. This expert-level lesson covers the architecture decisions that separate a stable enterprise RPA program from one that collapses under load.
32 min read
PythonPractitioner
Ranking and Comparing Groups in pandas: percent_rank, cumsum, and Window Functions for Running Totals and Leaderboards
Learn how to build production-grade leaderboards, percentile tiers, and running totals in pandas using rank(), cumsum(), and rolling window functions. Covers groupby-scoped ranking, month-over-month growth, and a complete sales intelligence report you can export to Excel.
18 min read
Microsoft FabricFoundation
Using Notebook Variables and Parameters in Microsoft Fabric: Passing Pipeline Values to PySpark for Dynamic Lakehouse Ingestion
Hardcoded file paths and table names don't belong in production notebooks. Learn how to use Fabric's parameter cell pattern to pass dynamic values from a data pipeline into PySpark, turning a one-time script into a reusable ingestion engine.
15 min read
Power AppsPractitioner
Configuring Dataverse Calculated Columns and Multi-Table Rollup Columns in Model-Driven Apps
Learn how to configure Dataverse calculated columns and rollup columns to aggregate related record data for forms, views, and business logic. Build an Account Health scoring system using real rollup and formula patterns with no code.
24 min read
Microsoft FabricExpert
Handling Schema Evolution in Fabric Lakehouse Delta Tables: Adding Columns, Merging Incompatible Schemas, and Enforcing Constraints Across Medallion Layers
Schema changes in production Delta lakehouses cascade across medallion layers in ways that break pipelines, corrupt reports, and silently produce wrong results. This deep-dive lesson teaches you exactly how Delta Lake enforces and evolves schemas, how to build drift detection into your pipelines, and how to use CHECK and NOT NULL constraints to enforce data quality where it matters.
29 min read
PythonExpert
Building a Multi-Source Reconciliation Report in pandas: Comparing Actuals vs. Targets, Flagging Variances, and Exporting a Stakeholder-Ready Excel Summary
Learn how to build a production-quality reconciliation pipeline in pandas that merges actuals, targets, and adjustments from multiple sources, applies tiered variance flag logic, and exports a formatted multi-sheet Excel workbook — complete with conditional formatting, frozen panes, and an executive scorecard. This is the report your CFO actually wants.
26 min read
Power AutomateFoundation
Automating Windows Desktop Application Login and Session Management in Power Automate Desktop
Learn how to launch Windows applications programmatically, handle authentication prompts reliably, and keep sessions active throughout your automation. This lesson takes you from basic app launching through production-grade credential handling and session recovery — the skills every RPA developer needs before anything else.
18 min read
Power AppsFoundation
Configuring Dataverse Table Permissions in Model-Driven Apps: Mapping Security Roles to Tables, Privileges, and Access Levels for New Makers
Misconfigured table permissions are the most common way model-driven apps go wrong after launch. This lesson teaches new makers how Dataverse security roles, privilege types, and access levels work together — with real-world examples, step-by-step role configuration, and a hands-on exercise to test your understanding.
19 min read
Microsoft FabricPractitioner
Branching Dataflow Gen2 Outputs to Multiple Destinations: Writing Transformed Data to a Lakehouse Table and a Warehouse Simultaneously
Dataflow Gen2 lets you attach multiple output destinations to a single query — run your transformation once and write results to both a Fabric Lakehouse table and a Warehouse table simultaneously. This lesson teaches you the complete pattern: from Power Query transformation to dual-destination configuration, data type gotchas, and production-ready pipeline orchestration.
22 min read