Power View in Excel
Power View is an interactive data visualization, and presentation experience that encourages intuitive ad-hoc reporting. Power View is a feature of Microsoft Excel 2013 and of Microsoft SharePoint Server 2010 and 2013. You can enable Power View and use Power View in Excel.
Let’s discuss Table visualization.
Table Visualization in Excel Power View
For whatever visualization we decide to make with Power View, we start by generating a Table, which is the default, and then quickly convert the Table to other visualizations.
The Table is formatted similarly to any other data table, with columns representing fields and rows representing data values. To pick which fields to display in the Table, use the Power View Fields list to select and deselect fields. Fields from the same data table or multiple related data tables might be used.