trainocate-microsoft-training-b
Home > Vendors > Microsoft > 55103A

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

Overview

Duration: 2 days

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.

Objectives

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.

Content

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

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

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

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

After completing this module, students will be able to:

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

Audience

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

Prerequisites

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

Certification

This is course is not associated with any Certification.

Schedule

Show Schedule for: