The Library · Insights
Deep dives across data, automation & AI
982 in-depth articles — from Excel foundations to production machine learning. Filter by topic or difficulty to find exactly what you need.
Power BIPractitioner
Building Statistical Measures in DAX: Percentiles, Standard Deviation, and Outlier Detection for Analytical Reporting
Move beyond basic aggregations and build a complete statistical toolkit in DAX. This hands-on lesson walks you through percentile calculations, standard deviation, Z-scores, and IQR-based outlier detection—with production-ready formulas and real-world business scenarios.
18 min read
Power BIPractitioner
Mastering Time Intelligence in Power BI: Building YTD, MTD, and Period-over-Period DAX Measures
Time intelligence is what transforms a static Power BI report into a living analysis — but most practitioners get it subtly wrong. This lesson walks you through building a complete, production-ready suite of YTD, MTD, and period-over-period measures from scratch, including fiscal calendar support and partial period handling.
19 min read
Power QueryPractitioner
Streaming and Pagination Patterns in M: Handling Large APIs and Multi-Page Data Sources with Custom Iterators
Most Power Query tutorials stop at fetching one page of API data. This lesson goes all the way — teaching you how to build robust, production-ready pagination handlers in M that work across offset-based, cursor-based, and link-header APIs using List.Generate and custom iterators. You'll leave with reusable code and a mental model that makes any paginated API manageable.
21 min read
Power QueryPractitioner
Unpacking Nested JSON and XML Structures in Power Query: Expanding Lists, Records, and Tables
Most real-world APIs and data files are nested — JSON objects inside arrays inside objects, XML elements three levels deep. This lesson teaches you how to systematically expand Lists, Records, and Tables in Power Query, handle multi-level nesting, and write M code that doesn't break when the source schema changes.
22 min read
Career DevelopmentFoundation
Qualifying Freelance Data Clients Before You Pitch: Red Flags, Budget Signals, and the Discovery Call Framework
Most freelancers lose hours pitching to clients who were never going to hire them. This lesson teaches you how to read early signals, run a structured discovery call, and spot the red flags that predict painful engagements — before you write a single proposal.
16 min read
Data EngineeringFoundation
Setting Up Your First Cloud Data Warehouse: A Hands-On Guide to Snowflake or BigQuery Free Tier
Stop manually stitching together CSVs and spreadsheets. This hands-on lesson walks you through setting up a real cloud data warehouse in Snowflake or BigQuery — for free — loading actual e-commerce data, and writing your first analytical SQL queries from scratch.
16 min read
Data EngineeringFoundation
Data Pipeline Design Patterns: Fan-Out, Fan-In, and Branching Workflows Explained
Real data pipelines rarely move in straight lines. Learn the three foundational patterns — fan-out, fan-in, and branching — that govern how data flows through production pipelines, with hands-on Python examples and realistic scenarios.
16 min read
AI & Machine LearningFoundation
Query Routing in RAG: How to Direct Questions to the Right Data Source or Retrieval Strategy
Most RAG systems have more than one data source — and blindly searching all of them for every question is a recipe for slow, noisy, expensive answers. Learn how to build an intelligent query router that sends each question exactly where it needs to go.
17 min read
AI & Machine LearningFoundation
Handling LLM Errors, Timeouts, and Rate Limits in Python Applications
LLM APIs fail in predictable ways — but only if you know what to look for. This lesson teaches you how to build Python applications that handle rate limits, timeouts, and transient errors gracefully, with retry logic, proactive throttling, and real fallback strategies.
16 min read
AI & Machine LearningFoundation
Writing Clear AI Instructions: How to Communicate Your Intent So AI Tools Deliver Useful Results
Most AI tools aren't failing you — your instructions are failing them. Learn the four-component framework for writing prompts that consistently get you useful, accurate, and properly formatted results from any AI tool.
15 min read
SQLFoundation
Writing Efficient SQL Aggregations: GROUP BY, HAVING, and Grouping Sets Explained
Aggregation is how you turn millions of raw rows into the summaries that actually drive decisions. This lesson teaches you how GROUP BY, HAVING, ROLLUP, and CUBE work from first principles — so you can write correct, efficient aggregation queries on any database.
16 min read
Power AutomateFoundation
Understanding Power Automate Connectors: How to Browse, Connect, and Authenticate with Microsoft and Third-Party Services
Connectors are the bridge between Power Automate and every service it can talk to — but most beginners skip past them without really understanding how they work. This lesson teaches you what connectors are, how to find the right one, and how to authenticate properly so your flows actually run.
19 min read