We are happy to advise you!
+49 40 253346-10     Contact

Online training in the virtual classroom
E-Learning offers and more

Find out more

Managing SQL Business Intelligence Operations (MOC 10988)

 

Course Overview

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.

Who should attend

  • The primary audience for this course are business intelligence professionals.
  • The secondary audiences for this course are technically proficient business users.

Prerequisites

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 Objectives

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

  • Introduction to Operational Management in BI Solutions
  • Configuring BI Components
  • Managing Business Intelligence Security
  • Deploying BI Solutions
  • Logging and Monitoring in BI Operations
  • Troubleshooting BI Solutions
  • Performance Tuning BI Queries
Online Training

Duration 3 days

Price (excl. tax)
  • 1,690.- €
  • SA Voucher: 3
    hardcoded default SA
Digital courseware

Courseware language: English

Classroom Training

Duration 3 days

Price (excl. tax)
  • Germany: 1,690.- €
  • Switzerland: CHF 2,240.-
  • SA Voucher: 3
    hardcoded default SA
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Digital courseware

Courseware language: English

Schedule

FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.
German
Time zone CEST
25/01/2021 ― 27/01/2021 Online Training Time zone: Central European Time (CET)
03/05/2021 ― 05/05/2021 Online Training Time zone: Central European Summer Time (CEST)
16/08/2021 ― 18/08/2021 Online Training Time zone: Central European Summer Time (CEST)
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.
Germany
25/01/2021 ― 27/01/2021 Münster
22/03/2021 ― 24/03/2021 Munich
03/05/2021 ― 05/05/2021 Berlin
07/06/2021 ― 09/06/2021 Frankfurt
16/08/2021 ― 18/08/2021 Hamburg
20/09/2021 ― 22/09/2021 Stuttgart
22/11/2021 ― 24/11/2021 Düsseldorf