Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Admission

The primary audience for this exam is the BI Architect. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use. Primary responsibilities may include:

•BI Solution architecture and design

•Provisioning of software and hardware

•Data warehouse and data mart design

•Online Analytical Processing (OLAP) cube design

•Integration with Microsoft SharePoint or line-of-business applications

•Apply those skills in a Windows Azure SQL Database environment

Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Exam #

Duration

Language

Level

Type

Classroom

Code

Fees

70-467

English

Professional

Course

Classroom

Cs235

0 LE

Description :

Objectives :

Plan Business Intelligence (BI) Infrastructure
Design BI Infrastructure
Design a Reporting Solution
Design BI Data Models
Design an ETL Solution

Topics :

Plan Business Intelligence (BI) Infrastructure

Plan for performance.
Plan for scalability.
Plan and manage upgrades.
Maintain server health.

Design BI Infrastructure

Design a security strategy.
Design a SQL partitioning strategy.
Design a backup strategy.
Design a logging and auditing strategy.

Design a Reporting Solution

Design a Reporting Services dataset.
Manage Microsoft Excel Services/Reporting for SharePoint.
Design a data acquisition strategy.
Plan and manage reporting services configuration.
Design BI reporting solution architecture.

Design BI Data Models

Design the data warehouse.
Design a schema.
Design cube architecture.
Design fact tables.
Design BI semantic models.
Design and create MDX calculations.

Design an ETL Solution

Design SSIS package execution.
Plan to deploy SSIS solutions.
Design package configurations for SSIS packages.

Recommended Knowledge :

Course 10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012

Recommended Course(s) :

Implementing Data Models and Reports with Microsoft SQL Server 2012

Training Materials :

Microsoft Official Courseware (MOC)

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012: counts as credit toward the following certification(s):

•Microsoft Certified Solutions Expert (MCSE): Business Intelligence

Category :
DataBase

The Instructor:

MISSION

learning process

Warm welcome

Quality assurance