Omaha, Nebraska Microsoft MOC 20467 SQL Server Training - Dynamics Edge

Omaha, Nebraska MOC Class 20467 SQL Server Training -> Designing Business Intelligence Solutions with Microsoft SQL Server 2014

Dynamics Edge4.67 4.67 out of 50 stars, based on 80 reviews.*

Make a selection of Dynamics Edge MOC Class 20467 exceptional SQL Server training course that is most convenient for you. Customized training may also be possible.

This five-day instructor-led course teaches students how to design and implement a BI infrastructure. The course discusses design, installation. The course discusses design, installation, and maintenance of a BI platform. This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam

Who Should Attend

This course is intended for BI professionals such as BI Architects or database professionals who need to design BI solutions. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use. In addition, their responsibilities include Online Analytical Processing (OLAP) cube design and integration with Microsoft SharePoint or line-of-business applications.

What You'll Learn

After completing this course, students will be able to:

Course Outline

Module 1: Planning a BI Solution

This module discusses how to plan the components of a BI solution.

Lessons

Lab : Planning a BI Solution

Module 2: Planning SQL Server Business Intelligence Infrastructure

This module explains how to plan an appropriate BI infrastructure for a given set of BI services.

Lessons

Lab : Planning a BI Infrastructure

Module 3: Designing a Data Warehouse

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

Lessons

Lab : Designing a Data Warehouse Logical Schema
Lab : Designing a Data Warehouse Physical Implementation

Module 4: Designing an ETL Solution

This module explains how to design an ETL solution for a data warehouse.

Lessons

Lab : Designing an ETL Solution

Module 5: Designing Analytical Data Models

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

Lessons

Lab : Comparing Analytical Data Models
Lab : Designing Dimensions and Hierarchies
Lab : Enhancing Analytical Data Models

Module 6: Planning a BI Delivery Solution

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

Lessons

Lab : Planning a BI Delivery Solution

Module 7: Designing a Reporting Services Solution

This module explains how to design a Reporting Services solution.

Lessons

Lab : Designing a Reporting Services Solution

Module 8: Designing a Microsoft Excel-Based Reporting Solution

This module explains how to design a reporting solution that uses Excel.

Lessons

Lab : Designing an Excel Reporting Solution

Module 9: Planning a SharePoint Server BI Solution

This module explains how to design a SharePoint BI solution.

Lessons

Lab : Implementing a SharePoint Server BI Solution
Lab : Implementing a PerformancePoint Services

Module 10: Monitoring and Optimizing a BI Solution

This module explains how to monitor and optimize a BI solution.

Lessons

Lab : Monitoring and Optimizing a BI Solution

Module 11: Operating a BI Solution

This module explains how to plan management and maintenance operations for a BI solution.

Lessons

Lab: Operating a BI Solution

Prerequisites

Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:

Revised April 2016

Do you need a class or course date not listed here? Take a look at our SQL Server complete Course Catalog

Or, call DynamicsEdge now (800) 453-5961 for us to prepare you a Customized Training Course

Last updated: 2019-03-22

Omaha, Nebraska SQL Server Training

Dynamics Edge locations in Omaha, Nebraska:

Dynamics Edge may need to obtain additional details about your SQL Server custom course that you need in Omaha, Nebraska . Please call Dynamics Edge at (800) 453-5961 or e-mail Dynamics Edge at sales@dynamicsedge.com and ask for a custom class at this location.

Please contact us for a list of our Omaha, Nebraska locations.

More SQL Server training classes

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular courses offered on this page.