Deep dives across data, automation & AI

Getting Started with Power Query: Master Connect, Transform, Load for Real-World Data

Learn to build automated data preparation pipelines with Power Query. Connect to multiple sources, apply transformations that handle messy real-world data, and load results efficiently for analysis and reporting.

Power Automate Triggers: When to Start a Flow

Master the distributed infrastructure behind Power Automate triggers. Learn advanced patterns for reliable automation, performance optimization, and enterprise-scale trigger management that goes far beyond basic event handling.

Power Apps Controls: Galleries, Forms, and Data Tables - Advanced Architecture and Performance

Master the deep architecture of Power Apps data controls with advanced delegation strategies, performance optimization techniques, and enterprise-scale patterns for galleries, forms, and data tables.

Your First Power Automate Flow: Automated Email Notifications That Actually Work

Build production-ready notification flows that intelligently route emails, handle errors gracefully, and scale with your business. Learn the patterns that separate reliable automation from brittle scripts.

Your First Power App: Build a Data Entry Form in 30 Minutes

Learn to build a complete equipment maintenance form with photo capture, data validation, and SharePoint integration. Deploy your first production Power App today.

Building Your First RAG Pipeline

Automate Email Notifications with Power Automate

Understanding DAX: CALCULATE and Filter Context

Common Table Expressions (CTEs) for Cleaner SQL

AI Agents: From Concept to Implementation

Using the OpenAI API with Python

Introduction to dbt (Data Build Tool)