Training & Exams

Designing Business Intelligence Solutions with Microsoft SQL Server 2012.

About This Course

Course Code
M20467

Course Type
Specialist

Vendor
Microsoft

Duration
5 Days

RRP
£1,935.00

Course Overview
Download

Special Notices

Please note: This course will be replaced by M20467C 'Designing Self-Service Business Intelligence and Big Data Solutions' effective 22nd September 2014.

Overview

This five-day instructor-led course teaches students how to design and implement a BI infrastructure. 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.

Note: The Beta version of this course (20467AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 SP1 CTP4, Microsoft SharePoint Server 2013 Preview, Microsoft Office 2013 Preview, and Microsoft Visio 2013 Preview are used in this course.

Audience Profile
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. Finally, they may apply those skills in a Windows Azure SQL Server database environment.

Objectives

Course Outline

Module 1: Planning a BI Solution
This modules discusses how to plan the components of a BI solution.

Lessons

Lab : Planning a BI Solution

Module 2: Planning a BI Infrastructure
This modules 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 explain how to design a data warehouse for a given set of user requirements.

Lessons

Lab : Designing a Data Warehouse Logical Schema

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

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 an 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 : Planning a SharePoint Server BI Solution

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: Planning BI Operations
This module explains how to plan management and maintenance operations for a BI solution.

Lessons

Lab : Planning BI Operations

Prerequisites

Before attending this course, students must have:

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

About This Course

Course Code
M20467

Course Type
Specialist

Vendor
Microsoft

Duration
5 Days

RRP
£1,935.00

Course Overview
Download