The Library · Insights
Deep dives across data, automation & AI
979 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
PythonPractitioner
Building Summary Reports with pandas pivot_table and to_excel: Turning Aggregated Data into a Formatted, Multi-Sheet Workbook
Learn how to turn raw transaction data into a professional, multi-sheet Excel workbook using pandas pivot_table and openpyxl. This lesson covers building multiple pivot summaries, applying header styles and number formats, adding a cover sheet, and structuring the whole pipeline as a reusable script.
19 min read
Power AppsFoundation
Configuring Model-Driven App Dashboards: Building Interactive Charts, Lists, and System Dashboards for Dataverse Data
Model-driven app dashboards give your users live, interactive summaries of Dataverse data without spreadsheets or manual reports. This lesson teaches you how to build charts, assemble system dashboards, and set them as the default app experience — step by step with a real scenario.
18 min read
Power AutomateFoundation
Automating Windows Service and Process Management in Power Automate Desktop: Starting, Stopping, and Monitoring Applications Before and After Desktop Flow Execution
Most RPA failures happen before the bot touches a single button — the environment simply was not ready. Learn how to check, start, stop, and monitor Windows services and processes in Power Automate Desktop so your flows manage their own runtime environment reliably, day or night.
18 min read
Microsoft FabricFoundation
Creating and Managing Fabric Lakehouses with Notebooks: Reading External Files from OneLake, Writing Delta Tables, and Browsing Results in the Lakehouse Explorer
Learn how to use Spark notebooks in Microsoft Fabric to read CSV and Parquet files from OneLake, write clean Delta tables to the lakehouse Tables zone, and validate your results in the Lakehouse Explorer — the complete data engineering loop from raw files to queryable data. This foundation-level lesson explains every step from first principles with realistic examples and working PySpark code.
17 min read
PythonExpert
Auditing and Reconciling Data Across Sources in pandas: Matching Totals, Flagging Discrepancies, and Building a Reconciliation Report
When your ERP, CRM, and finance spreadsheet all show different numbers, you need a systematic way to find out who's wrong and by how much. This expert-level lesson teaches you to build a complete data reconciliation pipeline in pandas — from normalizing heterogeneous sources, through row-level mismatch detection, to a formatted multi-sheet Excel report stakeholders can actually use.
26 min read
Microsoft FabricFoundation
Calling the Fabric Lakehouse SQL Analytics Endpoint from Power BI Desktop: Connecting, Writing Measures, and Publishing a Report Without Direct Lake
Learn how to connect Power BI Desktop to a Fabric lakehouse SQL Analytics Endpoint, build a star schema with DAX measures, and publish a production-ready report — no Direct Lake required. This lesson explains every step from finding the connection string to scheduling refreshes, with clear guidance on when to use this approach over Direct Lake mode.
21 min read
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