• Online, Self-Paced
Course Description

Designing Advanced Solutions in SharePoint 2013 involves being able to plan for Business Intelligence operations and integration. In this course, you will obtain an understanding of what is new when it comes to planning for Business Intelligence. You will learn how the business connectivity service is supported and how plan and configure the Business Intelligence (BI) infrastructure. You'll also learn how to support the Secure Store application by generating a master key and creating and managing target applications. Lastly, you will understand how Business Intelligence is supported by planning and configuring items such as Performance Point, Reporting Services, Excel Services, and BI security. This course is one of a series in the Skillsoft learning path that covers the objectives for the Advanced Solutions of Microsoft SharePoint Server 2013 certification exam (70-332).

Learning Objectives

Supporting the Business Connectivity Service (BCS)

  • start the course
  • recognize why companies use technologies related to Business Intelligence
  • recognize how BCS uses External Content Types
  • describe the concept of BCS models
  • match the BCS Model object level security type to its description
  • assign BCS permissions
  • describe the function of a BCS profile site
  • create a search-based profile page

Supporting the Secure Store Application

  • describe the Secure Store service application
  • create a Secure Store target application
  • configure credentials for a target application
  • list the BI tools available for creating reports from raw data

Supporting Business Intelligence Elements

  • explain PerformancePoint functionality
  • create and define a PerformancePoint data source
  • describe SQL Server Reporting Services
  • recognize the requirements needed by PowerPivot to create complex reports
  • recognize the BI security tools available

Practice: Support Business Intelligence

  • plan for and support SharePoint Business Intelligence

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Systems Administration