Deep dives across data, automation & AI

Fine-Tuning Embedding Models on Domain-Specific Data to Improve Retrieval Accuracy in RAG Pipelines

Generic embedding models don't understand your domain's vocabulary, synonyms, or conceptual relationships — and that gap silently kills retrieval accuracy. This lesson teaches you how to fine-tune a sentence transformer on your own data, from synthetic training pair generation to quantitative evaluation and production deployment.

Implementing Query Decomposition and Sub-Question Synthesis for Complex RAG Pipelines*

How to Write an Effective AI Brief: Defining Goals, Constraints, and Success Criteria Before You Prompt

Most AI interactions fail not because of bad prompts, but because of unclear thinking before the prompt is written. Learn how to build an AI Brief — a five-section framework that defines your goals, audience, format, constraints, and success criteria — so every prompt you write starts from a position of clarity.

Incremental Query Design with Watermark Tables and Change Data Capture: Tracking and Processing Only New or Modified Records in SQL Pipelines

Full-reload ETL jobs that process millions of unchanged rows are a solved problem — if you know the patterns. This lesson teaches production-grade incremental pipeline design using watermark tables and Change Data Capture, with complete SQL code for handling updates, deletes, and failure recovery.

Automating Planner Task Creation, Assignment, and Status Updates with Power Automate: End-to-End Project Workflow Integration

Learn how to build a complete Power Automate system that creates Microsoft Planner tasks from SharePoint data, assigns them using identity-aware logic, and keeps status synchronized across your entire Microsoft 365 environment. Goes beyond the basics to cover bucket ID resolution, ETag handling, approval integration, and idempotency patterns you need in production.

Canvas App Formula-Level Audit Logging: Capturing User Actions, Timestamps, and Change History to Dataverse for Compliance and Traceability

Most Canvas Apps rely on Dataverse's built-in audit log — but it doesn't capture business context, before/after field values, or read access. Learn how to build formula-level audit logging directly into your app, producing a rich, queryable change history that satisfies real compliance requirements.

Implementing Power BI Master Data Management with Shared Dimensions: Building a Single Source of Truth for Enterprise Conformed Hierarchies

Conflicting numbers across teams aren't a data quality problem — they're an architecture problem. Learn how to build a full Power BI MDM architecture using conformed dimension dataflows, a certified shared semantic layer, and cross-workspace composite models that give every team the same version of Customer, Product, and Geography.

DAX Many-to-One Aggregations with SUMMARIZECOLUMNS: Building Efficient Query-Ready Measures for Large Data Models

SUMMARIZECOLUMNS is the function Power BI uses to execute every visual query — and most practitioners never learn to write it deliberately. This lesson teaches you to design efficient many-to-one aggregations, add hierarchical subtotals with ROLLUPADDISSUBTOTAL, and build measures that cooperate with the VertiPaq engine instead of fighting it.

Mastering Power BI Conditional Formatting: Dynamic Colors, Data Bars, and Icon Sets Driven by DAX Measures

Go beyond static rules and build conditional formatting that responds to slicers, time intelligence, and multi-metric business logic. This lesson teaches you every formatting type — background color, font color, data bars, and icon sets — all driven by DAX measures you write yourself.

Implementing Web Scraping and Dynamic HTML Table Extraction Pipelines in Power Query M: Parsing Nested Structures, Handling Anti-Patterns, and Building Resilient Selectors

Go beyond Power Query's default web connector and build production-grade HTML scraping pipelines in M. This lesson covers nested table navigation, merged-cell handling, resilient column selectors, and JavaScript-rendered page extraction — with complete, copy-paste-ready code throughout.

Orchestrating Multi-Query Refresh Dependencies in Power Query: Controlling Load Order and Isolating Volatile Sources for Reliable Pipeline Execution

When Power Query evaluates a complex pipeline, it decides what to refresh, when, and how many times — unless you architect it otherwise. This lesson teaches you how to take control of evaluation order, buffer volatile sources like APIs and SharePoint lists, and build pipelines that are deterministic and reliable in production.

Building a Real-Time Excel Dashboard with Power Query and VBA: Automate Data Refresh, Exception Alerts, and Conditional Formatting for Operational Monitoring

Learn how to build a self-refreshing operational dashboard in Excel that combines Power Query data pipelines, VBA-driven scheduling with Application.OnTime, automated exception detection, and dynamic conditional formatting — all wired together to catch problems before they become crises.