Deep dives across data, automation & AI

Web Automation in Power Automate Desktop: Browser Actions, Form Filling, and Data Extraction

Learn how to build browser automation flows in Power Automate Desktop that open websites, fill in forms, and extract structured data — without writing code. This hands-on lesson walks through a realistic supplier portal scenario, covering element picking, table extraction, pagination, and timing management.

Selecting and Filtering Data in pandas: loc, iloc, and Boolean Masks

Learn the three essential tools for pulling exactly the data you need from a pandas DataFrame: loc for label-based access, iloc for position-based access, and boolean masks for filtering by condition. By the end, you'll be combining multiple conditions and selecting specific rows and columns with confidence.

Building Your First Model-Driven App: Site Map, Tables, Forms, and Views

Learn how to build a complete model-driven app from scratch — designing tables, configuring forms with subgrids and quick views, creating operational views, and building a site map that organizes everything into a deployable, role-aware application. This is the deep-dive lesson that teaches you to think in model-driven architecture, not just click through a designer.

OneLake Explained: One Copy of Data, Delta Tables, and Shortcuts

OneLake is the storage backbone of Microsoft Fabric — but understanding it deeply means going beyond the marketing pitch. This lesson covers how OneLake is physically structured, how Delta Lake transaction logs actually work, how Shortcuts virtualize data across clouds, and the operational pitfalls that will slow you down if you skip them.

Automating Excel with Power Automate Desktop: Reading, Writing, and Running Macros

Go beyond simple recordings and build production-grade Excel automation with Power Automate Desktop. Learn how to read dynamic ranges, write data tables, execute VBA macros with parameter passing, and architect multi-workbook consolidation pipelines that hold up in the real world.

Your First pandas DataFrame: Loading CSV and Excel Files and Exploring Data

Loading data into pandas is more nuanced than calling pd.read_csv() and hoping for the best. This lesson teaches you exactly how to load CSV and Excel files with precision — handling messy headers, wrong dtypes, and missing values — then gives you a professional first-look exploration workflow to audit any dataset before you touch it.

Designing a Dataverse Data Model: Relationships, Lookups, and Choice Columns

Learn how to design production-quality Dataverse schemas using the right relationship types, lookup configurations, and choice columns. This lesson goes beyond the basics to cover cascade behavior, referential integrity, and the lookup-vs-choice decision that determines your app's long-term maintainability.

Fabric Capacities and Workspaces: F SKUs, Trials, and Setting Up Your First Workspace*

Variables, Lists, and Data Tables in Power Automate Desktop: A Complete Practitioner's Guide

Master the data structures that power every real-world RPA flow. This lesson goes deep on variables, lists, and data tables in Power Automate Desktop — including type conversion, filtering, batch writes, and a full invoice processing exercise.

Python Basics for Excel Users: Variables, Lists, Dictionaries, and Loops

Already know Excel? You're closer to Python than you think. This hands-on lesson translates your spreadsheet intuition into Python fundamentals — variables, lists, dictionaries, and loops — using realistic data scenarios you'll actually encounter on the job.

Dataverse Fundamentals: Tables, Columns, and Rows Explained for Power Apps Makers

Dataverse is the cloud database that powers serious Power Apps — but only if you understand how it's organized. This lesson teaches you exactly how tables, columns, and rows work together, with hands-on exercises and real business examples that build genuine competence from scratch.

What Is Microsoft Fabric? Workloads, OneLake, and How It Fits with Power BI

Microsoft Fabric promises to end the fragmentation of modern data stacks — but what actually is it, and how does it work? This foundational lesson breaks down every Fabric workload, explains how OneLake eliminates data duplication, and shows exactly where Power BI fits into the picture.