Deep dives across data, automation & AI

Stateful Multi-Turn RAG: Managing Conversation History, Context Carryover, and Session Memory Across Long User Interactions

Single-turn RAG breaks the moment users start asking follow-up questions. This deep-dive lesson teaches you how to build genuine conversational memory into your RAG pipeline — with query reformulation, rolling history compression, session persistence, and retrieval deduplication that actually works in production.

Implementing Structured Agent Memory: Building Long-Term Persistent State with Episodic, Semantic, and Working Memory Layers for Production LLM Agents

Most LLM agents are amnesiac by default — every conversation starts cold, no matter how much history exists. This deep-dive lesson teaches you to build a production-grade, three-layer memory architecture with episodic event storage, semantic fact extraction, and intelligent working memory management that makes your agents genuinely smarter over time.

Advanced SQL Anti-Patterns: Identifying and Refactoring Common Query Mistakes That Kill Performance at Scale

Slow queries rarely fail — they just silently drain your system's resources until something breaks. This expert-level guide covers eight of the most damaging SQL anti-patterns, with real execution plan analysis, refactored examples, and a practical checklist for reviewing production queries before they become incidents.

Building and Deploying Power Automate Flows That Call Azure OpenAI and AI Builder Models

Learn how to build production-grade Power Automate flows that integrate Azure OpenAI and AI Builder for real business automation — from secure authentication and structured prompt engineering to error handling, ALM promotion, and cost management. This is the complete, no-shortcuts guide to deploying AI-powered flows that actually survive production.

Canvas App Real-Time Collaboration Patterns: Record Locking, Conflict Detection, and Live Refresh with SignalR

Most Canvas Apps silently corrupt data the moment two users edit the same record. This deep-dive lesson teaches you to implement pessimistic record locking, ETag-based conflict detection, and Azure SignalR push notifications — building a complete real-time collaboration layer that works at production scale.

Implementing Power BI Bring Your Own Key (BYOK) Encryption for Enterprise Premium Datasets to Meet Regulatory Data Sovereignty Requirements

Most Power BI BYOK guides tell you what to click. This lesson explains the three-tier cryptographic key hierarchy behind it, walks you through the complete Azure Key Vault and PowerShell configuration, and gives you the audit evidence, key rotation procedures, and troubleshooting knowledge to operate it in a regulated production environment. If your CISO needs to demonstrate customer-controlled encryption to auditors, this is where you start.

DAX Virtual Tables in Practice: Using ADDCOLUMNS, SUMMARIZE, and GENERATEALL to Build Complex Aggregations Without Helper Tables

Stop cluttering your data model with helper tables. Learn how to use ADDCOLUMNS, SUMMARIZE, and GENERATEALL to build complex, multi-level aggregations entirely within DAX measures — with full coverage of context transition, performance trade-offs, and production-ready patterns.

Mastering Power BI XMLA Endpoints: Connecting External Tools, Querying Semantic Models, and Enabling Enterprise-Grade Model Management

Power BI's XMLA endpoint unlocks direct access to the Analysis Services engine underneath every Premium semantic model — enabling partition-level refresh, CI/CD deployment, calculation groups, and professional model management that the browser UI simply cannot provide. This deep-dive lesson teaches you to connect DAX Studio, Tabular Editor, and SSMS, write TMSL scripts for enterprise operations, and build a real model-as-code deployment pipeline from scratch.

Cross-Query State Management and Shared Parameter Tables in Power Query M: Centralizing Configuration for Multi-Report Deployments

Managing configuration across dozens of Power BI reports is a maintenance nightmare — unless you centralize it in M. This lesson walks you through building a production-grade shared parameter table system with environment switching, type-safe access, derived configuration, and health checking, all in native Power Query M.

Put Claude's Built-In Skills to Work: The Power User's Field Guide*

Implementing Late-Arriving Facts and Out-of-Order Record Reconciliation in Power Query

Late-arriving records silently corrupt historical data in most Power Query pipelines — and most tutorials never mention they exist. This deep-dive lesson gives you a complete architectural framework for detecting, classifying, and reconciling backdated facts using watermarks, dual-date tracking, SCD2 temporal joins, and audit log patterns.

Building a Multi-Workbook VBA Consolidation Engine: Merge, Transform, and Audit Data from Hundreds of Files Automatically

Stop spending hours manually consolidating Excel reports. This expert-level lesson walks you through building a production-grade VBA engine that opens hundreds of workbooks, validates schemas, transforms messy data into a canonical format, and writes a complete audit trail — automatically. Every architectural decision is explained so you can adapt the system to your real-world data.