Summary  
This chapter covers how to reshape tabular data by using pivot operations to aggregate rows into columns and unpivot operations to flatten columns into rows. It also explains when to apply each operation.

General domain of usage  
Data transformation for analytics

Real-world data often arrives in formats that Power BI can't use directly. A common example is spreadsheets with months spread across columns instead of listed down rows. In this chapter, you'll learn how to reshape data using Power Query's pivot and unpivot features.

You'll transform the Summit Gear monthly targets file from a wide format (one column per month) into a tall format (one row per region, per year, per month) that Power BI can work with. You'll learn the difference between pivoting and unpivoting, as well as when to use each.

You receive a spreadsheet with columns for "Q1 Sales," "Q2 Sales," "Q3 Sales," and "Q4 Sales." You need each quarter's value in its own row. Which Power Query operation should you use?

Master the skills needed to turn raw data into professional, interactive reports using Power BI. You'll connect to data sources, clean and transform data with Power Query, build data models, write DAX measures, and publish polished dashboards to Power BI Service. No prior experience required.

Get hands-on experience with Power BI Desktop: understand where it fits in the modern data stack, install it, explore the interface, connect to your first dataset, and build your first bar chart.

Master the skills needed to clean, transform, and combine data using Power Query – from filtering rows and adding columns to merging tables and reshaping data with pivot operations.

Explore the essentials of relational data modeling and DAX – build star schemas, define relationships, write measures, and use time intelligence functions to answer real business questions.

Dive into the fundamentals of Power BI visuals – choose the right chart type, configure slicers and filters, add drillthrough navigation, and create bookmark-driven interactive experiences.

Transform the way you present data by applying layout and design principles, building multi-page reports, setting up row-level security, and publishing to Power BI Service with scheduled refresh.

Gain a solid understanding of the end-to-end Power BI workflow by completing a guided project – from data preparation and modeling to building a multi-page dashboard and publishing it to the Service.

Pivoting and Unpivoting