Multi-stages Aggregation in Action

What is a multi-stage pipeline?

A multi-stage pipeline is a sequence of aggregation stages, each transforming the data and passing it to the next stage. These stages are executed in order, and the output of one stage becomes the input for the next, allowing us to build complex data transformations step by step, much like an assembly line. 

Let's begin creating multi-stage pipelines for the real-world examples we covered earlier.

Examples

For instance, if we need to calculate the number of orders that got cancelled and shipped, we can use the aggregation pipeline. Take a look at the query below.