Meridian, Mississippi MOC 20467 SQL Server Training - Dynamics Edge

Meridian, Mississippi Microsoft 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.*

Check out the dates offered for Dynamics Edge Microsoft MOC 20467 distinguished SQL Server training course for the best results. We might be able to hold a custom class for you on a date of your choosing.

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 want a custom class or class date not listed here? Take a look at our SQL Server full list of Training Courses

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

Last updated: 2019-01-20

Meridian, Mississippi SQL Server Training

Dynamics Edge locations in Meridian, Mississippi:

Dynamics Edge may need to gather additional details about your SQL Server custom training that you need in Meridian, Mississippi . 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 Meridian, Mississippi 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.