When you want to transport a project lock, stock and barrel to a different machine/location, consolidate.
When you're tired of having footage scattered hither & yon, or worried that files could go away, consolidate.
When you need just a portion of a project file, eliminating unnecessary comps & such, reduce the project.
Sometimes you do both. When you do both, the order in which you do them makes a big difference.