Power BI data transformation, shaping, and modeling documentation

Learn how to transform, shape, and model data in Power BI with conceptual, tutorial, and how-to guides.

Transform and shape data

Overview

• Query editor overview

Tutorial

• Shape and combine data

Concept

• Common query tasks

How-To Guide

• Combine files (binaries)

Model data

Concept

• Modeling view
• Many-to-many relationships
• Implement time-based calculations

How-To Guide

• Create and manage relationships
• Apply data categorization

Calculations

Tutorial

• Learn DAX basics
• Create calculated columns

Concept

• Visual calculations
• Calculated tables

How-To Guide

• Calculations options
• Use quick measures

Self-service data prep

Overview

• Self-service data prep in Power BI

Concept

• Dataflows: Self-service data prep
• Create and use dataflows
• Streaming dataflows (preview)

Datamarts (preview)

Overview

• Introduction to datamarts (preview)

How-To Guide

• Get started with datamarts (preview)

Concept

• Understand datamarts (preview)
• Create reports with datamarts (preview)
• Datamart administration (preview)