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.
Power AutomateFoundation
Automating Windows Clipboard Operations in Power Automate Desktop: Copying, Pasting, and Transferring Data Between Applications Without UI Interaction
Learn how to use Power Automate Desktop's clipboard actions to transfer data between Windows applications programmatically. This lesson covers Set Clipboard Text, Get Clipboard Text, keyboard simulation, timing issues, and building reliable multi-application data transfer flows from first principles.
18 min read
Power AppsExpert
Designing Dataverse Hierarchical Relationships and Rollup Security: Modeling Parent-Child Table Hierarchies, Hierarchical Security Roles, and Visualizing Tree Structures in Model-Driven Apps
Learn how to build self-referential parent-child hierarchies in Dataverse, configure hierarchical security so managers automatically inherit access to subordinates' records, set up multi-level rollup aggregation, and display interactive tree visualizations in model-driven apps. This expert-level lesson covers the architecture, edge cases, and performance trade-offs you need to get it right.
32 min read
PythonPractitioner
Comparing Periods and Calculating Month-over-Month, Year-over-Year, and Rolling Changes in pandas with shift and pct_change
Learn how to build production-quality period comparison analysis in pandas using shift and pct_change. This lesson covers MoM, YoY, and rolling metrics for single and multi-segment time series, with realistic business data and a reusable report function you can ship immediately.
19 min read
Microsoft FabricFoundation
Writing Data from a Spark Notebook to a Fabric Lakehouse Delta Table: Append, Overwrite, and Merge Patterns with PySpark
Learn the three essential write patterns for Delta tables in Microsoft Fabric: append, overwrite, and merge. This hands-on lesson teaches you exactly when to use each pattern — and how to avoid the silent data quality problems that come from choosing the wrong one.
16 min read
Power AutomateExpert
Building a Resilient Unattended RPA Orchestration Framework in Power Automate Desktop: Queue-Driven Job Dispatch, Machine Load Balancing, and Automated Recovery for 24/7 Production Bot Fleets
Most RPA deployments fail not because the bots are bad, but because the orchestration layer wasn't designed for production. This expert lesson walks you through building a complete queue-driven, self-healing bot fleet using Power Automate Work Queues, machine groups, and layered monitoring cloud flows. You'll leave with a blueprint for 24/7 automation that recovers from failures automatically and scales without babysitting.
30 min read
Microsoft FabricExpert
Implementing Row-Level Security in a Fabric Warehouse and Lakehouse SQL Analytics Endpoint: Dynamic Policies, Workspace Roles, and Testing Access as a Business User
Row-Level Security in Microsoft Fabric isn't just a T-SQL exercise — it's an architecture decision with serious implications for workspace roles, Power BI Direct Lake, and Spark access paths. This lesson walks through building dynamic RLS policies from scratch, understanding where the security envelope stops, and verifying your policies work as intended before real users hit production.
31 min read
PythonFoundation
Conditional Columns and Bucketing in pandas: Creating New Fields with np.where, cut, and map
Learn how to create new columns in pandas using np.where for conditional flags, pd.cut for numeric bucketing, and .map() for code-to-label substitution. Three essential tools that replace slow loops and Excel workarounds with fast, readable Python.
15 min read
Power AppsPractitioner
Configuring Dataverse Polymorphic Lookups and Customer Columns: Modeling Multi-Table Relationships in Model-Driven Apps
Standard lookups point to one table. But real business data is messier than that — a customer might be an Account or a Contact, an expense might belong to a Project or a Department. Learn how Dataverse polymorphic lookups, Customer columns, and Regarding columns solve this cleanly, and how to configure them end-to-end in model-driven apps.
24 min read
PythonFoundation
Reshaping Wide and Long Data for Reporting: When and How to Use melt, pivot, and unstack in pandas
Wide data is easy to read but hard to analyze. Long data is easy to analyze but hard to present. This lesson teaches you exactly when to use melt, pivot, and unstack in pandas — with realistic examples and a clear workflow for converting between formats.
14 min read
Power AutomatePractitioner
Automating Internet Explorer and Citrix-Hosted Applications in Power Automate Desktop: Selector Strategies, Session Management, and Reliable Data Extraction from Virtual Environments
Legacy systems don't give up their data easily — especially when they're running inside Citrix or IE. This lesson teaches you how to build Power Automate Desktop flows that reliably extract data from virtual environments using layered selector strategies, OCR, image recognition, and production-grade session management.
25 min read
Power AppsPractitioner
Configuring Dataverse Virtual Tables: Connecting External Data Sources to Model-Driven Apps Without Migration
Virtual tables let you surface live data from SQL Server, REST APIs, and OData services directly inside your model-driven app — no ETL, no data copy, no sync. This lesson teaches you to configure OData data sources, map columns, build cross-system relationships, and handle the security and performance challenges that come with production virtual table deployments.
26 min read
Microsoft FabricPractitioner
Parameterizing Dataflow Gen2 Queries with Pipeline Integration: Passing Dynamic Values to Power Query for Reusable Ingestion Flows
Learn how to define Power Query parameters in Dataflow Gen2 and pass runtime values from Fabric pipelines — building a single, reusable ingestion flow that adapts to different regions, time periods, or environments without duplicating logic. Includes a full hands-on exercise and troubleshooting guide.
21 min read