The Library · Insights
Deep dives across data, automation & AI
1253 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power BIFoundation
Adding a Date Table to Your Power BI Model: Why You Need One and How to Build It with Power Query
Time intelligence features in Power BI only work reliably when your model includes a proper date table. This lesson explains exactly why that's true, and walks you through building a complete, reusable date table from scratch in Power Query — no DAX required.
18 min read
Power QueryFoundation
Scoping Variables and Let Expressions in M: Understanding Binding, Shadowing, and Expression Isolation in Power Query
Most Power Query users treat the let block as a list of sequential steps — but it's actually a scoping mechanism with rules about name binding, visibility, and resolution that determine how your query evaluates. Learn how to use nested let expressions, avoid shadowing bugs, and write queries that are easier to build and debug.
17 min read
Power QueryFoundation
Changing Data Types in Power Query: When, Why, and How to Set Column Types Correctly
Wrong data types cause silent failures throughout your Power Query pipelines — broken merges, failed calculations, and missing date filters. Learn exactly how to detect type problems, fix them the right way, and place your type conversions in the right sequence so your data is always trustworthy.
19 min read
Microsoft ExcelFoundation
VBA RecordSet Fundamentals: Query, Loop, and Write Data Using ADO Without SQL Server Dependencies
Learn how to use ADO Recordsets in Excel VBA to query, filter, and write data without any SQL Server or external database dependency. This hands-on lesson covers connection strings, SQL queries against Excel ranges, Recordset looping, and efficient output using CopyFromRecordset.
16 min read
Microsoft ExcelFoundation
Workbook and Worksheet Basics: Creating, Saving, and Organizing Excel Files for Data Professionals
Learn how to create, save, and organize Excel workbooks and worksheets like a data professional. This lesson covers file formats, naming conventions, tab color-coding, and a proven multi-sheet structure you can use on every project.
16 min read
Power AutomateExpert
Automating Multi-Step Data Collection with Microsoft Forms, SharePoint, and Outlook in Power Automate: Building a Complete Request Intake, Storage, and Confirmation Flow
Learn how to build a production-ready request intake pipeline that automatically captures Microsoft Forms submissions, stores them in SharePoint with unique reference IDs and SLA deadlines, and sends formatted confirmation emails via Outlook — all without manual intervention. This expert-level lesson covers architecture decisions, data type gotchas, idempotency protection, and conditional email content based on form input.
29 min read
Power AutomatePractitioner
Implementing Power Automate Suspension and Drain Strategies for Zero-Downtime Solution Upgrades
Deploying a new solution version shouldn't mean breaking in-flight orders, orphaned approvals, or frantic rollbacks. This lesson gives you a complete, automation-ready playbook for quiescing triggers, draining active runs, and resuming traffic safely across environments — with no manual heroics required.
21 min read
Microsoft FabricPractitioner
Streaming Data into a Fabric Eventhouse with Eventstreams: Configuring Sources, Defining KQL Tables, and Querying Live Telemetry Data
Learn how to build a complete real-time telemetry pipeline in Microsoft Fabric — from configuring an Eventstream source to defining KQL tables with update policies and materialized views, to writing operational queries against live streaming data. Uses a realistic IoT fleet monitoring scenario throughout.
22 min read
PythonPractitioner
Parsing and Normalizing Inconsistent Date Formats in pandas: Handling Mixed Formats, Timezones, and Locale Variations in Real-World Data
Real-world date columns are a mess of competing formats, missing timezones, and locale-specific month names. This lesson builds a complete, production-ready date normalization pipeline in pandas that handles all of it — without silent data corruption.
21 min read
Power AppsPractitioner
Configuring Dataverse Table-Scoped Business Process Flow Stages with Branch Conditions: Modeling Multi-Path Workflows, Stage Gating, and Completion Enforcement in Model-Driven Apps
Most Business Process Flow implementations barely scratch the surface of what's possible. Learn how to build branching multi-path BPFs, enforce true stage gates at the data layer, scope stages to related Dataverse tables, and lock records when they reach completion — all in a realistic contract qualification scenario.
24 min read
Power AutomatePractitioner
Automating Structured Data Extraction from Web Tables and Dynamic Grids in Power Automate Desktop: Scraping, Paginating, and Writing Results to Excel Without Manual Copying
Learn how to build a production-ready desktop flow that extracts multi-page web table data — including JavaScript-rendered div grids — and writes all results to Excel automatically. Covers wait strategies, pagination loop patterns, custom JavaScript extraction, and error handling for real enterprise portals.
24 min read
Career DevelopmentPractitioner
How to Build a Vertical-Specific SQL and Excel Service Offering: Command Higher Rates by Specializing in One Industry
Most data freelancers stay generalist and compete on price. This lesson shows you how to pick a target industry, build reusable SQL and Excel assets for it, and position yourself as the go-to specialist — so clients come looking for you and pay premium rates to find you.
24 min read