This fast-paced 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.

Prerequisites

There are no prerequisites for this course.

Who Can Benefit

This course is intended for SQL professionals, Microsoft Analysis Services cube and report developers, and business intelligence professionals.

Class Outline

Module 1: Course Overview

• Lesson 1: Introduction
• Lesson 2: Course Materials
• Lesson 3: Facilities
• Lesson 4: Prerequisites
• Lesson 5: What We’ll Be Discussing

After completing this module, students will be able to:

• Successfully log into their virtual machine
• Have a full understanding of what the course intends to cover

Module 2: Introduction to Microsoft SQL Server Analysis Services

• Lesson 1: Common Analysis Services Solutions
• Lesson 2: Version Changes of SSAS from 2008-2014
• Lesson 3: Analysis Services Installation and Architecture: One Product, Two Models
• Lesson 4: Choosing the Right Model
• Lesson 5: Analysis of Services Tools

After completing this module, students will be able to:

• 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

Module 3: The Multidimensional Solution

• Lesson 1: Understanding the Multidimensional Model
• Lesson 2: Utilizing Data Sources and Data Source Views
• Lesson 3: Creating a Cube

After completing this module, students will be able to:

• Understand the multidimensional model
• Utilize data sources and data source views
• Create a cube

Module 4: Dissecting with Dimensions

• Lesson 1: Developing Dimensions
• Lesson 2: Utilizing Attributes
• Lesson 3: Relating with Relationships
• Lesson 4: Handling Hierarchies

After completing this module, students will be able to:

• Understand and utilize dimensions
• Understand and utilize attributes
• Understand and utilize relationships
• Understand and utilize hierarchies

Module 5: Managing Measures

• Lesson 1: Measures and Measure Groups
• Lesson 2: Calculated Members

After completing this module, students will be able to:

• Understand and utilize measures and measure groups
• Understand and utilize calculated members

Module 6: Configuring Cube Options

• Lesson 1: Understanding Perspectives
• Lesson 2: Utilizing Translations
• Lesson 3: Browsing Perspectives and Translations

After completing this module, students will be able to:

• Understand and utilize perspectives
• Understand and utilize translations
• Browse perspectives and translations

Module 7: Deploying

• Lesson 1: Examining Deployment Options
• Lesson 2: Processing Strategies
• Lesson 3: Exploring Security

After completing this module, students will be able to:

• Understand and utilize deployment options
• Understand and utilize processing strategies
• Understand and utilize security
• Deploy a multidimensional model

Module 8: The Tabular Solution

• Lesson 1: Understanding the Tabular Model
• Lesson 2: Creating a Tabular Project
• Lesson 3: Deploying
• Lesson 4: Browsing the Model
• Lesson 5: Querying the Solution and Understanding DAX
• Lesson 6: Maintaining and Optimizing

After completing this module, students will be able to:

• 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