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

Webucator's instructors are knowledgeable and humorous at the same time. I learned so much, taking our sites to the next echelon."
Todd Copeman
WINONA STATE UNIVERSITY
My Webucator Course introduced me to new concepts and ways to design applications to make my days more efficient. I look forward to another course in the future.
Sonja Shaw
ABM Industries, Inc
This training was the best of both worlds. I could attend without being totally and completely detached from my work environment. Yet, I could focus on the instruction and content easily due to the excellence of the instructor and the online presentation. It's the finest remote training that I've ever taken. I'd recommend it to anyone interested in learning new technologies and timely topics.
Greg Scarfo
Aspect Software, Inc
Training is excellent and easy to follow.
Dacia Benoit
MillerCoors LLC

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

62,336

Students who have taken Instructor-led Training

11,816

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 29,186 reviews

Contact Us or call 1-877-932-8228