Enable Technology

SQL Server Analysis Services 

Microsoft SQL Server 2012/2014 Analysis Services SSAS

Course Overview

This intensive instructor-led course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.

Duration: 2 day course

Course Content

Introduction to Microsoft SQL Server Analysis Services
Common Analysis Services Solutions
Version Changes of SSAS from 2008-2014
Analysis Services Installation and Architecture: One Product, Two Models
Choosing the Right Model
Analysis Services Tools.

The Multidimensional Solution
Understanding the Multidimensional Model
Utilizing Data Sources and Data Source Views
Creating a Cube

Dissecting with Dimensions
Developing Dimensions
Utilizing Attributes
Relating with Relationships
Handling Hierarchies.

Managing Measures
Measures and Measure Groups
Calculated Members.

Configuring Cube Options
Understanding Perspectives
Utilizing Translations
Browsing Perspectives and Translations

Examining Deployment Options
Processing Strategies
Exploring Security
Understand and utilize security.
Deploy a multidimensional model.

The Tabular Solution
Understanding the Tabular Model
Creating a Tabular Project
Browsing the Model
Querying the Solution and Understanding DAX
Maintaining and Optimizing

Email us about this courses

Telephone on 01952 305730