Excel Power View Tutorial

Excel Power View Tutorial

Power View enables interactive data exploration, visualization, and presentation that encourages intuitive ad-hoc reporting. Large data sets can be analyzed on the fly using versatile visualizations in Power View. The data visualizations are dynamic, thus facilitating ease of presentation of the data with a single Power View report.

This guide targets professionals with hands-on experience in Excel, to perform the highend data analysis and decision making in a matter of few minutes.

Power View is based on the Data Model in your workbook. Either you can start with a Data Model that is already available in Power Pivot or you can create a Data Model from Power View itself. In this tutorial, we assume that you are aware of the Data Model concepts in Power Pivot. Otherwise, we suggest you to go through our Excel Power Pivot tutorial first.

Table of Contents

Excel Power View - Overview
Excel Power View - Creation
Excel Power View - Sheet
Excel Power View - Visualizations
Excel Power View - Table Visualization
Excel Power View - Matrix Visualization
Excel Power View - Card Visualization
Excel Power View - Chart Visualizations
Excel Power View - Line Chart Visualization
Excel Power View - Bar Chart Visualization
Column Chart Visualization
Scatter and Bubble Chart Visualization
Excel Power View - Pie Chart Visualization
Excel Power View - Map Visualization
Excel Power View - Multiple Visualizations
Excel Power View - Tiles Visualization
Excel Power View - Advanced Features
Excel Power View and Data Model
Excel Power View - Hierarchies
Key Performance Indicators
Excel Power View - Formatting a Report
Excel Power View - Sharing