Consolidations in MicroStrategy are custom groupings created by combining specific attribute elements into logical sets. For example, you can create a consolidation called 'West Coast' by grouping specific state attribute elements like 'CA', 'OR', 'WA'. They are not created from filters, which are conditions rather than element groupings.