10988 Managing SQL Business Intelligence Operations
Request a Class



COURSE TIMES: 9:00am - 4:30pm

Printable version of this course


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

At course completion:

  • 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


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


*Course cost listed does not include the cost of courseware. Please contact us @ learn@vtec.org or 207-775-0244 for additional pricing information or if you have any questions. Course is subject to minimum enrollment. If minimum is not met this class may run as a LDL / Virtual class.
Note: This course is eligibile for Microsoft SATVs.


Module 1: Introduction to Microsoft SQL Server BI Solution
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

Module 2: Configuring BI Components
The Importance of Standardized Builds
Configuration Considerations for BI Technologies
BI Architectures
SharePoint BI Environments
Lab : Configuring BI Components

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

Module 4: Deploying BI Solutions
Application Life Cycle Management for BI Solution
Stand-Alone Deployments
Team-Based Deployments
Lab : Deploying BI Solutions

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

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

Module 7: Performance Turning 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