Quick Microsoft SQL Server 2012-2014 Analysis Services

Customized Onsite Training

  • Customized Content
  • For Groups of 5+
  • Online or On-location
  • Expert Instructors

Live Online Training

or 2 vouchers
  • Live Online Training
  • Expert Instructors
  • Guaranteed to Run
  • 100% Free Re-take Option
  • 1-minute Video

This fast-paced Quick Microsoft SQL Server 2012-2014 Analysis Services training class 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.

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

  1. Understand common Analysis Services solutions.
  2. Understand version changes of SSAS from 2008-2014.
  3. Understand Analysis Services installation and architecture.
  4. Understand how to choose the right model.
  5. Understand the Analysis Services tools available.
  6. Understand the multidimensional model.
  7. Learn to utilize data sources and data source views.
  8. Learn to create a cube.
  9. Understand and utilize dimensions.
  10. Understand and utilize attributes.
  11. Understand and utilize relationships.
  12. Understand and utilize hierarchies.
  13. Understand and utilize measures and measure groups.
  14. Understand and utilize calculated members.
  15. Understand and utilize perspectives.
  16. Understand and utilize translations.
  17. Learn to browse perspectives and translations.
  18. Understand and utilize deployment options.
  19. Understand and utilize processing strategies.
  20. Understand and utilize security.
  21. Learn to deploy a multidimensional model.
  22. Understand the tabular model.
  23. Learn to create a tabular project.
  24. Learn to analyze the data using Microsoft Excel.
  25. Learn to create and configure calculated measures and calculated fields.
  26. Learn to backup and restore.
  1. Course Overview
    1. Introduction
    2. Course Materials
    3. Facilities
    4. Prerequisites
    5. What We'll Be Discussing
    6. Lab 1: Course Overview
    7. None
  2. Introduction to Microsoft SQL Server Analysis Services
    1. Common Analysis Services Solutions
    2. Version Changes of SSAS from 2008-2014
    3. Analysis Services Installation and Architecture: One Product, Two Models
    4. Choosing the Right Model
    5. Analysis Services Tools
    6. Lab 1: Introduction to Microsoft SQL Server Analysis Services
    7. Analysis Services Tools
  3. The Multidimensional Solution
    1. Understanding the Multidimensional Model
    2. Utilizing Data Sources and Data Source Views
    3. Creating a Cube
    4. Lab 1: The Multidimensional Solution
    5. Creating a Cube
  4. Dissecting with Dimensions
    1. Developing Dimensions
    2. Utilizing Attributes
    3. Relating with Relationships
    4. Handling Hierarchies
    5. Lab 1: Dissecting with Dimensions
    6. Developing Dimensions
    7. Relating with Relationships
    8. Handling Hierarchies
  5. Managing Measures
    1. Measures and Measure Groups
    2. Calculated Members
    3. Lab 1: Managing Measures
    4. Measures and Measure Groups
    5. Calculated Members
  6. Configuring Cube Options
    1. Understanding Perspectives
    2. Utilizing Translations
    3. Browsing Perspectives and Translations
    4. Lab 1: Configuring Cube Options
    5. Browsing Perspectives and Translations
  7. Deploying
    1. Examining Deployment Options
    2. Processing Strategies
    3. Exploring Security
    4. Lab 1: Deploying
    5. Deploying the Multidimensional Model
  8. The Tabular Solution
    1. Understanding the Tabular Model
    2. Creating a Tabular Project
    3. Deploying
    4. Browsing the Model
    5. Querying the Solution and Understanding DAX
    6. Maintaining and Optimizing
    7. Lab 1: The Tabular Solution
    8. Creating a Tabular Project
    9. Analyze in Excel
    10. Calculated Measures and Calculated Fields
    11. Backup and Restore
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • None.
Preparing for Class

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing


Students who have taken Live Online Training


Organizations who trust Webucator for their training needs


Satisfaction guarantee and retake option


Students rated our trainers 9.42 out of 10 based on 5,207 reviews

Contact Us or call 1-877-932-8228