• Online, Self-Paced
Course Description

The primary goal of a Business Intelligence solution is the delivery of meaningful data to the business users to make informed decisions required for the business. SharePoint and Reporting Services can provide a collaboration and report delivery system for the business users. SharePoint provides Excel services along with PowerPivot and Power View to create meaningful reports which can be delivered through various means. In this course, you will learn how to integrate SharePoint with Reporting Services, including PowerPivot and Power View. You will also explore the various methods for processing and delivering reports to business users. This course is one of a series in the Skillsoft learning path that helps individuals prepare for the Designing Business Intelligence Solutions with Microsoft SQL Server exam (70-467).

Learning Objectives

SharePoint Integration

  • start the course
  • describe how SharePoint Server can fit into a BI Solution and the supported topologies
  • describe the features provided when SharePoint is integrated with a BI Solution
  • describe the steps taken to fully integrate SharePoint Server with a BI solution

Perform SharePoint Integration

  • install PowerPivot for SharePoint
  • install the PowerPivot for SharePoint add-in to add additional functionality
  • configure PowerPivot using the PowerPivot for SharePoint 2013 Configuration tool
  • install Reporting Services in SharePoint mode to enable and use Power View
  • install the Reporting Services add-in for SharePoint

Publish Reports

  • enable Report Server content types to a SharePoint library
  • use a PowerPivot workbook and publish it to SharePoint
  • create and publish a report using Power View to SharePoint

Manage Report Processing and Delivery

  • describe the two types of schedules, what you can accomplish with them, and how they work
  • describe the requirements for security for report processing and scheduling, including credentials for data sources and accounts
  • create and manage a schedule for Reporting Services in Native mode using Report Manager
  • create and manage a schedule for Reporting Services in SharePoint mode using Central Administration
  • plan for data refresh for PowerPivot in SharePoint, including security
  • configure data refresh schedules for PowerPivot published to SharePoint and perform an interactive refresh
  • set different processing options for reports in a SharePoint library, including caching, time-out, history options and limits, and database time-out options
  • plan a subscription strategy for report delivery
  • create a subscription for Report Servers in Native mode
  • create a subscription for Report Servers in SharePoint mode to deliver a report to a library
  • describe what data alerts are and how to use them
  • create a data alert for a report in a SharePoint library

Practice: Integrate SharePoint with SQL Server

  • demonstrate how to integrate SharePoint into Microsoft SQL Server 2014

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.