- 55103 Creating and Sharing Interactive Dashboards with PowerPivot, PowerView and SharePoint Server
Request a Class


COURSE COST: $995.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course


In this course students will learn how to create and share interactive dashboards using Excel PowerPivot, Power View and SharePoint. Students will walk through the development of a dashboard project with the steps, concepts, formulas, and functions that are used explained in detail.


This course is targeted at Business Intelligence developers and Power Users that are currently, or are in process of, developing Excel dashboards. Before attending this course, students must have:

Experience installing PC hardware and devices.
Basic understanding of TCP/IP and networking concepts.
Basic Windows and Active Directory knowledge.
The skills to map network file shares.
Experience working from a command prompt.
Basic knowledge of the fundamentals of applications. For example, how client computer applications communicate with the server.
Basic understanding of security concepts such as authentication and authorization.
An understanding of the fundamental principles of using printers.


*Course cost listed does not include the cost of courseware. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions. Course is subject to a minimum enrollment.

Course may run as a virtulal instructor led session if a minimum enrollment is not met.


At course completion
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.
Understand how to import data.
Understand how to relate data.
Understand how to enrich data.
Understand how to use time calculations.
Source data, Understand tabular, linked tables and visualdata.
Create a dashboard., Understand how to add drillthrough.
Understand visualizations in Power View.

Add interactivity.
Understand how to deploy to SharePoint.
Understand automatic data refresh.
Share using SharePoint Excel Services.

Module 1: Course Overview
Course Materials
What We'll Be Discussing

Module 2: Dashboard Principles
Develop Multiple Dashboards
Change Deployed Dashboards
Provide Interactive Help For Your Dashboards
Monitor Dashboard Utilization
Control Dashboard Updates

Module 3: Sourcing the Data
Importing Data
Relating Data
Enriching Data
Time Calculations
Lab : Sourcing the Data

Module 4: Creating the Excel Dashboard
Tabular Data
Visual Data
Linked Tables
Lab : Creating the Excel Dashboard

Module 5: Adding Interactivity
Adding Drillthrough
Visualizations with Power View
Lab : Adding Interactivity

Module 6: Sharing with SharePoint Excel Services
Deploy to SharePoint
Automatic Data Refresh
Lab : Sharing with SharePoint Excel Services