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

Session Detail:    Classroom 2 Day

The short description is: In this course students will learn how to create and share interactive dashboards using Excel PowerPivot, PowerView and SharePoint. Students will walk through the development of a dashboard project with the steps, concepts, formulas and functions explained in detail.

Prerequisites

There are no prerequisites for this course.

Who Can Benefit

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

Session Outline

Class Outline

Module 1: Course Overview

 

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: 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

  • Lesson 1: Best Practices for Success in Business Intelligence
  • Lesson 2: It Is All in the Numbers
  • Lesson 3: Tables or Graphs
  • Lesson 4: Types of Graphs
  • Lesson 5: Key Performance Indicators
  • Lesson 6: Pitfalls in Dashboard Design
  • Lesson 7: Group Exercise and Discussion

After completing this module, students will be able to:

  • Understand best practices for success in business intelligence
  • Understand how to choose between tables or graphs and what makes each unique
  • Understand key performance indicators
  • Explain and avoid pitfalls in dashboard design
  • Understand what makes an effective dashboard

Module 3: Sourcing the Data

  • Lesson 1: Importing the Data
  • Lesson 2: Relating the Data in the Model
  • Lesson 3: Date Table
  • Lesson 4: Enriching the Data

After completing this module, students will be able to:

  • Import data into the model
  • Create relationships between tables in the data model
  • Mark a table as a date table
  • Create calculated fields
  • Create a KPI in PowerPivot

Module 4: Creating the Excel Dashboard

  • Lesson 1: Adding the Pivot Tables from PowerPivot
  • Lesson 2: Adding the Pivot Charts from PowerPivot
  • Lesson 3: Enhancing the Dashboard with a Linked Table
  • Lesson 4: Formatting with Color

After completing this module, students will be able to:

  • Add pivot tables from PowerPivot
  • Add pivot charts from PowerPivot
  • Enhance the dashboard with a linked table
  • Format dashboards with color

Module 5: Adding Power View Maps and Sharing

  • Lesson 1; Power View in Excel 2013
  • Lesson 2: Power View User Interface
  • Lesson 3: Tables
  • Lesson 4: Charts
  • Lesson 5: Maps
  • Lesson 6: Sharing Dashboards

After completing this module, students will be able to:

  • Understand the options provided with Power View

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

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

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now