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.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

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

Instuctor made you feel at ease while teaching you very important information.
Debbie Brewer
LKLP CAC, Inc.
I absolutely loved the Webucator Instructor-Led course on Camtasia Studio 8! Everything was so well thought out and executed to perfection! I would highly recommend my instructor and I will definitely take a Webucator course in the future!
Marc Armstrong
AAXSYS Technology
A great combination of basics with the tricks we would never learn on our own!
Rob Sims
Merrill Lynch
I was expecting good interaction and real world examples, but I got far more than that. You could tell that the instructor loved what he was doing and as a result it showed in his teaching.
Bracey Fuenzalida
Dominion Endeavors

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

63,175

Students who have taken Instructor-led Training

11,876

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,679 reviews

Contact Us or call 1-877-932-8228