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 AutomateFoundation
Getting Started with the Power Automate Interface: Navigating the Designer, Understanding Flow Structure, and Running Your First Test
Power Automate can feel overwhelming before you know where everything lives. This hands-on lesson walks you through the designer, explains how triggers and actions work together, and gets you building and testing a real flow from scratch — no prior experience required.
16 min read
Power AppsFoundation
Power Apps Data Sources Explained: Tables, Records, and Collections for Absolute Beginners
Confused about where data lives in Power Apps and how to work with it? This lesson builds your understanding from first principles — covering tables, records, fields, external data sources, and collections — so you can confidently connect data to any app you build.
15 min read
Power BIFoundation
Implementing Power BI Apps to Package and Distribute Enterprise Reports to Large Audiences at Scale
Stop sharing workspaces and start delivering polished, governed report experiences with Power BI Apps. This hands-on lesson walks you through building, configuring, and publishing an enterprise app — including audience groups, navigation design, and seamless update workflows.
17 min read
Power BIFoundation
DAX Variables in Practice: Using VAR and RETURN to Simplify Complex Measures
Complex DAX measures don't have to be unreadable nightmares. Learn how to use VAR and RETURN to break calculations into clear, named steps — and discover the one surprising behavior about variables that every DAX developer needs to understand.
14 min read
Power BIFoundation
Choosing the Right Visualization in Power BI: Bar Charts, Line Charts, Tables, and Cards Explained
Most Power BI beginners pick charts by instinct — and end up with dashboards that confuse instead of communicate. This lesson teaches you the one question you need to ask before choosing any visualization, then walks you through the four chart types that cover 90% of real business reporting needs.
16 min read
Power QueryFoundation
Navigating the M Standard Library: A Practical Reference to Built-In Functions, Namespaces, and When to Use Each
The M standard library has over 700 built-in functions — and most Power Query users never get a proper map of the territory. This lesson teaches you how the library is organized by namespace, what each major namespace covers, and how to confidently look up and use any function you encounter.
16 min read
Power QueryFoundation
Connecting to Excel Workbooks and Named Ranges in Power Query: A Practical Foundation Guide
Learn how to build reusable, refreshable data connections in Power Query — including how to connect to external Excel workbooks, named tables, and named ranges. This foundation lesson turns a two-hour monthly chore into a one-click refresh.
16 min read
Microsoft ExcelFoundation
Mastering Excel's Name Manager: Define, Organize, and Use Named Ranges for Cleaner Formulas and VBA
Hard-coded cell references make Excel formulas cryptic and VBA macros fragile. This hands-on lesson teaches you to use Excel's Name Manager to create, organize, and apply named ranges — transforming complex formulas into readable logic and making your macros resilient to structural changes.
17 min read
Career DevelopmentExpert
Productizing Your Data Expertise: How to Build a Paid Online Course or Workshop That Sells While You Sleep
You've delivered the same knowledge to a dozen clients. A course would deliver it to hundreds — automatically. This complete playbook covers everything from knowledge extraction and curriculum architecture to evergreen funnels and pricing strategy for freelance data consultants ready to build a scalable second income stream.
31 min read
Career DevelopmentExpert
How to Ask for an Informational Interview with a Data Professional: Scripts, Timing, and What to Do With the Conversation
Most job seekers treat informational interviews as networking theater — awkward, aimless, and forgotten within a week. This lesson teaches you the complete system: how to write outreach that gets responses, run conversations that actually teach you something, and turn a 30-minute call into a real professional relationship.
32 min read
Data EngineeringExpert
Deploying a Self-Serve Analytics Platform with dbt Exposures, a Semantic Layer, and Governed Tableau or Looker Access
Most self-serve analytics platforms either lock users out entirely or let them connect to anything and break everything. This lesson shows you the architecture that does neither — using dbt Exposures as governance contracts, a MetricFlow or Cube.dev semantic layer for consistent metric definitions, and properly governed Tableau and Looker access with row-level security baked in.
27 min read
Data EngineeringExpert
Graceful Pipeline Deprecation and Migration: Safely Retiring Legacy Workflows Without Data Loss or Downstream Disruption
Migrating a live data pipeline while downstream teams depend on it is one of the highest-stakes problems in data engineering. This lesson gives you a complete, battle-tested framework — from dependency auditing and parallel runs to automated reconciliation, controlled cutover patterns, and organizational change management.
26 min read