Sql Server Analysis Services is a BI Tool.

Topics Covered

Introduction to SSAS o Introduction to SSAS o Understand the Cube Structure o Deploy and View a Sample Cube o View a Cube by using Excel o View a Cube by using SQL Reporting Services OLAP Modeling o Understand Basic OLAP Modeling (star schema) o Understand Dimensional Modeling (stars and snowflakes) o Understand Measure (fact) and Cube Modeling o Model with SQL Server Business Intelligence Development Studio (BIDS) Using SSAS in BIDS o Understand the Development Environment o Create Data Sources o Create Data Source Views o Create Cubes by using the Cube Wizard Intermediate SSAS o Learn how to Create Key Performance Indicators (KPIs) o Discover how to Create Perspectives o See how to Create Translations for Cubes and Dimensions o Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting Advanced SSAS o Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS o Explore Advanced Dimension Types o Learn how to use the Business Intelligence Wizard o Understand Writeback in Dimensions o Review Semi-Additive Measures in OLAP Cubes Cube Storage and Aggregation o View Aggregation Designs o Customize Aggregation Designs o Implement Proactive Caching o Use Relational and SSAS Partitions o Customize Cube and Dimension Processing Introduction to MDX Queries o Understand Basic MDX Syntax o Use the MDX Query Editor in SSMS o Understand Common MDX Functions and Tasks o Review MDX Functions New to SSAS 2008 MDX Expressions o Understand the Calculation Subtab o Learn how to add Calculated Members o Explore how to add MDX Script Commands o Discover how to add .NET Assemblies Introduction to Data Mining o Understand Data Mining Concepts o Review the Algorithms that SSAS Includes o Consider Data Mining Clients o Understand Mining Structure Processing

Who should attend

Anyone interested in making a career in Sql Server , BI.

Pre-requisites

Sql Server

What you need to bring

Nothing"

Key Takeaways

Notes, Demos, Tutorials.