Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (20467)

Level: Intermediate
RATING: 4.3/5 4.33/5 Based on 9 Reviews

This training course 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.

This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.

This course is part of a Microsoft Certification Path and can help you prepare for your MCSA Certification, MCSE Certification, or MCSD Certification.

Key Features of this Training

  • Placeholder

You Will Learn How To

  • Plan a BI solution.
  • Plan SQL Server BI infrastructure.
  • Design a data warehouse.
  • Design an extract, transform and load (ETL) solution.
  • Design analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design a Microsoft Excel-based reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Operate a BI solution.

Choose the Training Solution That Best Fits Your Individual Needs or Organizational Goals

LIVE, INSTRUCTOR-LED

In Class & Live, Online Training

View Details & Schedule ›

Standard $3710

Government $3260

GET STARTED

PRODUCT #8469

TRAINING AT YOUR SITE

Team Training

  • Bring this or any training to your organization
  • Full - scale program development
  • Delivered when, where, and how you want it
  • Blended learning models
  • Tailored content
  • Expert team coaching
View Details ›

Contact Us for Team Pricing

GET STARTED

Save More On Training with FlexVouchers – A Unique Training Savings Account

Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.

In Class & Live, Online Training

  • Dec 10 - 14 (5 Days)
    9:00 AM - 4:30 PM EST
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Mar 11 - 15 (5 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Jun 10 - 14 (5 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

  • Sep 9 - 13 (5 Days)
    9:00 AM - 4:30 PM EDT
    Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Important Course Information

  • Requirements

    • In addition to their professional experience, students who attend this training should already have the following technical knowledge:
      • A basic understanding of dimensional modeling (star schema) for data warehouses
      • Basic server hardware knowledge
      • The ability to create Integration Services packages that include control flows and data flows
      • The ability to create a basic multidimensional cube with Analysis Services
      • The ability to create a basic tabular model with PowerPivot and Analysis Services
      • The ability to create Reporting Services reports with Report Designer
      • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
      • Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel
  • Exam Information

  • Redeem Your Microsoft Training Vouchers (SATV)

Course Outline

  • Module 1: Planning a BI Solution

    This module enables students to plan the components of a BI Solution.

    Lessons

    • Elements of a BI Solution
    • Planning a BI Project
    • The Microsoft BI Platform

    Lab : Planning BI Solutions

    After completing this module, students will be able to:

    • Describe the components of a BI Solution.
    • Identify the components of a BI Solution.
    • Plan a BI Project.
  • Module 2: Planning SQL Server Business Intelligence Infrastructure

    This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.

    Lessons

    • Considerations of BI Infrastructure
    • Planning Data Warehouse Hardware

    Lab : Planning BI Infrastructure

    After completing this module, students will be able to:

    • Describe the components of a BI Infrastructure and where you would use them.
    • Plan for the hardware requirements of a data warehouse implementation.
  • Module 3: Designing a Data Warehouse

    This module describes how to design a data warehouse given a set of user requirements.

    Lessons

    • Data Warehouse Design Overview
    • Designing Dimension Tables
    • Design FACT tables

    Lab : Designing a Data Warehouse Logical Schema

    After completing this module, students will be able to:

    • Design a data warehouse.
    • Design dimension tables.
    • Design Fact tables.
    • Design a logical schema for a data warehouse.
  • Module 4: Designing an ETL solution

    This lesson describes how to design an extract, transform and load (ETL) solution.

    Lessons

    • ETL Overview
    • Planning for Data Extraction
    • Planning for Data Transformations
    • Planning for Data Loading

    Lab : Designing an ETL Solution

    After completing this module, students will be able to:

    • Describe the components of an ETL solution.
    • Design an ETL solution.
  • Module 5: Designing Analytical Data Models

    This module describes how to design analytical data models for specific BI scenarios.

    Lessons

    • Introduction to Analytical data Models
    • Designing Analytical Data Models

    Lab : Designing Analytical Data Model

    Lab : Designing Dimensions and Hierarchies

    After completing this module, students will be able to:

    • Describe the features of an analytical data model.
    • Design an analytical data model.
  • Module 6: Planning a BI Delivery Solution

    This module describes how to choose an appropriate delivery solution for a given scenario.

    Lessons

    • Considerations for BI delivery
    • Common Reporting Scenarios
    • Choosing a Reporting Tool

    Lab : Planning a BI Delivery Solution

    After completing this module, students will be able to:

    • Describe the components of a BI delivery solution.
    • Describe some common reporting scenarios.
    • Choose an appropriate delivery solution for a given scenario.
  • Module 7: Designing a Reporting Services Solution

    This module describes how to design a reporting services solution.

    Lessons

    • Planning a Reporting Solution
    • Designing Reports
    • Planning Report Consistency

    Lab : Designing a Reporting Services Solution

    After completing this module, students will be able to:

    • Plan for a reporting Services solution.
    • Design reports for a reporting services solutions.
    • Plan for consistency of reporting
  • Module 8: Designing an Excel Based reporting Solution

    In this module students will learn how to design a reporting solution using Excel.

    Lessons

    • Using Excel for Data Reporting and Analysis
    • PowerPivot in Excel
    • Power View in Excel

    Lab : Designing and Excel Reporting Solution

    After completing this module, students will be able to:

    • Describe key features of excel reporting solutions.
    • Use PowerPivot in Excel to create reports.
    • Use Power View in excel to create reports.
  • Module 9: Planning a SharePoint Server BI Solution

    This module introduces the use of SharePoint Server as a BI solution.

    Lessons

    • Introduction to SharePoint Server as a BI Platform
    • Planning Security for a SharePoint Server BI Solution
    • Planning Reporting Services Configuration
    • Planning PowerPivot Configuration
    • Planning for PerformancePoint Services

    Lab : Implementing a SharePoint Server BI Solution

    Lab : Implementing PerformancePoint Services

    After completing this module, students will be able to:

    • Describe the components of a SharePoint Server BI solution.
    • Plan security for a SharePoint Server BI solution.
    • Plan reporting solutions for a SharePoint Server BI solution.
    • Describe the components of a PerformancePoint Solution.
    • Implement PerformancePoint services.
  • Module 10: Monitoring and Optimizing a BI Solution

    At the conclusion of this module you will be able to optimize and monitor a BI solution.

    Lessons

    • Overview of BI Monitoring
    • Monitoring and Optimizing the Data Warehouse
    • Monitoring and Analyzing Analysis Services
    • Monitoring and Optimizing Reporting Services

    Lab : Monitoring and Optimizing a BI Solution

    After completing this module, students will be able to:

    • Describe the options for monitoring and optimizing a BI solution.
    • Be able to monitor and optimize a BI solution.
  • Module 11: Operating a BI Solution

    At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.

    Lessons

    • Overview of BI Operations
    • ETL Operations
    • Data Warehouse Operations
    • Analysis Services Operations
    • Reporting Services Operations

    Lab : Operating a BI Solution

    After completing this module, students will be able to:

    • Describe the components to be managed in a BI Solution.
    • Be able to manage the components of a BI solution.

Team Training

Important Course Information

  • Requirements

    • In addition to their professional experience, students who attend this training should already have the following technical knowledge:
      • A basic understanding of dimensional modeling (star schema) for data warehouses
      • Basic server hardware knowledge
      • The ability to create Integration Services packages that include control flows and data flows
      • The ability to create a basic multidimensional cube with Analysis Services
      • The ability to create a basic tabular model with PowerPivot and Analysis Services
      • The ability to create Reporting Services reports with Report Designer
      • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services
      • Familiarity with SharePoint Server and Microsoft Office applications – particularly Excel
  • Exam Information

  • Redeem Your Microsoft Training Vouchers (SATV)

Course Outline

  • Module 1: Planning a BI Solution

    This module enables students to plan the components of a BI Solution.

    Lessons

    • Elements of a BI Solution
    • Planning a BI Project
    • The Microsoft BI Platform

    Lab : Planning BI Solutions

    After completing this module, students will be able to:

    • Describe the components of a BI Solution.
    • Identify the components of a BI Solution.
    • Plan a BI Project.
  • Module 2: Planning SQL Server Business Intelligence Infrastructure

    This module describes how to use plan appropriate BI Infrastructure given a set of BI Parameters.

    Lessons

    • Considerations of BI Infrastructure
    • Planning Data Warehouse Hardware

    Lab : Planning BI Infrastructure

    After completing this module, students will be able to:

    • Describe the components of a BI Infrastructure and where you would use them.
    • Plan for the hardware requirements of a data warehouse implementation.
  • Module 3: Designing a Data Warehouse

    This module describes how to design a data warehouse given a set of user requirements.

    Lessons

    • Data Warehouse Design Overview
    • Designing Dimension Tables
    • Design FACT tables

    Lab : Designing a Data Warehouse Logical Schema

    After completing this module, students will be able to:

    • Design a data warehouse.
    • Design dimension tables.
    • Design Fact tables.
    • Design a logical schema for a data warehouse.
  • Module 4: Designing an ETL solution

    This lesson describes how to design an extract, transform and load (ETL) solution.

    Lessons

    • ETL Overview
    • Planning for Data Extraction
    • Planning for Data Transformations
    • Planning for Data Loading

    Lab : Designing an ETL Solution

    After completing this module, students will be able to:

    • Describe the components of an ETL solution.
    • Design an ETL solution.
  • Module 5: Designing Analytical Data Models

    This module describes how to design analytical data models for specific BI scenarios.

    Lessons

    • Introduction to Analytical data Models
    • Designing Analytical Data Models

    Lab : Designing Analytical Data Model

    Lab : Designing Dimensions and Hierarchies

    After completing this module, students will be able to:

    • Describe the features of an analytical data model.
    • Design an analytical data model.
  • Module 6: Planning a BI Delivery Solution

    This module describes how to choose an appropriate delivery solution for a given scenario.

    Lessons

    • Considerations for BI delivery
    • Common Reporting Scenarios
    • Choosing a Reporting Tool

    Lab : Planning a BI Delivery Solution

    After completing this module, students will be able to:

    • Describe the components of a BI delivery solution.
    • Describe some common reporting scenarios.
    • Choose an appropriate delivery solution for a given scenario.
  • Module 7: Designing a Reporting Services Solution

    This module describes how to design a reporting services solution.

    Lessons

    • Planning a Reporting Solution
    • Designing Reports
    • Planning Report Consistency

    Lab : Designing a Reporting Services Solution

    After completing this module, students will be able to:

    • Plan for a reporting Services solution.
    • Design reports for a reporting services solutions.
    • Plan for consistency of reporting
  • Module 8: Designing an Excel Based reporting Solution

    In this module students will learn how to design a reporting solution using Excel.

    Lessons

    • Using Excel for Data Reporting and Analysis
    • PowerPivot in Excel
    • Power View in Excel

    Lab : Designing and Excel Reporting Solution

    After completing this module, students will be able to:

    • Describe key features of excel reporting solutions.
    • Use PowerPivot in Excel to create reports.
    • Use Power View in excel to create reports.
  • Module 9: Planning a SharePoint Server BI Solution

    This module introduces the use of SharePoint Server as a BI solution.

    Lessons

    • Introduction to SharePoint Server as a BI Platform
    • Planning Security for a SharePoint Server BI Solution
    • Planning Reporting Services Configuration
    • Planning PowerPivot Configuration
    • Planning for PerformancePoint Services

    Lab : Implementing a SharePoint Server BI Solution

    Lab : Implementing PerformancePoint Services

    After completing this module, students will be able to:

    • Describe the components of a SharePoint Server BI solution.
    • Plan security for a SharePoint Server BI solution.
    • Plan reporting solutions for a SharePoint Server BI solution.
    • Describe the components of a PerformancePoint Solution.
    • Implement PerformancePoint services.
  • Module 10: Monitoring and Optimizing a BI Solution

    At the conclusion of this module you will be able to optimize and monitor a BI solution.

    Lessons

    • Overview of BI Monitoring
    • Monitoring and Optimizing the Data Warehouse
    • Monitoring and Analyzing Analysis Services
    • Monitoring and Optimizing Reporting Services

    Lab : Monitoring and Optimizing a BI Solution

    After completing this module, students will be able to:

    • Describe the options for monitoring and optimizing a BI solution.
    • Be able to monitor and optimize a BI solution.
  • Module 11: Operating a BI Solution

    At the conclusion of this module you will be able to plan management and maintenance operations of a BI solution.

    Lessons

    • Overview of BI Operations
    • ETL Operations
    • Data Warehouse Operations
    • Analysis Services Operations
    • Reporting Services Operations

    Lab : Operating a BI Solution

    After completing this module, students will be able to:

    • Describe the components to be managed in a BI Solution.
    • Be able to manage the components of a BI solution.

Questions about which training is right for you?

call 888-843-8733
chat Live Chat




100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

  • If you are not 100 % satisfied, you pay no tuition!
  • No advance payment required for most products.
  • Tuition can be paid later by invoice - OR - at the time of checkout by credit card.

*Partner-delivered courses may have different terms that apply. Ask for details.

Herndon, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Preferred method of contact:
Chat Now

Please Choose a Language

Canada - English

Canada - Français