MOC 10988 - Managing SQL Business Intelligence Operations

This Managing SQL Business Intelligence Operations training class is aimed at database professionals who manage Business Intelligence (BI) operations. This course looks at various ways business users can analyze data and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources.

The target audience for this course is business intelligence professionals, but it is also appropriate for technically proficient business users.

  Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Course Topics
  1. Learn to describe key features of a self-service BI solution.
  2. Learn to describe the key capabilities of SQL Server BI in a SharePoint environment.
  3. Learn to describe common Analysis Services operational tasks.
  4. Learn to describe PowerPivot for SharePoint server.
  5. Learn to describe Power Query.
  6. Learn to describe Windows Azure HDInsight.
Outline
  1. Introduction to Microsoft SQL Server BI Solution
    1. Overview of self-service BI
    2. Considerations of self-service BI
    3. Microsoft tools for self-service BI
    4. Lab: Exploring an enterprise BI solution
  2. SQL Server BI Features with Microsoft SharePoint
    1. Capabilities of Power BI with SharePoint
    2. SharePoint with analysis services
    3. SharePoint with reporting services
    4. Deploying SQL server BI in a SharePoint environment
    5. Lab: Design a SQL Server BI infrastructure
  3. Operating Analysis Services
    1. Configuring an analysis services server
    2. Tuning an analysis services server
    3. Analysis services security
    4. Analysis services high availability and disaster recovery
    5. Lab: Configuring analysis services
  4. Supporting Analysis Services
    1. Testing analysis services cubes
    2. Tuning analysis services
    3. Maintaining analysis services
    4. Lab: Supporting Analysis Services
  5. Operate and Support Reporting services
    1. Installing a native mode report server
    2. Installing reporting services with SharePoint
    3. Reporting services with Microsoft Azure virtual machines
    4. Reporting services errors
    5. Lab: Installing reporting services
  6. Share PowerPivot Workbooks in SharePoint Server
    1. PowerPivot for SharePoint
    2. Install and configure PowerPivot for SharePoint
    3. Lab: Install PowerPivot for SharePoint
  7. Operate and Support Power BI
    1. Power BI desktop
    2. PowerBI.Com
    3. Mobile Power BI
    4. Lab: Using Power BI
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2008.
  • Familiarity with the Windows Server 2012 operating system and networking.
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Training for Yourself

$1,785.00 or 3 vouchers

Upcoming Live Online Classes

  • See More Classes

Please select a class.

Training for your Team

Length: 3 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

Our instructor was great! He was enthusiastic and motivating for the entire two days of the course. He had a great deal of knowledge about the course content as well as related applications. I am looking forward to taking the advanced course with him.
Ryan Crockett
Schoolcraft College
I was hesitant to sign up for the class due to the cost. I am so glad that I did! My instructor was awesome and I am so happy with all that I learned. I would have spent a week of my own time trying to learn all of this. I am very happy and I would recommend this method of learning to everyone. It is WELL worth the cost.
Susan Roth
teacher
This class provided a path of enlightenment and the map to navigate it.
Spencer Armand
Arben Solutions
This is the 21st century training at it's best. Documentation is perfect. Training material is perfect. Examples and class environment exceeded my expectations. I made a great leap forward to keep up with today's technology in just a week!
Daniel Hudsky
BMC Software Inc

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

64,439

Students who have taken Instructor-led Training

11,983

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.30

Students rated our trainers 9.30 out of 10 based on 30,409 reviews

Contact Us or call 1-877-932-8228