SQL Server Analysis Services ( SSAS) with MDX Online Real Time Training

[srijith.adapa]

[b]SQL School [/b] offers Real-time Quality Training and Job Support services on SQL Server 2005 & 2008 including R2. 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]SSAS Online training[/b] sessions. Duration is 25 hours with 100% [glow=red,2,300]complete [/glow][glow=red,2,300]PRACTICAL TRAINING[/glow]. NO PPTs nor Screenshots during LIVE sessions. Material is provided over email for every session.

[b]Please get an overview of the concepts we discuss: [/b]

[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
viii. Write Backs and Pivots

[b]Performance Counters[/b]

i.  SQL Server Profiler
ii.  Performance Counters
iii. Resource Audits and Optimizations

[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


New SSAS sessions from September  7th.  Time: 8 AM to 9:30 AM India Time.  This would be September 6th evening time for US attendees. Everyday sessions - weekly SIX days. 2.5 weeks program.

Course Fee is Rs 5000, payable in two installments.[/b]
For Free DEMO and more details, you can reach us:

[b]Sai Phanindra T[/b]

SQL School
Mob:+91-(0)-9666440801
US: (001) 214-628-5666
Office: 040 - 6457-7244
[email][email protected][/email]

[url=http://[url]http://sqlbitraining.com/ssas.html] [url]http://sqlbitraining.com/ssas.html[/url] [/url]