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)
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