SSIS, SSAS and SSRS [MSBI] Training + Realtime Project

[sqlschool]

[b]SQL School [/b]offers Real-time Quality Training on SQL Server 2005 & 2008. We trust in providing quality and interactive trainings that is making us one of the pioneers in the software training market with trusted relationship with our trainees. We are launching new [b]MSBI Online training[/b] sessions. [b]D[/b][b]uration is 80 hours with 100% [glow=red,2,300]complete [/glow][glow=red,2,300]PRACTICAL TRAINING[/glow][/b]. NO PPTs nor Screenshots.


Please get an overview of the concepts we discuss:



[u][b]SSIS Course Details[/b][/u]


1.  [b] Introduction to SSIS[/b]

o  What is SSIS?

o  Why we need to use SSIS?

o  Understanding basics of  SSIS

o  Understanding BIDS


2.  [b] Introduction to Control Flow[/b]

o  Control Flow in SSIS

o  Control Flow Tasks

o  Workflow Tasks

o  Precedence Constraints

o  Data Processing Tasks

o  Other SQL Operations Tasks


3.  [b] Introduction to Data Flows[/b]

o  Data Flow in SIS

o  Data Flow Pipeline

o  Data Flow Sources

o  Data Flow Destinations

o  Data Viewers

o  Data Flow Transformations


4.  [b]Variables and Configurations[/b]

o  Understanding Variables

o  Using Variables in Control Flow

o  Using Variables in Data Flow

o  Understanding Property Expressions

o  Understanding Configurations

o  User Configurations

o  Using Variables and Configurations between Packages


5.  [b]Advanced Control Flow[/b]

o  Advanced Control Flow Overview

o  Using Containers

o  Transactions Support in SSIS

o  Additional Control Flow Tasks


6.  [b]Package Deployment[/b]

o  Overview of Deploying Packages

o  Deployment Challenges

o  Create a Package Deployment Utility

o  The Package Installation Wizard

o  Deploy a Package to the File System

o  Deploy a Package to SQL Server

o  Redeploying Updated Packages



7.  [b] Package Management[/b]

o  Overview of Package Management

o  Managing packages with DTUtil

o  Managing packages with SQL Server Management Studio

o  Executing Packages

o  Scheduling packages with SQL Server Agent

o  SSIS Security



8.  [b]Introduction to Scripting and Custom Components[/b]

o  Extending SSIS Capabilities Through Code

o  The SSIS scripting

o  Scripting in Control Flows

o  Scripting in Data Flows

o  Custom SSIS Components



9.  [b] Beyond ETL: Other Scenarios for SSIS[/b]

o  Using SSIS Beyond ETL

o  Migrating SQL Servers with SSIS

o  SQL Server Maintenance Plans

o  Working with Analysis Services

o  Folder and File Management

o  Working with Windows Event Log






[u][b]SSAS Course Details[/b][/u]


Introduction to Data Warehousing Concepts

i.  What is Data Warehousing?

ii.  Need for Data warehousing

iii.  OLTP Databases Vs DW

iv.  Multi-dimensionality

v.  Star Schema

[b]

Introduction to Analysis Services[/b]

i.  Need for SSAS

ii.  Fundamentals of Analysis Services 2005 and 2008

iii.  Architecture of SSAS

iv.  FASMI Rules

v.  Configuration of SSAS

vi.  SSAS and SQL Server Browser Service

vii.  Integration with SQL Server Components

viii.  Analysis Services Components Overview


[b]Designing Analysis Services Projects[/b]

i.  Data Preparation

ii.  Starting an Analysis Services Project

iii.  Hierarchies and Attributes

iv.  Dimension Design

v.  Cube Design

vi.  Basic Browsing


[b]Advanced SSAS Design[/b]

i.  MDX Queries

ii.  Creation of Sub Cubes

iii.  Partitions

iv.  Aggregations

v.  Analysis Actions

vi.  Slowly Changing Dimensions (SCD)

vii.  Perspectives

viii.  Permissions and Roles

ix.  Security over Cubes and Dimensions


[b]MDX and Cube Analysis[/b]

Basic MDX

•  Multi-dimensional expressions

•  MDX queries

•  Creating calculations

Advanced MDX

•  Defining named sets

•  Basic scripting

•  Defining actions


[b]Key Performance Indicators[/b]

i.  What are KPIs

ii.  Use and Variants of KPIs

iii.  Browsing KPIs using UI and MDX

iv.  KPIs and XMLA


[b]Managing Analysis Services[/b]

i.  Analysis Services Configuration

ii.  Deployment Options

iii.  Processing Types

iv.  Browsing Cubes

v.  Security Management

vi.  Usage Based Optimizations (UBO)

vii.  Importing SSAS Project


[b]Performance Counters[/b]

i.  SQL Server Profiler

ii.  Performance Counters


[b]Comparison with Analysis Services of SQL Server 2000

Migrating SSAS 2005 Projects to 2008[/b]

i.  New features in SQL Server 2008

ii.  Performance benefits over MSAS 2005

iii.  Dimension and Cube Extensions

iv.  Mining Extensions in SSAS 2008

v.  Attribute Relationships and Properties

vi.  Type I and Type II SCDs


Generation of Reports from SSAS Cubes

Best Practices and Conclusion



[u][b]SSRS Course Details[/b][/u]


1.  [b]Introduction to Reporting Services 2005 and 2008[/b]


      Why Reporting Services?

      Specialty of SSRS 2005 and SSRS 2008

      Reporting Services Fundamentals

      Reporting Services Architecture

      Reporting Services Components Overview

      Reporting Life Cycle


2.  [b]Authoring Reports[/b]


      Developing Basic Reports

      Enterprise Reports

      Ad Hoc Reports

      Report designing tools

      Structuring and Formatting

      Grouping and Sorting

      Expressions and Reports

      Aggregations usage in SSRS

      Static and Dynamic Report Parameters

      Matrix Reports and Charts

      Organizing data in Reports

      Char Based Reports

      Sub Reports and Applications


3.  [b]Dynamic Reports[/b]


      Conditional Formatting

      Conditional Representation

      Visibility and Toggles

      Customizing Report Definitions


4.  [b]Managing Reporting Services[/b]


      Report Server Configuration

      Publishing Reports

      Organizing and Managing Content

      Managing Report Execution

      Virtual Directory Configuration Management

      Security Management

      Performance Management


5.  [b]Delivery of Reports[/b]


      Accessing Reports

      Rendering Reports

      Managing Subscriptions

      Creating Reports with Report Builder

      Report Models

      Report Builder over IIS Manager

      SSRS and Excel Sources


6.  [b]Automatic Delivery of Reports[/b]


      Windows File Share

      Email Delivery


7.  [b]SQL Server 2008 Reporting Services

[/b]

      New Features

      Differences w.r.t SSRS 2005

      Deployment Changes

      IIS Administration and Share point Compatibility

      Performance Considerations

      Scalability and Optimization Tips


8.  [/b]Security Parameters and Roles[/b]


      Server Level Security

      Report Level Security

      Data Source level Security


9.  [b]Working with Analysis Services and Reporting Services[/b]


      Use of OLAP Databases in Reports

      MDX Implementation in SSRS

      WriteBacks in SSRS

      Security Mechanism over OLAP


10.  [b] Best Practices and  Real time Project on 2 TB database[/b]

[b]

New MSBI session from JAN 27th.  Time: 9:00 PM India Time. [/b]Everyday sessions - weekly SIX days. 45 working days.


Course Fee is Rs 10000 [ USD 230], payable in two installments.[/b]

SQL DBA Trainings and Projects are also provided.

For Free DEMOs and more details, you can reach us anytime:


[b]Sai Phanindra T[/b]

SQL School

Mob:+91-(0)-9666440801

US: (001) 214-628-5666


[email][email protected][/email]

[email][email protected][/email]


[url=http://sqldbatraining.com]http://sqldbatraining.com[/url]
[url=http://sqlbitraining.com]http://sqlbitraining.com[/url]