Msbi

msbi online training in hyderabad

Course Syllabus

Msbi online training in hyderabad

INTRODUCTION SQL SERVER 2012.

1.SQL-Architecture.

2.GAM, SGAM, Pages, Extents.

3.Database engine

4.Multiple instances

5.Sql server2012 editions,

6.SQL Server 2012 databases and Objects,

7.Sql Server Physical Structure.

8.MSBI studio.

9.What is new for MSBIin SQL Server 2012?

MS-BI (SSIS, SSAS, SSRS)

SSIS Objectives

1. Plan data transfer and staging solutions for an ETL operation

2. Plan an SSIS Solution

3. Design and implement data flows

4. Incorporate logging, error handling and reliability into a package

5. Optimize an SSIS Solution

6. Deploy an SSIS Solution

CONTENTS: PLANNING FOR ETL

1. Identifying Data Sources and Destinations

2. Evaluating Source Data

3. Identifying Staging Requirements

PLANNING AN SSIS SOLUTION

1. Planning Packages

2. Planning Package Development

3. Designing Package Control Flow

DESIGNING DATA FLOW

1. Understanding Data Flow

2. Designing Data Flow Operations

3. Handling Data Changes Logging, Error Handling and Reliability

4. Logging ETL Operations

5. Handling Errors in SSIS

6. Implementing Reliable ETL Processes with SSIS

OPTIMIZING AN SSIS SOLUTION

1. Monitoring SSIS Performance