Quick Commerce Analytics Path · Mission 24 of 25Master

Multi-sided P&L capstone

Assemble the full P&L by merchant category, layering the substitution-leakage adjustment onto the three-party split. A multi-CTE pipeline that joins orders, the merchant dim, and a per-order leakage roll-up.

The Brief

You'll practice

Multi-CTE pipelineThree-partyCapstone