Course Length: 2 Days
Delivered: Virtually
OVERVIEW:
This course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution.
TARGET AUDIENCE:
This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals.
COURSE OBJECTIVES:
- Understand common Analysis Services solutions.
- Understand version changes of SSAS from 2008-2014.
- Understand Analysis Services installation and architecture.
- Understand how to choose the right model.
- Understand the Analysis Services tools available.
- Understand the multidimensional model.
- Utilize data sources and data source views.
- Create a cube.
- Understand and utilize dimensions.
- Understand and utilize attributes.
- Understand and utilize relationships.
- Understand and utilize hierarchies.
- Understand and utilize measures and measure groups.
- Understand and utilize calculated members.
- Understand and utilize perspectives.
- Understand and utilize translations.
- Browse perspectives and translations.
- Understand and utilize deployment options.
- Understand and utilize processing strategies.
- Understand and utilize security.
- Deploy a multidimensional model.
- Understand the tabular model.
- Create a tabular project.
- Analyze the data using Microsoft Excel.
- Create and configure calculated measures and calculated fields.
- Backup and Restore.
COURSE CONTENT:
Course Overview
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
- Lab 1: Course Overview
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
- Lab 1: Introduction to Microsoft SQL Server Analysis Services
The Multidimensional Solution
- Understanding the Multidimensional Model
- Utilizing Data Sources and Data Source Views
- Creating a Cube
- Lab 1: The Multidimensional Solution
Dissecting with Dimensions
- Developing Dimensions
- Utilizing Attributes
- Relating with Relationships
- Handling Hierarchies
- Lab 1: Dissecting with Dimensions
Managing Measures
- Measures and Measure Groups
- Calculated Members
- Lab 1: Managing Measures
Configuring Cube Options
- Understanding Perspectives
- Utilizing Translations
- Browsing Perspectives and Translations
- Lab 1: Configuring Cube Options
