Configuring SharePoint 2013 for Business Intelligence

Pluralsight

Course Summary

In this course, you will learn how to configure your SharePoint 2013 farm to use all the wonderful Business Intelligence features SharePoint has to offer.

+
Course Description

SharePoint has many Business Intelligence (BI) tools to help you make informed business decisions quickly and accurately, but getting them all to work properly can be an intimidating task. With this course, you will chart your way through the treacherous waters of SharePoint BI and reach the other side intact. SharePoint BI has many moving parts, many of which involve manipulating SQL Server, which is never an easy thing. This course explores not only SharePoint, but SQL Server as well. You will learn to configure Excel Services, which is the backbone of so many of the BI tools, and install SQL Server Analysis Services to work with SharePoint. Beyond that, we cover PowerPivot, Power View, SQL Server Reporting Services, and many other BI tools of SharePoint. This is a must-view course if you need to prepare your SharePoint farm for Business Intelligence.

Course Description

SharePoint has many Business Intelligence (BI) tools to help you make informed business decisions quickly and accurately, but getting them all to work properly can be an intimidating task. With this course, you will chart your way through the treacherous waters of SharePoint BI and reach the other side intact. SharePoint BI has many moving parts, many of which involve manipulating SQL Server, which is never an easy thing. This course explores not only SharePoint, but SQL Server as well. You will learn to configure Excel Services, which is the backbone of so many of the BI tools, and install SQL Server Analysis Services to work with SharePoint. Beyond that, we cover PowerPivot, Power View, SQL Server Reporting Services, and many other BI tools of SharePoint. This is a must-view course if you need to prepare your SharePoint farm for Business Intelligence.

+
Course Syllabus

Configuring the Secure Store Service
- 8m 51s

—Intro 2m 36s
—Create the Service Application 3m 30s
—Generate the Secure Store Key 2m 1s
—Summary 0m 42s

Create a Business Intelligence Center
- 11m 31s

—Intro 2m 5s
—Create the BI Site Collection 3m 41s
—Test the Sample Workbook 4m 11s
—Summary 1m 32s

Excel Services
- 17m 48s

—Intro 1m 20s
—Create the Excel Services Service App 3m 42s
—Grant Database Access 5m 30s
—Suppress OWA 2m 26s
—Test Excel Services 2m 39s
—Summary 2m 9s

Install SQL Server Analysis Service
- 22m 55s

—Intro 1m 30s
—Install SSAS 6m 53s
—Attach the Database 3m 35s
—Add the Service Account Login 1m 32s
—Add a Multidimensional Data Cube 3m 44s
—Configure the Firewall 1m 44s
—Test Analysis Services 1m 45s
—Summary 2m 8s

Data Refresh and the Unattended Service Account
- 36m 7s

—Intro 1m 52s
—Data Refresh 6m 1s
—Create a New Target Application 6m 4s
—Configure Excel to Use the Secure Store 1m 38s
—Add the Service Account Login 1m 23s
—Test the Data Refresh 10m 58s
—Give the Target Application to the SSAS Cube 1m 59s
—Test Data Refresh with a SSAS Cube 3m 49s
—Summary 2m 18s

Install and Configure PowerPivot for SharePoint
- 59m 42s

—Intro 3m 59s
—Install SQL Server PowerPivot for SharePoint 11m 6s
—Add PowerPivot to Excel Services 2m 34s
—Run the PowerPivot for SharePoint Configuration Wizard 11m 27s
—Resolve Configuration Errors 4m 32s
—The PowerPivot Service Application 5m 4s
—Test PowerPivot 6m 17s
—Create the PowerPivot Gallery 2m 51s
—Grant the APP Pool Permissions to SSAS 1m 36s
—Test the PowerPivot Gallery 5m 30s
—Summary 4m 42s

SQL Server Reporting Services
- 24m 46s

—Intro 2m 11s
—Installing SQL Server Reporting Services 6m 36s
—Create the SSRS Service App 3m 31s
—Create a SSRS Report Library 2m 26s
—Test SQL Server Reporting Services 7m 26s
—Summary 2m 33s

Power View for SharePoint 2013
- 14m 43s

—Intro 1m 42s
—Activate Power View 4m 55s
—Create a Power View Visualization 6m 26s
—Summary 1m 37s

PerformancePoint Services
- 27m 12s

—Intro 1m 33s
—Configure PerformancePoint Services (PPS) 8m 47s
—Configure PPS to use the Secure Store 5m 31s
—Create a Data Source 2m 56s
—Create a Report 2m 41s
—Create a Dashboard 0m 59s
—Add a Report to a Dashboard and Deploy to SharePoint 2m 35s
—Summary 2m 6s

Access Services 2013
- 37m 0s

—Intro 2m 7s
—About Access Services 4m 3s
—Install SQL Server for Access Services 6m 9s
—Configure SQL Server 7m 0s
—Create the Access Service App and App Pool 6m 25s
—Service Account Permissions 2m 52s
—Configure IIS 1m 59s
—Create a Custom Web App 4m 7s
—Summary 2m 16s

Visio Graphics Services
- 20m 54s

—Intro 2m 53s
—Create a Target Application 3m 32s
—Create the Service Application 2m 48s
—Add the Target Application to Visio Services 0m 59s
—Create a Visio Web Drawing 7m 58s
—Summary 2m 41s

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

This course is listed under Cloud Computing , Development & Implementations , Enterprise Applications , Data & Information Management , IT Security & Architecture and Server & Storage Management Community

Attended this course? Write a Review

Course Fee:

USD 29

Course Type:	Self-Study
Course Status:	Active
Workload:	1 - 4 hours / week

IT Career Development Platform

Configuring SharePoint 2013 for Business Intelligence

Pluralsight

Course Summary

Course Description

Course Description

Course Syllabus

Course Type:

Course Status:

Workload:

SharePoint

SQL (Structured Query Language)

SharePoint 2013

Power View

SSAS (Sql Server Analysis Services)

SQL Server Reporting Services (SSRS)

Business Intelligence (BI)

Web application (Web app)

Internet Information Server (IIS)

Firewall

Attended this course? Write a Review

Course Type:

Course Status:

Workload: