The Library · Insights
Deep dives across data, automation & AI
1253 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power QueryPractitioner
Auditing and Documenting Power Query Steps: Building Self-Describing Queries with Descriptions, Naming Conventions, and Step-Level Comments
Undocumented Power Query pipelines become maintenance nightmares fast. Learn how to use step naming conventions, inline M comments, query descriptions, and metadata records to build queries that explain themselves — to colleagues, auditors, and future you.
25 min read
Microsoft ExcelPractitioner
Building a VBA-Powered XML Import and Export Engine: Parse, Transform, and Sync Structured Data Between Excel and External Systems
Enterprise systems speak XML — and now your Excel workbooks can too. Learn to build a complete VBA engine that imports nested XML into worksheets, exports structured data back to valid XML using the DOM, and detects changes between file snapshots for real-time sync logging.
23 min read
Microsoft ExcelPractitioner
Mastering Excel's Workbook and Cell Protection: Lock Ranges, Hide Formulas, and Control Edit Access for Shared Spreadsheets
Learn how Excel's two-layer protection system actually works — and how to use it to lock formula cells, hide proprietary logic, and grant granular edit access to specific users or ranges. This is the lesson that turns a fragile shared workbook into a hardened, professional tool.
22 min read
Power AutomateFoundation
Automating OneDrive File Uploads to SharePoint with Power Automate: Triggering on New Files, Copying to the Right Library, and Notifying Your Team
Stop manually shuttling files from OneDrive to SharePoint. This hands-on lesson walks you through building a Power Automate flow that detects new uploads, copies them to the right document library, and notifies your team — automatically, every time. No prior flow experience required.
17 min read
Power AutomateExpert
Implementing Power Automate Secure Input and Output Masking for Sensitive Data Fields: Protecting Credentials, PII, and API Keys from Run History Exposure in Production Environments
Power Automate logs every action's full inputs and outputs to run history by default — including bearer tokens, API keys, and PII. This expert lesson teaches you how to implement Secure Input and Output masking strategically, architect flows to prevent sensitive data from leaking across action boundaries, and enforce masking compliance programmatically through CI/CD pipeline linting and CoE Toolkit auditing.
30 min read
Microsoft FabricPractitioner
Aggregating and Writing Summary Tables from a Fabric Lakehouse Gold Layer to a Fabric Warehouse Using Cross-Engine T-SQL Views and PySpark for Dual-Engine Reporting
Your gold layer serves Spark consumers perfectly — but your SQL analysts need pre-computed summary tables, T-SQL views, and sub-second query latency. This lesson shows you how to aggregate gold-layer Delta tables with PySpark, write results into a Fabric Warehouse via JDBC, and expose lakehouse tables as cross-engine T-SQL views — all without duplicating data or maintaining two separate pipelines.
22 min read
PythonExpert
Building a pandas Profitability Report by Product, Region, and Time Period: Joining, Aggregating, and Exporting a Multi-Dimensional Business Summary
Learn how to build a production-quality profitability report in pandas from scratch — joining transaction data to product and territory tables, engineering correct margin metrics, aggregating across multiple dimensions, and exporting a polished multi-sheet Excel workbook. This is the end-to-end report pipeline that replaces your monthly Excel ritual.
29 min read
Power AppsExpert
Configuring Dataverse Row-Level Access Teams and Access Team Templates: Dynamically Granting Per-Record Permissions Without Custom Security Roles in Model-Driven Apps
Access team templates let you grant per-record permissions dynamically — without creating new security roles or managing individual record shares. This deep-dive lesson covers template configuration, form integration, Power Automate automation, and the performance trade-offs you need to know before deploying at scale.
33 min read
Power AutomateExpert
Implementing Desktop Flow Exception Logging and Telemetry in Power Automate Desktop: Capturing Error Details, Writing Structured Logs to SQL or SharePoint, and Triggering Cloud Flow Alerts from Unattended Bot Failures
Silent bot failures at 2 AM are an architecture problem, not an ops problem. Learn how to design production-grade telemetry into your Power Automate Desktop flows — structured logs to SQL or SharePoint, reusable logging subflows, and real-time cloud flow alerts from unattended bot failures.
28 min read
Career DevelopmentPractitioner
How to Use Informational Interviews to Uncover Hidden Data Job Openings Before They're Posted
Most data jobs are filled before they ever appear on a job board. This lesson teaches you how to use informational interviews as a systematic strategy for building relationships with data professionals, surfacing hidden hiring signals, and converting warm conversations into referrals — before the competition even knows the role exists.
27 min read
AI & Machine LearningFoundation
Embedding Metadata Enrichment: Attaching Document Attributes at Ingestion to Power Filtered and Faceted Retrieval in RAG Pipelines
Most RAG systems fail not because of bad embeddings, but because they treat every document as a featureless blob of text. This lesson teaches you how to design and attach structured metadata at ingestion time, enabling filtered and faceted retrieval that returns contextually appropriate results — not just semantically similar ones.
19 min read
SQLFoundation
Combining GROUP BY with Multiple JOINs: Aggregating Across Three or More Related Tables
Most real business questions can't be answered from a single table — they require joining three or more tables together and then summarizing the result. This lesson teaches you how to plan, write, and debug multi-table aggregation queries that actually hold up under scrutiny.
17 min read