PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts

Session Detail:    Classroom 2 Day

This two-day instructor-led course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.
As far as possible each of the modules is stand-alone allowing for customization of the course for those audiences that may not have an interest in a certain service.

Prerequisites

Experience with Excel 2007 or higher.
An understanding of PivotTables.

Who Can Benefit

This course is intended for analysts, business intelligence (BI) developers and IT professionals that will be involved with the design, development, and maintenance of Excel workbooks utilizing PowerPivot and Power View 2013 to be surfaced on SharePoint.

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

Module 2: PowerPivot

  • Lesson 1: What is the data model?
  • Lesson 2: PowerPivot and Excel
  • Lesson 3: New 2013 PowerPivot Features
  • Lesson 4: PowerPivot and SharePoint
  • Lesson 5: Enterprise Business Intelligence and PowerPivot
  • Lesson 6: Enriching Data
  • Lesson 7: Importing Data
  • Lesson 8: Refreshing Data
  • Lesson 9: Formatting Data
  • Lesson 10: Sorting and Filtering
  • Lesson 11: Creating Relationships
  • Lesson 12: Calculations
  • Lesson 13: SharePoint Sharing

After completing this module, students will be able to:

  • Use PowerPivot within Excel to import a table from SQL Server
  • Use PowerPivot within Excel to import a table from SQL Server Analysis Services
  • Hide columns they don’t want to be reflected in the resulting PivotTable
  • View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing
  • Create a PivotTable within an existing worksheet

Module 3: Power View

  • Lesson 1: New 2013 Power View Features
  • Lesson 2: Microsoft Power View User Interface
  • Lesson 3: Tables
  • Lesson 4: Charts
  • Lesson 5: Saving and Sharing
  • Lesson 6: BI Semantic Models

After completing this module, students will be able to:

  • Navigate and successfully use Power View
  • Create a table
  • Create a chart
  • Save and share their work
  • Create a BI semantic model

Module 4: SharePoint 2013 Business Intelligence Center

  • Lesson 1: New 2013 SharePoint Central Administration
  • Lesson 2: New 2013 Business Intelligence Center
  • Lesson 3: Permissions and Roles
  • Lesson 4: Included Document Library and List Apps
  • Lesson 5: Create Custom Apps (Libraries) for Visualizations or Workbooks
  • Lesson 6: Create Custom Connection Apps (Libraries)
  • Lesson 7: Set Policies for Excel Services

After completing this module, students will be able to:

  • Explore the options and settings available within the new SharePoint 2013 Central Administration and Excel Services
  • Access and review the Secure Store
  • Create a new web application and business intelligence site while exploring the features of both
  • Create custom apps to store visualizations and/or workbooks in SharePoint 2013 Business Intelligence Center

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

PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts

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