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.
Microsoft FabricPractitioner
Direct Lake Mode in Power BI: How It Works and When to Use It over Import and DirectQuery
Direct Lake mode reads Delta Parquet files directly from OneLake into Power BI's in-memory engine — delivering Import-speed performance without scheduled refreshes. Learn how framing, transcoding, and fallback work, and build a production-ready Direct Lake semantic model from a Fabric lakehouse.
24 min read
PythonPractitioner
Text Cleanup at Scale with pandas String Methods and Regular Expressions
Dirty text data is one of the most common blockers in real analysis work. This lesson teaches you how to use pandas `.str` methods and regular expressions to normalize, extract, and validate text at scale — turning chaotic string columns into clean, queryable data with reusable pipeline functions.
22 min read
Power AppsPractitioner
Column-Level Security and Record Sharing in Dataverse
Table-level security controls who can access records, but real production environments often need finer control — down to individual columns and specific records. This lesson teaches you how to implement Field Security Profiles, configure column-level access, and use record sharing to grant targeted exceptions without restructuring your entire security model.
25 min read
Power AutomatePractitioner
Extracting Text from PDFs, Images, and Scanned Documents with OCR in Power Automate Desktop
Learn how to build production-ready OCR automation in Power Automate Desktop that extracts structured data from scanned PDFs, images, and live screen regions. Covers text parsing, regex patterns, error handling, and full folder processing pipelines for real-world document workflows.
24 min read
Microsoft FabricPractitioner
Implementing the Medallion Architecture in Microsoft Fabric: Bronze, Silver, and Gold Layers
Learn how to design and build a production-ready medallion architecture in Microsoft Fabric using three separate lakehouses for Bronze, Silver, and Gold layers. This lesson goes beyond theory — you'll write real PySpark notebooks with MERGE patterns, quarantine logic, and Delta optimization for Power BI Direct Lake reporting.
19 min read
PythonPractitioner
Working with Dates and Time Series in pandas: Parsing, Resampling, and Rolling Windows
Dates are where real-world data gets messy and where pandas gets powerful. Learn how to parse tricky date formats, resample transactions to any frequency, and compute rolling averages and anomaly-detection bands — with production-ready patterns throughout.
21 min read
Power AppsPractitioner
Dataverse Security: Business Units, Security Roles, and Teams
Learn how to architect a production-grade Dataverse security model using business units, custom security roles, owner teams, access teams, and AAD-linked teams. This complete lesson covers real-world design patterns, privilege configuration, and troubleshooting for multi-team organizations.
24 min read
Power AutomatePractitioner
Subflows and Reusable Logic in Power Automate Desktop
Learn how to architect Power Automate Desktop flows using subflows — named, callable units of logic with formal input and output parameters. Stop copy-pasting actions and start building automations you can actually maintain.
23 min read
Microsoft FabricPractitioner
Transforming Data with Spark Notebooks in Microsoft Fabric: PySpark for Lakehouse Tables
Learn how to use PySpark in Fabric Spark notebooks to clean, enrich, and write production-quality Delta tables to your lakehouse. Covers deduplication, Delta merge, partitioning, and parameterized notebooks that plug into Data Pipelines.
20 min read
PythonPractitioner
Reshaping Data with pivot_table, melt, and stack in pandas
Learn how to transform data between wide and long formats using pandas' pivot_table, melt, and stack functions. This hands-on lesson builds real analyst fluency — with realistic datasets, composable workflows, and production-ready techniques.
19 min read
Power AppsPractitioner
Business Process Flows: Guiding Users Through Multi-Stage Processes in Power Apps
Business Process Flows (BPFs) transform inconsistent, documentation-dependent workflows into structured, in-form guidance that enforces data quality at every stage. Learn how to design, build, and deploy BPFs that actually guide users — including branching logic, stage-gating, and security configuration.
20 min read
Power AutomatePractitioner
Error Handling in Desktop Flows: On Block Error, Retry Policies, and Recovery Screenshots
Learn how to build desktop flows that handle failures gracefully using On Block Error handlers, retry policies, and automatic recovery screenshots. This lesson takes you from brittle proof-of-concept to production-ready RPA with practical, hands-on techniques.
21 min read