LeapFox Learning Boise

20467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Training for your Group

  • Private class for your team
  • Online or on-location
  • Fully customizable course material
  • Onsite testing available
  • Learning more about custom training

Training for Individuals


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

Course Overview

This five-day Designing Business Intelligence Solutions with Microsoft SQL Server 2014 training class teaches database and business intelligence (BI) professionals how to plan and design a BI solution that is based on Microsoft SQL Server 2014 and other Microsoft BI technologies

Course Length: 5 days

Audience:  BI professionals with experience of implementing solutions with SQL Server database Engine, SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services

PrerequisitesKnowledge of data warehousing and data modeling principles. Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013, MOC 20463,  MOC 20466

What You're Going To Learn

  • Learn to plan a BI solution.
  • Learn to plan SQL Server BI infrastructure.
  • Learn to design a data warehouse.
  • Learn to design an extract, transform and load (ETL) solution.
  • Learn to design analytical data models.
  • Learn to plan a BI delivery solution.
  • Learn to design a Reporting Services solution.
  • Learn to design a Microsoft Excel-based reporting solution.
  • Learn to plan a SharePoint Server BI solution.
  • Learn to monitor and optimize a BI solution.
  • Learn to operate a BI solution.

Register for an Upcoming Date

Date Location Price Register

Course Outline

Planning a BI Solution

  • Elements of a BI Solution
  • Planning a BI Project
  • The Microsoft BI Platform
  • Lab: Planning BI Solutions

Planning SQL Server Business Intelligence Infrastructure

  • Considerations of BI Infrastructure
  • Planning Data Warehouse Hardware
  • Lab: Planning BI Infrastructure

Designing a Data Warehouse

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Design FACT tables
  • Lab: Designing a Data Warehouse Logical Schema

Designing an ETL solution

  • ETL Overview
  • Planning for Data Extraction
  • Planning for Data Transformations
  • Planning for Data Loading
  • Lab: Designing an ETL Solution

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