Courses Contact : 9840496320 / 9940516384
SSAS - TRAINING IN CHENNAI
SQL Server Analysis Services [SSAS]
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
Greens Technologys,
No.15 First Street,Padmanabha nagar,
Adyar,
Chennai-20.
Phone(M): +91 98404 96320
Phone(L): 044 43511623
eMail: contact@greenstech.in
No.15 First Street,Padmanabha nagar,
Adyar,
Chennai-20.
Phone(M): +91 98404 96320
Phone(L): 044 43511623
eMail: contact@greenstech.in