Analytic query plugin

When to use analytic query plugin?

Analytic Query step is used to execute analytic queries over a sorted data set. This step allows you to peek forward and backwards across rows (e.g. LEAD, LAG, FIRST, LAST).