EXC13PV: Power View for Excel 2013

$900.00
$900.00
$900.00
$900.00
Start Date Time Days Price GTR Availability
May 18, 2017 09:00 (EST) 2 $900.00 Register
July 20, 2017 09:00 (EST) 2 $900.00 Register
September 21, 2017 09:00 (EST) 2 $900.00 Register
November 23, 2017 09:00 (EST) 2 $900.00 Register

Duration: 2 Days

Course Description
Excel 2013 Power View is one of the Power BI Excel add-ins that allow end-users to store, analyze and visualize large quantities of data from multiple tables and multiple databases using Excel.

Prerequisites
Course prerequisites include taking Excel 2013 Level 3, Power Pivot and Power Query.

Course Objectives
Upon successful completion of this course, students will be able to use Power View, create Map based on Power View Reports and create amazing Power View reports.

Audience
This course is for Excel Power Users, Business & Data Analysts, Financial Managers and Analysts, Planning Analysts, and Marketing Analysts.

Course Content

Introduction

  • Get started with Power View

Working with Data

  • Data sources for Power View
  • Import Data into Excel 2013, and Create a Data Model
  • Incorporate Internet Data, and Set Power View Report Defaults
  • Filter and highlight data
  • Slicers
  • Sorting   

Create charts and other visualizations

Create Map-based Power View Reports

Reporting – Create Amazing Power View Reports

  • Reports with multiple views in Power View in SharePoint
  • Share Power View reports
  • Share Power View in Excel
  • Share Power View in SharePoint reports (RDLX files)
  • Print Power View reports
  • Set Power View reporting properties in Power Pivot

Extend Data Model relationships using Excel 2013, Power Pivot, and DAX

Power View and Power Pivot are available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.