Quick Microsoft SQL Server 2012-2014 Analysis Services

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

Goals
  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.
Outline
  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.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

A 'must have" for managers and leaders in any field.
Robert Pagan
BMT Scientific Marine Inc.
I gained a lot of practical skills in a short amount of time. This course provided plenty of opportunity for me to apply what was being taught so that by the time it was over I was confident and ready to start using Basecamp.
Ashley Rosales
Dairy Council of California
Great class on a necessary but little understood subject. I received input from a knowledgeable, personable instructor that tailored the course to my situational needs.
Dennis Cash
Tri County Technology Center
The course was very well taught by the instructor. The materials provided were very detailed and self explanatory with great examples. I really enjoyed being in the class and learned a lot.
Catherine Botchway
Navy Federal Credit Union

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

61,868

Students who have taken Instructor-led Training

11,795

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 28,793 reviews

Contact Us or call 1-877-932-8228