Quick Microsoft SQL Server 2012-2014 Analysis Services

Session Detail:    Classroom 2 Day

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.

Session Outline

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

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Quick Microsoft SQL Server 2012-2014 Analysis Services

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now