Describe how PowerPivot can be used to create a simple dashboard and discuss a few simple ways to enhance the value of a dashboard

What will be an ideal response?

PowerPivot includes an option to generate up to four PivotCharts on a worksheet based on data from the data model that can form the foundation for a simple dashboard. The dashboard can be enhanced through simple formatting of the charts and the addition of slicers for easy filtering. Additionally, KPIs can be incorporated into PivotTables or charts and sparklines can be added to add a visual element to a PivotTable.