LeapFox Learning Boise

10988 - Managing SQL Business Intelligence Operations

Training for Your Group

  • Private class for your team
  • Online or on-location
  • Fully customizable course material
  • Onsite testing available

Training On Demand


  • Learn at Your Own Pace
  • Train from Anywhere
  • Learn when it is most Convenient
  • World-Class Instructors

Training for Individuals


  • Live, Instructor-led training
  • Expert instructors
  • Hands-on instruction

Course 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.

Course Length: 3 days

Audience: Business intelligence professionals. Technically proficient business users.

Prerequisites: 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.

What You're Going To Learn

  • Learn to describe key features of a self-service BI solution.
  • Learn to describe the key capabilities of SQL Server BI in a SharePoint environment.
  • Learn to describe common Analysis Services operational tasks.
  • Learn to describe PowerPivot for SharePoint server.
  • Learn to describe Power Query.
  • Learn to describe Windows Azure HDInsight.

Register for an Upcoming Date

Date Location Price Register

This Course is Available On Demand

90 Day Access

$ 999
  • 90 Day Subscription

180 Day Access

$ 1199
  • 180 Day Subscription
Most Popular

180 Day Access +

$ 1399
  • 180 Day Subscription

Course Outline

Introduction to Microsoft SQL Server BI Sulution

  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft touls for self-service BI
  • Lab: Exploring an enterprise BI sulution

SQL Server BI Features with Microsoft SharePoint

  • Capabilities of Power BI with SharePoint
  • SharePoint with analysis services
  • SharePoint with reporting services
  • Deploying SQL server BI in a SharePoint environment
  • Lab: Design a SQL Server BI infrastructure

Operating Analysis Services

  • Configuring an analysis services server
  • Tuning an analysis services server
  • Analysis services security
  • Analysis services high availability and disaster recovery
  • Lab: Configuring analysis services

Supporting Analysis Services

  • Testing analysis services cubes
  • Tuning analysis services
  • Maintaining analysis services
  • Lab: Supporting Analysis Services

What to Expect at LeapFox

Knowledgeable Instructors

Our instructors are certified professionals. They are trained on the latest features and how to get the most out of software programs.

Hands-on Labs

No boring lectures! Our courses are designed to give students lots of time to practice what they are learning with hands-on exercises and projects.

Bounce Back Pass

Retake any public course as many times as you like for up to one year for classroom live classes and six months for remote live courses.

Certificate of Completion

Receive a certificate of completion at the end of every course.

Up-to-date Curriculum

Each course comes with a helpful and up-to-date ebook which will contain instruction and practice exercises.

Time Saving Tips N Tricks

In each course, your instructor will show you tips and tricks that will save you time and make you more efficient.

Friendly and Helpful Staff

Our staff is dedicated to your success. Each team member is trained to provide the absolute best customer service possible.

Satisfaction Guarantee

If you aren't 100% satisfied with your experience at LeapFox, simply let us know, and we will make it right.

Look who Else is Using LeapFox

See What Our Customers Say

Close Menu