search3
    
    10988: Managing SQL Business Intelligence Operations

    QUICK

    INFORMATION

    course-duration

    3 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Training

    customize-batch

    Customize Your Batch

    one-o-one

    1:1 Training Available on Demand

    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

    COURSE OUTLINE

    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

    WHO SHOULD ATTEND

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

    Pre-requisites

    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)

    Exam

    Name Code Fee

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.