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

Code: 55103
Course duration: 2 days
Location Period
Mid-Town New York City (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Attend Online
10-19 09:00AM to 10-20 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
10-19 09:00AM to 10-20 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Attend Online
12-19 09:00AM to 12-22 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Greenwich, Connecticut (Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
12-19 09:00AM to 12-22 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Attend Online
01-16 09:00AM to 01-19 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Fort Lauderdale, Florida (Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
01-16 09:00AM to 01-19 05:00PM
enroll
Attend Online
02-20 09:00AM to 02-23 05:00PM
enroll
NYC-23rd Street (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Mid-Town New York City (Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
02-20 09:00AM to 02-23 05:00PM
enroll
Fort Lauderdale, Florida (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Mid-Town New York City (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Newark, New Jersey (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Attend Online
03-20 09:00AM to 03-23 05:00PM
enroll
NYC-23rd Street (Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Northern New Jersey (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Wilkes-Barre, Pennslyvania (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Secaucus, New Jersey (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Palm Beach County Florida (Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll
Greenwich, Connecticut (Virtual Instructor-Led)
03-20 09:00AM to 03-23 05:00PM
enroll

55103 -Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server (2 Days)

About 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.

Audience Profile

This course is targeted at Business Intelligence developers and Power Users that are currently, or are in process of, developing Excel dashboards.

At Course Completion

After completing this course, 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.
  • 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 data.
  • Understand visual data.
  • Understand linked tables.
  • 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.

Course Outline

Module 1: Course OverviewLessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

Module 2: Dashboard PrinciplesLessons

  • 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.

Module 3: Sourcing the DataLessons

  • Importing Data
  • Relating Data
  • Enriching Data
  • Time Calculations

Lab : Sourcing the Data

  • 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.

Module 4: Creating the Excel DashboardLessons

  • Tabular Data
  • Visual Data
  • Linked Tables

Lab : Creating the Excel Dashboard

  • Create the Dashboard

After completing this module, students will be able to:

  • Understand tabular data.
  • Understand visual data.
  • Understand linked tables.
  • Create a dashboard.

Module 5: Adding InteractivityLessons

  • Adding Drillthrough
  • Visualizations with Power View

Lab : Adding Interactivity

  • Adding Interactivity

After completing this module, students will be able to:

  • Understand how to add drillthrough.
  • Understand visualizations in Power View.
  • Add interactivity.

Module 6: Sharing with SharePoint Excel ServicesLessons

  • Deploy to SharePoint
  • Automatic Data Refresh

Lab : Sharing with SharePoint Excel Services

  • 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.

Prerequisites:

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.

Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review