Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Training Course

This course is designed to measure the knowledge and skills of participants in making suitable career choices in developing Microsoft SQL Server 2012 Databases. It is intended for Business Intelligence Architects who focus on the complete design of the BI structure, including how it associates with other data systems in use.

Subscribe to this course +

USD 50

Subscribe Now

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

The Microsoft 70-467 course prepares you to pass the Microsoft 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 exam which validates your ability to design Business Intelligence Solutions with Microsoft SQL Server 2012. This course is suitable for IT professionals and anyone aspiring for a Microsoft certification.

1-year access to audio-video lectures
GreyCampus course completion certificate

Course Outline

Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Course Introduction

Course Modules
Module 1

Introduction to Data Warehousing

On-Line Transaction Processing (OLTP) vs. OLAP

Data Warehousing

Data Warehouse Architecture

Creating a Data Warehouse Part2

Creating a Data Warehouse Part1

Presenting On-Line Analytical Processing (OLAP) Data

OLTP vs. OLAP Demonstration

Exam Scenarios

Module Review

467_01_02_01h
Module 2

Designing a Data Warehouse

Data Modeling

Data Warehouse Schemas

Time Dimensions

Data Modeling Considerations

Implementing a Data Model

Logical Model

Physical Model

Working with Dimensions and Fact Tables

Exam Scenarios

Module Review
Module 3

Extraction, Transformation, and Load (ETL) with SSIS

Introduction to SQL Server Integration Services (SSIS)

Upgrading SSIS Packages

SSIS Tools

Introduction to Data Flow Tasks

Data Sources

Transformations

Destinations

Control Flow

Variables

Expressions

Precedence

Containers

Control Flow Containers Part1

Control Flow Containers Part2

Transactions

Package Execution with Checkpoints

Working with SSIS Packages Part1

Working with SSIS Packages Part3

Working with SSIS Packages Part2

Exam Scenarios

Module Review

467_03_16_01h

Module 4

Deploying and Securing Packages

Deploying Options

Deploying Packages

Deploying Projects

Securing Packages

Deploying and Securing Packages

Exam Scenarios

Module Review

467_04_07_01h
Module 5

SQL Server Reporting Services (SSRS)

Introduction to Reporting Services Part2

Introduction to Reporting Services Part1

SSRS Reports Creation and Delivery

SSRS Reports

Grouping

Expressions

Drilldown

Parameters

Drillthrough

Visual Components

Creating Reports Within Reporting Services Part1

Creating Reports Within Reporting Services Part3

Creating Reports Within Reporting Services Part2

Creating Reports Within Reporting Services Part4

Exam Scenarios

Module Review
Module 6

SSRS Reports

Deploying Reports

Report Security

Report Execution

Report Caching

Report Snapshot

Subscriptions

Data Alerts

Deploying Reports and Report Security Part1

Deploying Reports and Report Security Part2

Exam Scenarios

Module Review

467_06_04_01h
Module 7

Multidimensional Cubes

Introduction to Cubes Part1

Introduction to Cubes Part2

Components of a Multidimensional Cubes

Measures

Measure Format and Aggregation Functions

Measure Groups Part1

Measure Groups Part2

Aggregations

Dimensions

Dimension Storage

Dimensions Hierarchies

Grouping and Sorting

Actions

Perspectives

Key Performance Indicators

Translations

SSAS Security

Cell Permissions

Dimension Permissions

Creating and Configuring a Cube Part1

Creating and Configuring a Cube Part2

Creating and Configuring a Cube Part3

Creating and Configuring a Cube Part4

Exam Scenarios

Module Review

467_07_09_01h
Module 8

Tabular Data Models

Introduction to Tabular Data Models

PowerPivot

Working with PowerPivot

Linked and Non-Linked Tables

PowerPivot Features

Server Based Tabular Data Models Part1

Server Based Tabular Data Models Part2

Creating a Tabular Data Model Using PowerPivot Part3

Tabular Models with SSDT

Workspace Database

Tabular Data Model

Tabular Data Model Security

Tabular Data Mode

Creating a Tabular Data Model Using PowerPivot Part4

Creating a Tabular Data Model Using PowerPivot Part1

Creating a Tabular Data Model Using PowerPivot Part2

Creating a Tabular Data Model Using PowerPivot Part4

Exam Scenarios

Module Review

467_08_13_02c
Module 9

MDX/DAX

Introduction to Multidimensional Expressions (MDX)

Why Use MDX?

MDX Syntax

Sets

Where is MDX Used?

Introduction to Data Analysis eXpressions (DAX) Part1

Introduction to Data Analysis eXpressions (DAX) Part2

Working with DAX

DAX Functions

DAX Queries

Calculated Columns

DAX Measures

Multiple Relationships

Exam Scenarios

Module Review
Module 10

Data Mining

Introduction to Data Mining

Data Mining Algorithms

Data Mining Components

Validating and Presenting Data Mining Models

Creating a Data Mining Model Part2

Creating a Data Mining Model Part1

Exam Scenarios

Module Review

Course Review.

467_10_04_01h