Getting Started with Power Query: Clean and Shape Data in Power BI
Power Query is the ETL engine behind Power BI. Learn to connect, transform, and shape data with a no-code interface plus a peek at the M language underneath.
Power BI · DAX · Power Query
Master Power BI, one
Master Power BI, one
practical tutorial at a time.
21+ hands-on tutorials for data analysts. From your first DAX measure to advanced time intelligence patterns — clear explanations, real datasets, copy-paste code.
Featured Tutorials
Hand-picked guides every analyst should read first.
CALCULATE: The Most Important DAX Function Explained
CALCULATE is the only function that can modify filter context. Master its syntax, evaluation order, and three real-world patterns that unlock every advanced DAX formula.
DAX Basics: The Beginner's Guide to Data Analysis Expressions
Learn what DAX is, how measures differ from calculated columns, and write your first five formulas with confidence. A practical starting point for every Power BI analyst.
Browse by Category
Jump straight to the topic you need.
DAX Formulas
Master the Data Analysis Expressions language.
Explore →Power Query
ETL and data preparation in Power BI.
Explore →Data Modeling
Star schema, relationships, and model design.
Explore →Visualization
Build interactive reports and dashboards.
Explore →Time Intelligence
Date-based calculations and YTD/MTD patterns.
Explore →Latest Tutorials
Fresh from the editor — published weekly.
Conditional Formatting in Power BI: Make Patterns Pop Without Clutter
Conditional formatting applies color rules to cells based on their values — background gradients, font colors, data bars, and icons. It turns a wall of numbers into an immediately readable visual. This guide covers the four formatting types, the rules for each, and the design principles that keep formatting helpful instead of overwhelming.
Power BI Tooltips: From Basic Hover to Full Page Reports
Tooltips are the most underrated interaction in Power BI. A default tooltip shows the data point's values — useful but limited. Custom tooltip pages turn a hover into a mini-report: related metrics, trends, and context. This guide covers building both and the three patterns where tooltips shine.
SAMEPERIODLASTYEAR and Date Comparison Patterns in DAX
Year-over-year comparison is the most common business question in reporting. SAMEPERIODLASTYEAR is the simplest function for it, but it's just the start. This guide covers YoY, MoM, QoQ, and the custom comparison patterns for fiscal calendars and non-standard periods.
Bookmarks and Navigation in Power BI: Build Interactive Report Tours
Bookmarks capture the state of a report page — filters, selections, visibility, and sort order. Combined with buttons, they turn a static page into an interactive experience: tabbed navigation, drill-through stories, and self-guided report tours. This guide covers the mechanics and four patterns that work.
10 Common Power Query Transformations Every Analyst Should Know
Power Query has hundreds of functions, but a small set covers the vast majority of real-world cleanup tasks. This guide walks through ten transformations that handle messy exports, inconsistent naming, and malformed data — the daily reality of every data analyst.
Rolling Averages and Moving Sums in DAX: Smooth Out the Noise
Daily data is noisy — a slow Tuesday followed by a spike Wednesday. Rolling averages and moving sums reveal the trend underneath. This guide covers the 7-day rolling average, the 30-day moving sum, and the pattern for any custom rolling window using DAX window functions.
One DAX pattern. Every week. Free.
Join 2,000+ analysts getting one practical, copy-paste DAX pattern in their inbox every Tuesday. No spam, unsubscribe anytime.