Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server

Develop Multiple Dashboards

Change Deployed Dashboards

Provide Interactive Help For Your Dashboards

Monitor Dashboard Utilization

Control Dashboard Updates

After completing this module, students will be able to:

Understand how to develop multiple dashboards.

Understand how to change deployed dashboards.

Understand how to provide interactive help for dashboards.

Understand how to monitor dashboard utilization.

Understand how to control dashboard updates.

Importing Data

Relating Data

Enriching Data

Time Calculations

Sourcing the Data

After completing this module, students will be able to:

Understand how to import data.

Understand how to relate data.

Understand how to enrich data.

Understand how to use time calculations.

Source data.

Tabular Data

Visual Data

Linked Tables

Create the Dashboard

After completing this module, students will be able to:

Understand tabular data.

Understand visual data.

Understand linked tables.

Create a dashboard.

Adding Drillthrough

Visualizations with Power View

Adding Interactivity

After completing this module, students will be able to:

Understand how to add drillthrough.

Understand visualizations in Power View.

Add interactivity.

Deploy to SharePoint

Automatic Data Refresh

Sharing with SharePoint Excel Services

After completing this module, students will be able to:

Understand how to deploy to SharePoint.

Understand automatic data refresh.

Share using SharePoint Excel Services.