MOC 10988 - Managing SQL Business Intelligence Operations

Customized Onsite Training

3
Days
  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

$1,425.00
or 3 vouchers
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

Upcoming Classes

  • See More Classes

Please select a class.
Overview

This three-day Managing SQL Business Intelligence Operations training class 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.

The primary audience for this course are business intelligence professionals.

The secondary audiences for this course are technically proficient business users.

Goals
  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.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

76,130

Students who have taken Live Online Training

15,315

Organizations who trust Webucator for their training needs

100%

Satisfaction guarantee and retake option

9.40

Students rated our trainers 9.40 out of 10 based on 5,230 reviews

Excellent class. Instructor was a real pro! I feel like I'm ready to design websites! Great job!

Harold Naves, Social Security Administration
Birmingham AL

I was very impressed with both the quality of the material and the excellence of the presenter. I felt like I was studying with a friend.

Lisa Griffin, Burr Pilger Mayer, Inc
San Francisco CA

Class size is excellent and the instructor is very hands on and willing to use your own materials for examples. I felt very comfortable in asking questions in such a small environment like this compared to a large seminar format type of class.

Emily Martinez, Connectria
Creve Coeur MO

Took the course sitting in front of my computer in Switzerland. I've learned much more than the course book had made me expect. My teacher not only answered questions directly referring to Google AdWords but also led me to see things in the context of Google Analytics and organic search. She's a great teacher.

David Hertig, Promoganda GmbH
Effretikon

Contact Us or call 1-877-932-8228