SSAS is one of the excellent tool for Planning, Design, Development & Management of SQL Server Data Warehouses – OLAP Databases used for Business level Data Analysis, Data Mining and Business level Forecasts. In our LIVE Training sessions, we discuss MDX, DMX and XMLA languages. Each session will be completely practical and Realtime. Daily tasks and a Case Study will also be provided during the course.

PLEASE FIND THE COURSE CONTENTS FOR SSAS MODULE:

SSAS DEVELOPMENT

ADVANCED CUBE DESIGN

SSAS MANAGEMENT AND SECURITY

INTRODUCTION TO SSAS

• Datawarehouse Concepts
• Analysis Services Architecture
• Introduction to SSAS 2008 R2 & 2012

DATA WAREHOUSE ARCHITECTURE

• Need for Cubes and Measures
• Identifying Facts and Dimensions
• Identifying Measures and Aggregates
• Identifying Attributes and Hierarchies
• Datawarehouse Design Principles
• Staging operations and usages

BASIC SSAS ENTITIES

• Data Source and Data Source Views
• Manipulating structures in DSV
• Computed and Named Queries
• Building Entity Relationships
• Deciding Datawarehouse Schema

DIMENSION WIZARD

• Creating Dimensions and Builds
• Attributes and Member Names
• Choosing Dimension Templates
• Applying Time Dimensions
• Need for Hierarchies and Limitations
• Attribute Relations and Uses
• Building Levels and Hierarchies
• Need for Composite Attribute Keys
• Creating empty Dimensions

CUBE WIZARD

• Planning for Cube Design
• Identifying Cube Entries
• Measures and Additives
• Creating Measure Groups
• Cube Customizations and Options
• Empty Cubes and Enhancements

CUBE OPERATIONS

• Dimension Usage and Flexible Cubes
• Building Fact Dimensions
• Calculations and Conditional Colors
• MDX Scripting for Calculations
• Calculation Sets and Options
• Defining KPIs and Goals
• Perspectives and Uses
• SSAS Actions and Coding

SSAS PARTITIONS AND AGGREGATIONS

• Need for Cube Partitions
• Local and Remote Partitions
• Need for Storage Models
• Generation of Aggregations

MDX SPECIFICS AND FUNCTIONS

• Need of MDX Language
• Complex MDX Queries
• MDX Functions & Limitations
• PARALLELPERIOD  specifics
• Conditional MDX JOINS
• Cube and Dimension Writebacks
• MDX Transactions & Limitations

DATA MINING AND FORECAST

• Need for Data Mining Structures
• Data Mining Algorithms and Rules
• DMX Queries and Forecast Reports
• Data Mining Scope and Ranking
• Prediction Functions and Analysis

SSAS DEPLOYMENT

• Deployment Pre-requisites
• Deployment Options and Tools
• Creating OLAP (SSAS) Databases
• Processing Options and stages
• Managing Deployment Process

SSAS LOGGING

• Benefits of SSAS Logging
• Choosing correct log providers
• Managing SSAS Log Providers

OLAP DATABASE MANAGEMENT

• OLAP Database Backups
• Compressions and Encryptions
• Restore Options and Partitions
• Scripting Backups and XMLA
• Scheduling Backupsand Jobs
• DB Synchronizations and XMLA
• Managing Partitions & Aggregations
• DB Reports and Dashboards
• Monitoring Execution Plans

USAGE BASED OPTIMIZATIONS (UBO)

• Need for Optimizations and Audits
• Designing Aggregations using UBO
• OLAP Restore Options and XMLA

MANAGING SECURITY

• SSAS Security Roles and Scope
• Object Level Access and MDX
• Drill-Through Security and MDX
• Item Level Security and MDX
• Dynamic Security Implementation
• Windows Level Authentications
• Security Audits and Query Logs

SCHEDULES AND UPGRADES

• Using SSIS for DW Management
• Using SSIS for XMLA Operations
• MDX and DMX Operaitons in SSIS
• Scheduling SSAS operations
• Upgrading OLAP Databases (DW)
• Comparing SSAS 2008 R2 & 2012
• New SSAS Features in DENALI