Managing SQL Business Intelligence Operations (M10988)

In this course, you will learn about business intelligence (BI) solutions with Microsoft SQL Server 2016. You will learn about the Microsoft tools and key features of a self-service BI solution. Additionally, you will examine SQL Server BI in a SharePoint environment, which includes PowerPivot, analysis services, and reporting services (such as Power Query and Windows Azure HDInsight).

This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 10988: Managing SQL Business Intelligence Operations.


  • Key features of a self-service BI solution
  • Key capabilities of SQL Server BI in a SharePoint environment
  • Common analysis services operational tasks
  • PowerPivot for SharePoint server
  • Power Query
  • Windows Azure HDInsight

Target Audience

  • BI professionalsæ
  • Technically proficient business users?


  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with SharePoint Server and Microsoft Office applications (particularly Excel)

Expected Duration

3 day

Course Objectives

1.æIntroduction to Microsoft SQL Server BI Solution

´æOverview of Self-Service BI
´æConsiderations of Self-Service BI
´æMicrosoft Tools for Self-Service BI

2.æSQL Server BI Features with Microsoft SharePoint

´æCapabilities of Power BI with SharePoint
´æSharePoint with Analysis Services
´æSharePoint with Reporting Services
´æDeploying SQL Server BI in a SharePoint Environment

3.æOperating Analysis Services

´æConfigure an Analysis Services Server
´æTuning an Analysis Services Server
´æAnalysis Services Security
´æAnalysis Services High Availability and Disaster Recovery

4.æSupport Analysis Services

´æTest Analysis Services Cubes
´æTuning Analysis Services
´æMaintain Analysis Services

5.æOperate and Support Reporting Services

´æInstall a Native Mode Report Server
´æInstall Reporting Services with SharePoint
´æReporting Services with Microsoft Azure Virtual Machines
´æReporting Services Errors

6.æShare PowerPivot Workbooks in SharePoint Server

´æPowerPivot for SharePoint
´æInstall and Configure PowerPivot for SharePoint

7.æOperate and Support PowerBI

´æPowerBI Desktop
´æMobile Power BI