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.
PythonFoundation
Validating and Profiling a New Dataset with pandas: Row Counts, Distributions, and Outlier Checks Before You Analyze
Jumping straight into analysis on a new dataset is one of the most common — and costly — mistakes in data work. This lesson teaches you a systematic profiling workflow using pandas: checking shape, completeness, duplicates, distributions, and outliers before a single aggregation runs.
15 min read
Power AutomateFoundation
Using the Power Automate Desktop Action Library: Essential Built-In Actions for File, Window, and Application Control
Learn how to use Power Automate Desktop's built-in action library to launch applications, manage windows, and manipulate files with confidence. This lesson takes you from the basics of the action library structure to building a complete, realistic file-processing automation from scratch.
17 min read
Power AppsFoundation
Configuring Model-Driven App Site Maps: Navigation Areas, Groups, and Subareas for Role-Based Menu Structures
A poorly structured site map makes even great apps unusable. Learn how to design navigation Areas, Groups, and Subareas from scratch — and wire them to security roles so each user sees exactly the menu they need, nothing more.
18 min read
Microsoft FabricFoundation
Monitoring Fabric Capacity Usage and Pipeline Activity with the Monitoring Hub
When pipelines run slow or fail silently, you need more than hope — you need visibility. This lesson teaches you how to use the Fabric Monitoring Hub and Capacity Metrics app to track activity, diagnose failures, and understand what your workloads are actually costing your capacity.
17 min read
PythonFoundation
Combining and Stacking Multiple Excel or CSV Files into One pandas DataFrame
Stop copying and pasting data between spreadsheets. Learn how to automatically find, read, and combine dozens of CSV or Excel files into a single pandas DataFrame using glob, pathlib, and pd.concat — with source tracking built in.
15 min read
Power AutomateFoundation
Capturing and Replaying Mouse Clicks and Keystrokes with the Power Automate Desktop Recorder
The Power Automate Desktop Recorder converts your mouse clicks and keystrokes into reusable automation steps — no coding required. Learn how to record, clean up, and reliably replay desktop interactions in this hands-on foundation lesson.
16 min read
Power AppsFoundation
Model-Driven App Security: Configuring Security Roles, Field Permissions, and Team-Based Access for Table Data
Learn how to secure your model-driven app from the ground up. This lesson walks through creating security roles, applying column-level security profiles, and using team-based access — so the right people see exactly the right data.
20 min read
Microsoft FabricFoundation
Loading Data into a Fabric Lakehouse with the Pipeline Copy Activity: Connecting to REST APIs, Blob Storage, and SQL Sources
Learn how to use Microsoft Fabric's Pipeline Copy Activity to ingest data from REST APIs, Azure Blob Storage, and Azure SQL databases into a Lakehouse. This hands-on lesson walks through real configuration steps, explains every key decision, and covers common pitfalls so your first ingestion pipeline actually works.
19 min read
PythonFoundation
Building and Automating Recurring Reports with pandas: Scheduling Scripts to Run Without You
Learn how to turn a pandas analysis into a fully automated report that runs on a schedule, handles errors gracefully, and notifies you when something goes wrong — all without you lifting a finger. This lesson covers script structure, logging, email alerts, and both Windows and Mac/Linux scheduling.
16 min read
Power AutomateExpert
Monitoring and Troubleshooting Desktop Flow Runs at Scale
When you're running dozens of unattended bots across a machine fleet, "check the portal" stops being a monitoring strategy. Learn how to build production-grade observability for Power Automate desktop flows — from structured telemetry and automated alerting to systematic diagnostic frameworks for the five most common failure categories at scale.
35 min read
Power AppsExpert
Solutions for Model-Driven Apps: Publishers, Managed vs Unmanaged, and Solution Layering
Master the Dataverse solution framework from the ground up — publishers, prefixes, managed vs unmanaged deployment, and the layering algorithm that explains almost every mysterious behavior in multi-environment Power Platform projects. This is the architectural knowledge that separates professional delivery from accidental success.
31 min read
Microsoft FabricExpert
Securing and Governing Microsoft Fabric: Workspace Roles, Item Permissions, and OneLake Data Access
Fabric's security model has four distinct permission layers — and most teams only know about one of them. This deep-dive lesson teaches you how workspace roles, item permissions, and OneLake data access policies interact so you can design and audit a governance model that actually holds up in production.
29 min read