Chapter 3: Intermediate Operations

Chapter 3: Intermediate Operations

Overview

In Chapter 3, we will cover intermediate operations like aggregates, unions, joins, pivots, unpivots, and valuestocols.

Lessons:


Lesson A: Aggregate

In this lesson, you will:

  • Use the Aggregate Transform to create data summarization
  • Create a Flat Aggregate


Lesson B: Union

In this lesson, you will:

  • Append two datasets together using the Union Transform


Lesson C: Join

In this lesson, we will:

  • Enrich a dataset using the Join function


Lesson D: Pivot, Unpivot, and Valuestocols

In this lesson, we will:

  • Learn the Pivot transform to transpose rows to columns
  • Learn the Unpivot transform to transpose columns to rows
  • Learn the Valuestocols transform to create binary indicator columns of values in a column