Microsoft SQL Server 2014 - Designing BI Solutions: SharePoint Integration


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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).

Target Audience
Database and business intelligence administrators and developers who are responsible for designing a BI infrastructure, IT professionals interested learning how to design BI infrastructures and how they're related to data systems, and individuals interested in taking the Designing Business Intelligence Solutions with Microsoft SQL Server exam (70-467)

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

Microsoft SQL Server 2014 - Designing BI Solutions: 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
  • 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
  • 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
  • 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
  • demonstrate how to integrate SharePoint into Microsoft SQL Server 2014
  • Course Number:
    md_dbis_a05_it_enus

    Expertise Level
    Expert