Slice and dice

One key staple of a dashboard is the ability to drill into and filter data. Slicers are interactive visual filters that allow users to easily refine and navigate through data in PivotTables, PivotCharts, and regular data tables. They provide a user-friendly interface for slicing and dicing data by selecting specific criteria, enhancing data exploration and analysis.

In our final step before presenting our dashboard to Tadeas Benne, the Chief Revenue Officer, we should add some slicers so he can easily dig through the data and perhaps answer some of his own questions through data exploration.

Continue working in your current workbook. If you've lost process, open 4_3_pivot_charts.xlsx from the Workbooks folder in the course materials.