10988: Managing SQL Business Intelligence Operations




    3 Day(s) Course


    Official Courseware


    Certified Trainer


    Exam Voucher


    1:1 Training Available on Demand


    Customize Your Batch

    Course Information

    10988 Managing SQL Business Intelligence Operations training is a three-day course that targets professionals who manage Business Intelligence (BI) operations. This Microsoft Business Intelligence training course provides a comprehensive outlook of BI operations that will equip the ability of business users in analyzing data and share their findings, starting with managed BI data sources and also involving expanding of personal and external/public data sources.

    Completion of this course will equip participants with the following skill set and knowledge base:

    • 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


    Module 1: Introduction to Operational Management in BI Solutions

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

    Module 2: Configuring BI Components

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

    Module 3: Managing Business Intelligence Security

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

    Module 4: Deploying BI Solutions

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

    Module 5: Logging and Monitoring in BI Operations

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

    Module 6: Troubleshooting BI Solutions

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

    Module 7: Performance Tuning BI Queries

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


    • This course majorly targets business intelligence professionals.
    • The secondary audiences for this course are technically proficient business users.


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

    • A basic knowledge of data warehouse schema topology (including star and snowflake schemas)
    • 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
    • Some exposure to basic programming constructs (such as looping and branching)


    Name Code Fee



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.