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

Course Modality

Instructor-led training

Course Level

Intermediate

Course Time

2 Days

Course Language

English

Course Overview

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.

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.

Intended Audience

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

Job role: Developer

Features: none

Find a learning partner

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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.

Get In Touch

Course Curriculum

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

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

After completing this module, students will be able to:

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

odule explains how, in addition to file and share permissions, you can also use data encryption to restrict data access.

Lessons

Overview of Defense-in-Depth.
Physical Security.
Internet Security.

Lab: Implementing IT Security Layers

After completing this module, students will be able to:

Describe the risks posed by connecting to the Internet.
Describe possible mitigations to these risks.
Describe the Windows Server components and features that can help provide his Internet security.

Module 5

Adding Interactivity

Lessons

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 Services

Lessons

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.

See all instructor-led courses

Reviews

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.