This course looks at various options that provide the ability of business users to analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

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 Operational Management in BI Solutions

Rationale for BI Operations
Roles in BI Operations
Technologies Used in BI Operations
Environment and Operational Standards

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: Introduction to operational Management in BI Solutions

Lab 2: Configuring BI Components

Lab 3: Managing Business Intelligence Security

Lab 4: Deploying BI Solutions

Lab 5: Monitoring BI Solutions

Lab 6: Troubleshooting BI Solutions

Lab 7: Performance Tuning a BI Solution

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