The Library · Insights
Deep dives across data, automation & AI
1262 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power BIPractitioner
DAX Event-in-Progress Pattern: Calculating Overlapping Intervals, Headcount Snapshots, and Concurrent Activity Metrics Across Date Ranges
Standard DAX aggregations fail when you need to answer "what was happening on this date?" across interval-based data. This lesson teaches the Event-in-Progress pattern — the definitive approach for headcount snapshots, concurrent activity metrics, and any scenario where your data has start dates and end dates instead of point-in-time events.
22 min read
Power BIPractitioner
Mastering Power BI Drillthrough Pages: Building Context-Aware Detail Views with Filters, Back Buttons, and Cross-Report Navigation
Drillthrough pages are one of the most powerful — and most misunderstood — features in Power BI. This lesson teaches you how to build production-ready detail views that pass the right filter context, navigate cleanly in both directions, and even bridge across separate report files with cross-report drillthrough.
26 min read
Power QueryPractitioner
Implementing Custom Window Functions and Running Calculations in Power Query M: Rolling Averages, Cumulative Totals, and Rank-Based Partitioning Without Native Window Support
Power Query M has no native window functions — no OVER, no PARTITION BY, no ROWS BETWEEN. This lesson teaches you to build rolling averages, cumulative totals, partitioned ranks, and lag/lead functions from scratch using M's list operations and grouping patterns, packaged into a reusable function library you can use across any project.
24 min read
Power QueryPractitioner
Implementing Column-Level Data Profiling and Statistical Summaries in Power Query: Distribution Analysis, Outlier Detection, and Quality Metrics for Practitioner Workflows
Learn how to build a reusable M code framework that automatically profiles every column in your Power Query pipeline — computing completeness rates, statistical distributions, IQR and Z-score outlier flags, and pass/fail quality gates on every refresh. Stop discovering data problems after the model is built.
24 min read
Microsoft ExcelPractitioner
Building a Custom Excel Task Pane with VBA and HTML: Design Interactive Side-Panel Interfaces for Professional Workbook Applications
Learn how to build a professional Excel task pane using VBA and embedded HTML, creating a persistent side-panel interface with two-way communication between JavaScript and VBA. Go from raw UserForm to a fully styled control panel with live KPIs, navigation, filters, and action buttons.
25 min read
Career DevelopmentFoundation
How to Write a Freelance Data Services Invoice: Payment Terms, Late Fee Clauses, and the Follow-Up Sequence That Gets You Paid on Time
Getting paid on time as a freelance data consultant isn't about luck — it's about how your invoice is constructed and what happens after you send it. This lesson walks you through every field of a professional invoice, how to write an enforceable late fee clause, and a five-touch follow-up sequence that recovers overdue payments without damaging client relationships.
20 min read
Career DevelopmentFoundation
How to Ask Smart Questions During a Data Interview That Signal Curiosity, Business Acumen, and Cultural Fit
Most candidates treat the "do you have any questions?" moment as a formality. This lesson teaches you how to turn it into one of your strongest competitive advantages — with specific, research-backed questions that make interviewers remember you.
18 min read
Data EngineeringFoundation
Understanding Data Freshness: How Ingestion, Transformation, and Scheduling Affect the Age of Your Data
Data freshness is one of the most quietly damaging problems in analytics — your pipeline looks fine, but your data is hours older than anyone realizes. This lesson teaches you exactly where freshness is lost across ingestion, transformation, and scheduling, and how to design pipelines that deliver data at the age your business actually needs.
17 min read
Data EngineeringFoundation
Data Type Coercion and Nullability Handling in Pipeline Transformations: Safely Casting, Defaulting, and Rejecting Malformed Fields
Real-world data is messy — strings where you expect numbers, nulls in three different formats, dates that aren't dates. This lesson teaches you to write pipeline transformation logic that handles malformed fields explicitly: safely casting, applying defaults, and quarantining records that can't be saved, without crashing or silently corrupting your output.
16 min read
AI & Machine LearningFoundation
Knowledge Graphs 101: Understanding Nodes, Edges, and Relationships as a Foundation for RAG and AI Agents
Most RAG systems treat knowledge as a bag of document chunks. Knowledge graphs let AI reason *across* facts — following chains of relationships the way a human expert does. This lesson teaches you the fundamentals from scratch, with working Python code and clear connections to modern RAG and agent architectures.
16 min read
AI & Machine LearningFoundation
Vector Databases Explained: Choosing, Configuring, and Querying Pinecone, Weaviate, and pgvector for LLM Applications
Most LLM applications need to search by meaning, not keywords — and that requires a vector database. This hands-on lesson walks you through Pinecone, Weaviate, and pgvector with real Python code, so you can choose the right tool and start shipping.
17 min read
AI & Machine LearningFoundation
What Is a Token and Why Does It Matter? A Beginner's Guide to How AI Reads and Processes Text
Every AI interaction you've ever had has been secretly running on tokens — chunks of text that are neither words nor characters. Understanding what tokens are changes how you write prompts, design workflows, and control AI costs.
17 min read