Managing SharePoint 2016 for Business Intelligence

Every organization needs business intelligence to survive and thrive and tens of millions of people use SharePoint every day. Find out how to bring data from any number of different data sources into one place users know and love: SharePoint 2016.
Course info
Level
Intermediate
Updated
Dec 29, 2017
Duration
1h 14m
Table of contents
Course Overview
Intro: Why BI Is Critically Important to Your Organization’s Future
Implementing Business Connectivity Services and the Secure Store Service
Planning and Configuring Business Intelligence
Deploying Advanced Analysis Tools
Recapping the Journey
Description
Course info
Level
Intermediate
Updated
Dec 29, 2017
Duration
1h 14m
Description

We are awash in a sea of data. What good is that unless we see the data we need to make the best business decisions possible? In this course, Managing SharePoint 2016 for Business Intelligence, you’ll learn how to make data from various sources available in one place familiar to your users: SharePoint. First, you’ll learn how to configure Business Connectivity Services and the Secure Store Service. Next, you’ll explore how to configure and manage Business Intelligence Services. Finally, you’ll dive into configuring advanced analysis tools like Power View, PowerPivot, and Reporting Services. When you’re finished with this course, you will have the skills and knowledge of SharePoint Business Intelligence needed to configure Business Intelligence in your environment.

About the author
About the author

Mark has trained and / or consulted in 20 countries since 1999, after retooling himself as an IT admin in the Windows NT 4.0 era at a local college. He has taught students at various Microsoft and Symantec campuses and at a variety of academic, military, corporate, and training center locations as well as online. He is the lead singer in three rock bands he founded, sings jazz, does voice overs, and has dabbled in stand-up and improv.

More from the author
Managing SharePoint 2016 Search
Intermediate
2h 20m
Aug 10, 2017
Basic Administration of SharePoint 2016
Beginner
1h 43m
Feb 7, 2017
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Mark Ingram, and welcome to my course, Managing SharePoint 2016 for Business Intelligence. I'm a consultant and trainer at Crystal Clear. SharePoint is a billion-dollar business for Microsoft. If your users are overwhelmed with data, SharePoint BI can restore sanity and lead to better business decisions. This course is going to teach you how to take a familiar technology, SharePoint 2016, and turbo charge it with tools to make interacting with data fun and easy. Some of the major topics we will cover include why BI is vital for the survival of your organization, how to bring data from many different repositories into SharePoint, deploying the new Office Online Server, and how to set up SQL Server Reporting Services, PowerPivot, and Power View. By the end of this course, you'll know how to make data from any organized data source available in an environment familiar to your users, SharePoint. Before beginning the course, you should be familiar with SharePoint administration basics. I hope you'll join me on this journey to learn SharePoint BI with the Managing SharePoint 2016 for Business Intelligence course, at Pluralsight.

Intro: Why BI Is Critically Important to Your Organization’s Future
Welcome to Managing SharePoint 2016 for Business Intelligence. My name is Mark Ingram. When you walk by your colleagues' desks, are they looking intensely at 12 windows on 3 monitors, straining to synthesize data from multiple data sources to make business decisions? If so, SharePoint 2016 BI functionality to the rescue! In this introductory module, we'll discuss the need for BI and briefly describe the modules in the course while giving you sneak peeks of some of the slides you'll see in upcoming modules. You'll learn how to make data from various sources available in one place familiar to your users, SharePoint. What good is a sea of data if we don't know how to interact with it in an intelligent way? Unlike this guy, by the end of the course, you'll be able to use the right tools in the right way to help you and your organization reach your intended destination.

Implementing Business Connectivity Services and the Secure Store Service
In this module, we'll cover Implementing Business Connectivity Services and the Secure Store Service. Most organizations have important business data stored in a wide variety of data storage systems and formats. The Holy Grail for many is to be able to view, modify, and delete data from these systems in one place, a single interface, avoiding lost productivity and irritation of switching between multiple systems. Thankfully, Business Connectivity Services, or BCS, is available in SharePoint 2016, enabling you to view, query, and update data from any number of external data sources. So let's learn exactly how to plan and configure the various elements of BCS, learning how they work together. We'll cover the architecture briefly, how to provision the BDC service application instance, learn about the Secure Store Service, or SSS, different authentication types to choose from, the importance of model scopes, and finally why and how to import and export models. I'll demonstrate all this and more in the context of hosting details for your legendary New Year's Eve affair.

Planning and Configuring Business Intelligence
In this module, we'll explore Planning and Configuring Business Intelligence. There are many ways people can consume data service by SharePoint BI, with Excel being the most common. We'll look at related technologies like SQL Server Analysis Services, PowerPivot, PerformancePoint Services, and more. Also, optimization factors, covering the four major subsystems on any computer, and how to optimize SharePoint BI. Also, the ubiquitous security concerns including authentication types and authentication modes.

Deploying Advanced Analysis Tools
In this module, we're examining Deploying Advanced Analysis Tools. Through BI, you can access data mining and analysis capabilities using SQL Server Reporting Services and SQL Server Analysis Services. Think of BI as being on a continuum between tools like Excel and SQL Server databases. We'll now examine what to plan for before deploying and managing SSRS, PowerPivot, and Power View in a SharePoint environment.

Recapping the Journey
Welcome to Pluralsight. This is Recapping the Journey. I'm Mark Ingram. In this course, we discussed the all-important why. Why should you care about making BI more readily available for the users you support? The answer is this, your users will be far more productive having information from disparate data sources come to them in a single interface logging on once a day. They'll never want to go back to the old way where they had to launch multiple windows and attempt to reconcile data stored in different formats, logging in multiple times. In the bigger picture, there is heavy competition for talent. By making life easier for your employees, you're more likely to retain and attract the best talent available. On the slide are the main areas that we covered including implementing Business Connectivity Services and the Secure Store Service, we talked about planning and configuring BI, and then finished off with Advanced Analysis Tools.