NEW SSAS ONLINE TRAINING @ SQL School

[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 MSBI Online training sessions next week. Time : 9 AM India Time. Duration is 80 hours with 100% complete PRACTICAL TRAINING. NO PPTs nor Screenshots.

SSAS Course Details[/b]

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
[b]Advanced MDX[/b]
•  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[/b]
[b]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

[b]Generation of Reports from SSAS Cubes
Best Practices and Conclusion[/b]

SQL DBA Trainings and Projects are also provided.

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

SAI PHANINDRA T
INDIA: 09666440801
US: 214-628-5666
[email protected]
[url=http://www.sqldbatraining.com]www.sqldbatraining.com[/url]