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
Working with Excel Ranges, Sheets, and Named Cells in Power Automate Desktop: Reading Tables, Writing Data, and Switching Worksheets Without Macros
Learn how to automate multi-sheet Excel workbooks in Power Automate Desktop without writing a single macro. This hands-on lesson covers reading tables, writing data to specific cells and ranges, navigating worksheets, and using named ranges to build flows that don't break when the spreadsheet changes.
16 min read
Microsoft FabricFoundation
Querying Lakehouse Data with the SQL Analytics Endpoint: Writing T-SQL Against Delta Tables Without a Warehouse
Every Fabric lakehouse comes with a built-in SQL interface that lets you run T-SQL against Delta tables — no warehouse required. Learn how to write queries, create views, join across tables, and connect from SSMS or Power BI, all against the same data your Spark notebooks write.
17 min read
Power AppsFoundation
Configuring Dataverse Table Relationships in Model-Driven Apps: One-to-Many, Many-to-Many, and Cascade Behaviors Explained
Learn how to configure one-to-many and many-to-many relationships in Dataverse, understand cascade behaviors that protect your data integrity, and see exactly how relationships surface inside model-driven app forms. This is the structural knowledge every Power Apps maker needs.
18 min read
PythonPractitioner
Reshaping and Analyzing Multi-Level Data in pandas: Working with MultiIndex Columns and Rows After groupby and pivot_table
MultiIndex DataFrames from groupby and pivot_table are powerful but consistently confusing — until you understand the structure. This lesson teaches you to select, flatten, stack, and unstack multi-level data through a complete sales analysis project.
19 min read
Power AutomatePractitioner
Automating SAP GUI Interactions with Power Automate Desktop: Navigating Transactions, Extracting Table Data, and Handling Session Errors
SAP GUI holds critical enterprise data but predates modern APIs by decades. This lesson shows you how to drive SAP reliably with Power Automate Desktop — navigating transactions with scripting IDs, extracting full ALV grid datasets, and building session recovery logic that keeps unattended flows running without human intervention.
24 min read
PythonFoundation
Conditional Column Creation in pandas: Adding Calculated Fields with np.where, cut, and map
Learn how to derive new columns in pandas using three essential tools: np.where for conditional logic, pd.cut for numeric binning, and .map() for lookup-style translation. By the end, you'll be able to transform raw transactional data into analysis-ready features without writing a single loop.
14 min read
Power AutomateFoundation
Automating Data Entry into Windows Desktop Applications with Power Automate Desktop: Launching Apps, Navigating Forms, and Submitting Records Reliably
Learn how to build a Power Automate Desktop flow that launches a Windows application, reads records from Excel, fills out forms field by field, and submits data reliably — even in legacy systems with no API. This hands-on lesson covers everything from UI element capture to loop structure and error recovery.
15 min read
Microsoft FabricFoundation
Writing and Running Your First PySpark Notebook in Microsoft Fabric: Reading Files, Creating Delta Tables, and Saving to the Lakehouse
Learn how to build a real PySpark notebook in Microsoft Fabric from scratch — reading CSV files from Lakehouse storage, cleaning and transforming data, and writing Delta tables that are immediately queryable via SQL. This hands-on lesson teaches Spark fundamentals in the context you'll actually use them.
17 min read
PythonPractitioner
Calculating Running Totals, Cumulative Averages, and Ranked Rows in pandas with expanding, cumsum, and rank
Learn how to build running totals, cumulative averages, and within-group rankings in pandas using cumsum, expanding, and rank. Goes beyond the basics to cover groupby integration, tie-breaking strategies, NaN handling, and a complete sales dashboard project.
19 min read
Power AutomateFoundation
Automating Windows System Dialogs and Pop-Up Handling in Power Automate Desktop: Detecting, Dismissing, and Responding to Alerts Without Breaking Your Flow
Windows dialogs and pop-ups are the silent flow-killers that freeze bots mid-run and derail production automations. This hands-on lesson teaches you exactly how to detect, respond to, and defensively handle every category of Windows dialog — from standard message boxes to file save prompts — so your flows keep running even when applications talk back.
18 min read
Microsoft FabricFoundation
Scheduling and Automating Fabric Data Pipeline Runs with Activity-Level Retries, Alerts, and Email Notifications
Learn how to turn a basic Fabric pipeline into a production-grade, self-healing automation. This lesson covers schedule triggers, activity-level retry policies, workspace alerts, and custom email notifications with dynamic content — everything you need to stop monitoring pipelines manually.
18 min read
Power AppsFoundation
Configuring Model-Driven App Views as Default Views, Quick Find Views, and Lookup Views: Controlling How Records Are Surfaced Across the App
Most model-driven app problems aren't about missing features — they're about misconfigured views. Learn how to set Default Views, Quick Find Views, and Lookup Views so records are always findable, searchable, and presented with the right context wherever they appear in your app.
18 min read