Microsoft SQL Server 2012/2014 Analysis Services SSAS
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
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
Relating with Relationships
Measures and Measure Groups
Configuring Cube Options
Browsing Perspectives and Translations
Examining Deployment Options
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