The Library · Insights
Deep dives across data, automation & AI
980 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
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
Power AutomateFoundation
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.
18 min read
PythonFoundation
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.
14 min read
Power AppsFoundation
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.
34 min read
Microsoft FabricFoundation
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.
28 min read
Power AutomateFoundation
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.
29 min read