What is a modern data stack?

A practical definition of the modern data stack (warehouse, ELT, transform, BI) and when consolidating tools makes sense.