The Library · Insights
Deep dives across data, automation & AI
1261 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Microsoft FabricPractitioner
Orchestrating Loads with Fabric Data Pipelines: Copy Activities, Parameters, and Schedules
Learn how to build reliable, automated data pipelines in Microsoft Fabric from the ground up. This hands-on lesson covers Copy Activities, dynamic parameters, activity chaining with dependencies, and scheduled triggers — everything you need to load data without manual intervention.
19 min read
PythonPractitioner
Joining DataFrames with pandas merge: SQL Joins and VLOOKUP in Python
Learn how to combine DataFrames in pandas using merge() — covering inner, left, right, and outer joins, merging on different column names, and debugging the duplicate key problem that silently corrupts results. Built for Excel and SQL users who want the full picture.
16 min read
Power AppsFoundation
Business Rules in Dataverse: Validation and Field Logic Without Code
Business Rules in Dataverse let you enforce data quality and control form behavior without writing a single line of code—but scope, condition logic, and action types have sharp edges that trip up even experienced makers. This lesson goes deep on every mechanism so you can build rules that actually work in production.
31 min read
Power AutomateFoundation
Automating Legacy Windows Applications with UI Automation in Power Automate Desktop
Legacy Windows applications with no APIs and no modern interfaces are some of the hardest automation targets — and some of the most valuable. This expert-level lesson teaches you to automate them reliably using Power Automate Desktop's UI automation engine, from accessibility tree inspection to production-hardened error recovery.
33 min read
Microsoft FabricFoundation
Ingesting Data with Dataflow Gen2: Power Query Skills in Microsoft Fabric
Dataflow Gen2 is more than a drag-and-drop ETL tool — it's a Power Query runtime with query folding, a staging layer, and Delta table output built into Microsoft Fabric. This deep-dive lesson teaches you how to connect to diverse sources, write effective M transformations, maximize query folding, configure incremental refresh, and troubleshoot the failures that trip up even experienced practitioners.
31 min read
PythonFoundation
Grouping and Aggregating in pandas: groupby as the PivotTable Replacement
If you know Excel's PivotTable, you already understand what pandas groupby does — you just need to learn the mechanics. This deep-dive lesson covers split-apply-combine, agg(), transform(), apply(), multi-key grouping, reshaping results, and performance optimization on real datasets.
25 min read
Power AppsFoundation
Creating and Customizing Views in Model-Driven Apps: Filters, Sorting, and Editable Grids
Views are the primary lens users interact with in model-driven apps — and most of them are badly designed. Learn how to build purpose-built views with multi-condition filters, strategic sort orders, FetchXML for complex queries, and editable grids for inline record editing.
26 min read
Microsoft FabricFoundation
Fabric Lakehouse vs Warehouse: Choosing the Right Store for Your Workload
Both the Fabric Lakehouse and Warehouse store Delta tables in OneLake — so why does picking the wrong one cause so much pain? This lesson explains the architectural differences that actually matter and shows you how to make a confident, defensible choice for any workload.
23 min read
Power AutomateFoundation
UI Elements and Selectors in Power Automate Desktop: Building Automations That Don't Break
Broken selectors are the #1 reason RPA automations fail in production. This lesson teaches you how to read, edit, and build resilient UI element selectors in Power Automate Desktop — covering dynamic IDs, wildcard matching, timing strategies, and a systematic debugging workflow that works on real enterprise applications.
21 min read
PythonFoundation
Cleaning Messy Data with pandas: Missing Values, Duplicates, and Data Types
Real-world data is broken — currency strings, mixed date formats, duplicated rows, and missing values in five different forms. This hands-on lesson walks you through building a systematic, reusable cleaning pipeline in pandas that you can apply to any messy dataset.
19 min read
Power AppsFoundation
Designing Model-Driven Forms: Sections, Tabs, Subgrids, and Quick View Forms
A cluttered model-driven form kills adoption before your app ever gets a chance. Learn how to design professional forms using tabs, sections, subgrids, and Quick View forms — the building blocks that turn raw Dataverse data into a tool people actually want to use.
18 min read
Microsoft FabricFoundation
Building Your First Lakehouse in Microsoft Fabric: Files, Tables, and the SQL Analytics Endpoint
Learn how to create a Microsoft Fabric Lakehouse from scratch, load CSV files into both the Files and Tables zones, and query your data using the SQL Analytics Endpoint. This hands-on lesson builds the foundational skills you need for every Fabric data engineering project.
16 min read