55103: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server Training in Mount Vernon

Enroll in or hire us to teach our 55103: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server class in Mount Vernon, New York by calling us @303.377.6176. Like all HSG classes, 55103: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, 55103: Creating and Sharing Interactive Dashboards with PowerPivot, Power View and SharePoint Server may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
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.
Course Length: 2 Days
Course Tuition: $890 (US)

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.

Course Outline

 

Module 1: Course Overview

 Lessons

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

Lessons

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

Lessons

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

Lessons

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

Lessons

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

Lessons

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

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.