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 is also available in the On-Demand delivery format with digital Microsoft Official Courseware (dMOC). Click here to purchase.

View Entire Schedule

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

Viewing outline for:

Virtual Classroom Live Outline

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. Configuring BI Components

Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments

3. Managing Business Intelligence Security

Security Approach to BI Solutions
Security Components
Security Approach for BI Components
The Security Approach in Different BI Environments

4. Deploying BI Solutions

Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments

5. Logging and Monitoring in BI Operations

The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts

6. Troubleshooting BI Solutions

Troubleshoot Failed BI Solutions
Troubleshooting the Data Warehouse
Troubleshooting SQL Server Analysis Services
Troubleshooting SQL Server Reporting Services

7. Performance Tuning BI Queries

The Need for Performance Tuning
BI Queries to Performance Tuning
Tools for Performance Tuning
Remediating Performance Issues

Viewing labs for:

Virtual Classroom Live Labs

Lab 1: Explore an Enterprise BI Solutions
Lab 2: Design a SQL Server BI Infrastructure
Lab 3: Configure Analysis Services
Lab 4: Support Analysis Services
Lab 5: Install Reporting Services
Lab 6: Install PowerPivot for SharePoint
Lab 7: Use Power BI

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

BI professionals
Technically proficient business users

SATV Redemption

Redeeming your Microsoft Software Assurance Training Vouchers:

Redeem three SATVs for a Classroom Live session
Redeem three SATVs for a Virtual Classroom Live session
Redeem two SATVs for an individual On-Demand course

For more information on Microsoft SATVs, click here.

Training Exclusives

This course comes with 12 months access to the following benefits:

Practice Labs
24x7 Mentoring
Indexed Class Recordings
Unlimited Course Retakes
Digital courseware

Find out more

Course Delivery

This course is available in the following formats:

Request this course in a different delivery format.

Download Course Details

Cart () Loading...

Subtotal

Topics

Brands

Topics

Brands

Managing SQL Business Intelligence Operations (M10988)

Course Overview

Schedule

What You'll Learn

Outline

Virtual Classroom Live Outline

Labs

Virtual Classroom Live Labs

Prerequisites

Who Should Attend

Vendor Credits

SATV Redemption

Training Exclusives

Course Delivery