Deep dives across data, automation & AI

DAX for Many-to-Many Relationships and Complex Data Models

Master advanced DAX patterns for handling many-to-many relationships in Power BI. Learn bridge tables, filter direction, and performance optimization for complex business scenarios.

Working with JSON and XML Data Sources in M: Complete Foundation Guide

Master Power Query's M language functions for parsing and transforming JSON and XML data into analysis-ready tables. Learn practical techniques for handling nested structures, missing fields, and common data quality issues.

Building Productized Services with Power BI and Excel: From Custom Consultant to Product Owner

Transform your consulting expertise into scalable, high-margin productized services. Learn advanced Power BI templating, Excel configuration systems, and delivery frameworks that let you scale beyond personal capacity.

Cost Management in Cloud Data Platforms

Building a Document Q&A System with Embeddings: A Complete Beginner's Guide

Learn to build an AI-powered document Q&A system from scratch using embeddings and language models. No prior AI experience required—just practical Python skills and clear explanations.

Row Context vs Filter Context: The Mental Model Every DAX User Needs

Master the fundamental difference between row context and filter context in DAX. Learn why the same formula can produce completely different results and how to control context for predictable calculations.

Advanced JSON and XML Processing in Power Query M Language

Master sophisticated techniques for processing semi-structured data in M, including recursive navigation, namespace handling, performance optimization, and building resilient transformation pipelines for production systems.

Starting a Data Freelancing Business: Essential Tools, Pricing Strategies, and Landing Your First Clients

Learn to transition from data professional to successful freelancer with practical guidance on business tools, pricing strategies, and proven methods for finding clients who value your expertise.

Real-Time Data: When to Use Streaming vs Batch Processing

Master the fundamental choice between streaming and batch processing. Learn when each approach works best and how to build hybrid systems that combine both for optimal results.

Building a Production Document Q&A System with Vector Embeddings

Learn to build a scalable document Q&A system using embeddings and RAG. Covers advanced chunking, vector search optimization, prompt engineering, and production deployment with real-world regulatory compliance examples.

Advanced DAX Patterns: Variables, SWITCH, and Iterator Functions

Master the three pillars of expert DAX development: variables for performance optimization, SWITCH for elegant conditional logic, and iterators for precise data control. Transform complex business requirements into maintainable, efficient Power BI measures.

Transitioning to Data from Another Career: A Complete Roadmap

Learn how to leverage your existing career experience while building technical data skills. This comprehensive guide covers skill assessment, learning strategies, and job search tactics specifically for career changers entering the data field.