10988: Managing SQL Business Intelligence Operations

10988: Managing SQL Business Intelligence Operations


The primary audience for this course are business intelligence professionals.

The secondary audiences for this course are technically proficient business users.


In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some 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


3 days.

Course Objectives

This three-day instructor-led course is aimed at database professionals who manage Business Intelligence (BI) operations. 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.

After completing this course, students will be able to:

  • Describe key features of a self-service BI solution
  • Describe the key capabilities of SQL Server BI in a SharePoint environment
  • Describe common Analysis Services operational tasks
  • Describe PowerPivot for SharePoint server
  • Describe Power Query
  • Describe Windows Azure HDInsight

Course Content

Module 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
Lab : Introduction to Operational Management in BI Solutions
After completing this module, you will be able to:
• Describe the rationale for BI operations.
• Describe roles in BI operations.
• Describe the technologies used in BI operations.
• Describe environments and operational standards.

Module 2: Configuring BI Components
The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments
Lab : Configuring BI Components
After completing this module, you will be able to:
• Describe the importance of standardized builds.
• Describe the configuration considerations for BI technologies.
• Describe BI architectures.
• Describe SharePoint BI environments.

Module 3: Managing Business Intelligence Security
Security Approach to BI Solutions
Security Components
Security Approach for BI Components
The Security Approach in Different BI Environments
Lab : Managing Business Intelligence Security
After completing this module, you will be able to:
• Describe the security approach to a BI solution.
• Understand the security components available.
• Apply the security components to BI technologies.
• Manage security in different environments.

Module 4: Deploying BI Solutions
Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments
Lab : Deploying BI Solutions
After completing this module, students will be able to:
• Application life cycle management for BI solutions.
• Stand-alone deployments.
• Team-based deployments.

Module 5: Logging and Monitoring in BI Operations
The Need for Logging and Monitoring
Logging Options
Monitoring Options
Setting Up Alerts
Lab : Monitoring BI Solutions
After completing this module, you will be able to:
• Describe the need for logging and monitoring.
• Use various logging options.
• Use monitoring tools.
• Set up notifications.

Module 6: Troubleshooting BI Solutions
Troubleshoot Failed BI Solutions
Troubleshooting the Data Warehouse
Troubleshooting SQL Server Analysis Services
Troubleshooting SQL Server Reporting Services
Lab : Troubleshooting BI Solutions
At the end of this module, you will know the correct approach for troubleshooting:
• Failed BI solutions.
• Data Warehouse.
• Analysis Services.
• Reporting Services.

Module 7: Performance Tuning BI Queries
The Need for Performance Tuning
BI Queries to Performance Tune
Tools for Performance Tuning
Remediating Performance Issues
Lab : Performance Tuning a BI Solution
After completing this module, you will be able to:
• Understand the need for performance tuning.
• Describe the BI queries required to carry out performance tuning.
• Use the tools for performance tuning.
• Remediate performance problems.

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...