Training & Certification

Spring Training Course Overview

Introduction to Analysis Services

• Introduction
• Business Intelligence Queries
• Architecture Options
• Database Developments
• Development, Management and Client Tools
• Summary

Dimensional Model Development

• Introduction
• Dimension wizard
• Dimension designer
• Unknown member
• Attribute properties
• Date dimension
• User Hierarchies
• Parent child hierarchy
• Attribute relationship
• Translation
• Summary

Cube Development

• Data Source and Data Source Views
• Computed and Named Queries
• Building Entity Relationships
• Deciding Data Warehouse Schema
• Creating Dimensions and Builds
• Attributes and Member Names
• Choosing Dimension Templates
• Applying Time Based Dimensions
• Need for Hierarchies and Limitations
• Attribute Relations and Uses
• Building Levels and Hierarchies
• Need for Composite Attribute Keys

KPI Calculations and Partitioned Aggregations

• Identifying Cube Entries for FASMI Rules
• Measures and Additives (Full and Semi)
• Defining Measure Groups and Measures
• Cube Customizations and Options
• BI Enhancements and Granularity
• Building Fact Less Cube Dimensions
• Calculations and Conditional Colors
• MDX Scripting for Calculations
• Defining KPIs and Goals using MDX
• Perspectives using MDX Expressions
• SSAS Actions with MDX and XMLA
• Need for Cube Partitions and Query Binding
• Local and Remote Server Partitions
• Need for Storage Models – MOLAP  and ROLAP
• Generation of Aggregations on Partitions
• Storage Modes and Proactive Caching
• Hierarchies and Relations in Tabular Mode

Security

• Overview
• User Security
• Dimension Security
• Cell Security
• Administrator Security
• Service amount configuration