A dashboard based on PivotTables brings together on one sheet several PivotTables, PivotCharts and slicers that share the same source. It answers specific questions with a few clear indicators and shared filters. It stays up to date by refreshing the source.
Example
A sheet with sales by region, monthly trend, best products and a shared Année slicer.