Managing SQL Business Intelligence Operations Training (10988)

Level: Foundation

This official Microsoft three-day SQL Business Intelligence Operations 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 analyse data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

Key Features of this SQL Business Intelligence Operations Training:

  • Microsoft Official Course (MOC) content
  • Eligible for SATV redemption

You Will Learn How 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


Choose the Training Solution That Best Fits Your Individual Needs or Organisational Goals


On Demand + Instructor Coaching

  • The same high quality MOC content as the live event
  • Flexibility to take the course on your own time, at your own pace
  • Enjoy a blend of video, text, hands-on labs, and knowledge checks with on demand training
  • Forever access to the digital course materials – including future course content updates
View Course Details

Standard £575




Team Training

  • Bring this or any training to your organisation
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching

Customize Your Team Training Experience


Save More on Training with Learning Tree Training Vouchers!

Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.

On Demand + Instructor Coaching

SQL Business Intelligence Operations On-Demand Training Information

  • On-Demand Training Description

    With a blend of video, text, hands-on labs, and knowledge checks, you will receive the same high quality content as the live event, but you can attend on your own time, at your own pace.

    PLUS, we include access to a Microsoft Certified Trainer(MCT) to help you prepare for your certification exam and help you apply your new skills immediately… Learning Tree knows how to bring learning to life!

    • Flexibility to take the course on your own time, at your own pace
    • Forever access to the digital course materials – for any refreshers
    • You will receive a code with your purchase.The code may be redeemed for online access to this On Demand course for up to six months
    • Upon course activation, the MOC On Demand videos and labs are available for three months
    • 2 FREE hours of individual coaching from an MCT Learning Tree Instructor
    • This delivery is also eligible for Microsoft Assurance Training Vouchers (SATVs)
  • Requirements

    • 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
  • Redeem Your Microsoft Training Vouchers (SATV)

    • This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.

SQL Business Intelligence Operations Course Outline

  • Module 1: Introduction to Operational Management in BI Solutions

    This module is designed to set the scene for the rest of the course.


    • 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

    This module focuses on optimising the data platforms on which the BI solutions reside, adhering to best practise to meet the requirements of the business.


    • The Importance of Standardised 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 standardised builds
    • Describe the configuration considerations for BI technologies
    • Describe BI architectures
    • Describe SharePoint BI environments


  • Module 3: Managing Business Intelligence Security

    This module discusses how managing the security of data within an organisation should be the first priority for any operational team.


    • 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

    This module helps you to understand the tools that are available and the benefits they offer will help you to pick the right tool for the job and aid deployment.


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

    Lab: Deploying BI Solutions

    After completing this module, you will be able to:

    • Understand application life-cycle management for BI solutions
    • Understand stand-alone deployments
    • Understand team-based deployments


  • Module 5: Logging and Monitoring in BI Operations

    This module introduces techniques to ensure the continued service of key applications that are used within the business.


    • 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

    This module introduces techniques to troubleshoot failed BI operations.


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

    Lab: Troubleshooting BI Solutions

    After completing this module, you will be able to:

    • Troubleshoot failed BI solutions
    • Troubleshoot data warehouses
    • Troubleshoot Analysis Services
    • Troubleshoot Reporting Services


  • Module 7: Performance Tuning BI Queries

    This module introduces tuning the query aspects of the BI solution to improve performance.


    • 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


Team Training

SQL Business Intelligence Training FAQs

  • How do I take this SQL Business Intelligence in an on-demand, self-paced format?

    By choosing the training solution that best fits your individual needs or organisational goals.

  • How can I bring this course to my facility to train my team on SQL business intelligence operations?

    Learning Tree provides Private Team Training that can save time and travel costs by training your entire team at once, at a convenient location of your choice. We handle all the details including instructor travel, tailored content, comprehensive course materials, shipping and equipment setup and teardown.

    Learn more about Private Team Training ›

  • Can I use SATVs to take this SQL Business Intelligence course?

    Yes! This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.

Questions about which training is right for you?

call 0800 282 353
chat Live Chat

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition fee!
  • No advance payment required for most products.
  • Tuition fee can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français