Course Duration in Hours
30
30
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
Any Graduate
enosis learning, Viman Nagar (Pune),Pune,IN