Data warehousing concepts
Role of MS BI in Data ware house

Introduction to Sql Server  Integration Services

• Overview of Integration Services Solutions
• Installing Integration Services tool

Developing integration services solutions

• Creating Integration services solution
• Using variables
• Building and running a solution

 

Implementing Control Flow

• Control Flow Tasks
• Control Flow Precedence Constraints
• Control Flow Containers

 

Implementing Data Flow

• Data Flow Sources And Destinations
• Data Flow Transformations
• Data Flow Pipe Line

Implementing Logging

• Overview of Integration services logging
• Implementing Logging

                    
Debugging and Error Handling

• Debugging the package
• Implementing Error Handling

 

Implementing Checkpoints and Transactions

• Implementing Check points
• Implementing Transactions

 

 

SSIS Administration

• Deploying Packages
• Managing Packages 

 

Introduction to Microsoft Sql Server Reporting Services

• Overview of SSRS
• Installing Reporting Services Tool
• Reporting Life Cycle

 

Authoring Reports

• Data Sources
• Data Sets
• Reports
• Report Wizard
• Report Designer
• Report Items
• Report Layout Section
• SSRS Expressions
• Working with Data Regions (Matrix, Chart, List )

 

Advanced Authoring

• Parameterized reports
• Drill down Reports
• Sub Reports
• Filters In Reports
• Actions In reports
• .Net scripting in SSRS

 

SSRS Administration

• Installation And Configuration
• Deployment And Security
• Subscriptions And Rendering
• Caching And Snapshots

 

Report Development Using Report Model Project

• Report Model Project
• Model Designer
• Report Builder

 

Introduction to Sql Server Analysis Services

• Dimensions
• Facts
• Data Sources
• Data Source Views

 

Developing Cubes

• Cube Designer
• Partitions And Aggregations
• Dimension Usage
• Calculations and Kpi’s
• Perspectives, Actions
• Translations
• Write-back features

 

  MDX  Language

• Axes, Slice
• Tuple and Set
• MDX Queries
• MDX Expressions
• MDX Scripts

 

SSAS Administration

• Installation
• Configuration
• Deployment
• Processing
• Security
• Backup And Restore