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

The instructors make learning new topics interesting and fun. It was the most enjoyable training experience I have had thus far.
Sharrie Hailson
Velcro Group Corp
The class was great! I learned a lot of new tricks and new formula's that will shorten my time working on reports and making them more readable.
Rashika Ram
Salesforce
THANK YOU THANK YOU THANK YOU ! :)
Clyde Crawford
USPS
This was my first web-based training class and my experience was fantastic! I really learned a lot and would definitely participate in more courses in the future.
Coy Woolard
flanders filters

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

64,007

Students who have taken Instructor-led Training

11,930

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.30

Students rated our trainers 9.30 out of 10 based on 30,118 reviews

Contact Us or call 1-877-932-8228