Learn: in:
» back to Search Results

Course rating of 0 Vendor rating of 4


The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

  • Course Start Date: Nov. 20
  • Location: Toronto (Map)
  • Time: 9:00 am - 5:00 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 3 days 09:00 AM - 05:00 PM
  • Delivery Method(s):Instructor Assisted (Mentored)
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Seats Available: YES
  • Category:Microsoft SQL Training

 
Course Outline
The primary audience for this course is individuals who design and maintain business intelligence solutions for their organization. These individuals work in environments where databases play a key role in their primary job and may perform database administration and maintenance as part of their primary job responsibilities.The secondary audience for this course is individuals who develop applications that deliver content from SQL Server Analysis Services to the organization.


Topics:

Module 1: Introduction to Microsoft SQL Server Analysis Services

This module introduces common analysis scenarios and describes how Analysis Services provides a powerful platform for multidimensional OLAP solutions and data mining solutions. The module then describes the main considerations for installing Analysis Services.

Lessons

  • Lesson 1: Overview of Data Analysis Solutions
  • Lesson 2: Overview of SQL Server Analysis Services
  • Lesson 3: Installing SQL Server Analysis Services

Lab: Using SQL Server Analysis Services

  • Exercise 1: (Level 200) Installing SQL Server Analysis Services
  • Exercise 2: (Level 200) Verifying Installation

After completing this module, students will be able to:

  • Describe data analysis solutions.
  • Describe the key features of SQL Server Analysis Services.
  • Install SQL Server Analysis Services.

Module 2: Creating Multidimensional Analysis Solutions

This module introduces the development tools you can use to create an Analysis Services multidimensional analysis solution, and describes how to create data sources, data source views, and cubes.

Lessons

  • Lesson 1: Developing Analysis Services Solutions
  • Lesson 2: Creating Data Sources and Data Source Views
  • Lesson 3: Creating a Cube

Lab: Creating Multidimensional Analysis Solutions

  • Exercise 1: (Level 200) Creating a Data Source
  • Exercise 2: (Level 200) Creating and Modifying a Data Source View
  • Exercise 3: (Level 200) Creating and Modifying a Cube

After completing this module, students will be able to:

  • Develop Analysis Services solutions.
  • Create a data source and a data source view.
  • Create a cube.

Module 3: Working with Cubes and Dimensions

This module describes how to edit dimensions and to configure dimensions, attributes, and hierarchies.

Lessons

  • Lesson 1: Configuring Dimensions
  • Lesson 2: Defining Attribute Hierarchies
  • Lesson 3: Sorting and Grouping Attributes

Lab: Working with Cubes and Dimensions

  • Exercise 1: (Level 200) Configuring Dimensions
  • Exercise 2: (Level 200) Defining Relationships and Hierarchies
  • Exercise 3: (Level 200) Sorting and Grouping Dimension Attributes

After completing this module, students will be able to:

  • Configure dimensions.
  • Define hierarchies.
  • Sort and group attributes.

Module 4: Working with Measures and Measure Groups

This module explains how to edit and configure measures and measure groups.

Lessons

  • Lesson 1: Working With Measures
  • Lesson 2: Working with Measure Groups

Lab: Working with Measures and Measure Groups

  • Exercise 1: (Level 200) Configuring Measures
  • Exercise 2: (Level 200) Defining Dimension Usage and Relationships
  • Exercise 3: (Level 200) Configuring Measure Group Storage

After completing this module, students will be able to:

  • Work with measures.
  • Work with measure groups.

Module 5: Querying Multidimensional Analysis Solutions

This module introduces multidimensional expressions (MDX) and describes how to implement calculated members and named sets in an Analysis Services cube.

Lessons

  • Lesson 1: MDX Fundamentals
  • Lesson 2: Adding Calculations to a Cube

Lab: Querying Multidimensional Analysis Solutions

  • Exercise 1: (Level 200) Querying a Cube by Using MDX
  • Exercise 2: (Level 200) Creating a Calculated Member
  • Exercise 3: (Level 200) Defining a Named Set

After completing this module, students will be able to:

  • Describe Multidimensional Expression (MDX) fundamentals.
  • Add calculations to a cube.

Module 6: Customizing Cube Functionality

This module explains how to customize a cube by implementing key performance indicators (KPIs), actions, perspectives, and translations.

Lessons

  • Lesson 1: Implementing Key Performance Indicators
  • Lesson 2: Implementing Actions
  • Lesson 3: Implementing Perspectives
  • Lesson 4: Implementing Translations

Lab: Customizing Cube Functionality

  • Exercise 1: (Level 200) Implementing a KPI
  • Exercise 2: (Level 200) Implementing an Action
  • Exercise 3: (Level 200) Implementing a Perspective
  • Exercise 4: (Level 200) Implementing a Translation

After completing this module, students will be able to:

  • Implement Key Performance Indicators (KPIs).
  • Implement actions.
  • Implement perspectives.
  • Implement translations.

Module 7: Deploying and Securing an Analysis Services Database

This module describes how to deploy an Analysis Services database to a production server, and how to implement security in an Analysis Services multidimensional solution.

Lessons

  • Lesson 1: Deploying an Analysis Services Database
  • Lesson 2: Securing an Analysis Services Database

Lab: Deploying and Securing an Analysis Services Database

  • Exercise 1: (Level 200) Deploying an Analysis Services Database
  • Exercise 2: (Level 200) Securing an Analysis Services Database

After completing this module, students will be able to:

  • Deploy an Analysis Services database.
  • Secure an Analysis Services database.

Module 8: Maintaining a Multidimensional Solution

This module discusses the maintenance tasks associated with an Analysis Services solution, and describes how administrators can use the Analysis Services management tools to perform them.

Lessons

  • Lesson 1: Configuring Processing
  • Lesson 2: Logging, Monitoring, and Optimizing an Analysis Services Solution
  • Lesson 3: Backing Up and Restoring an Analysis Services Database

Lab: Maintaining a Multidimensional Solution

  • Exercise 1: (Level 200) Configuring Processing
  • Exercise 2: (Level 200) Implementing Logging and Monitoring
  • Exercise 3: (Level 200) Backing Up and Restoring an Analysis Services Database

After completing this module, students will be able to:

  • Configure processing settings.
  • Log, monitor, and optimize an Analysis Services solution.
  • Back up and restore an Analysis Services database.

Module 9: Introduction to Data Mining

This module introduces data mining, and describes how to implement data mining structures and models. It then explains how to validate data model accuracy.

Lessons

  • Lesson 1: Overview of Data Mining
  • Lesson 2: Creating a Data Mining Solution
  • Lesson 3: Validating Data Mining Models

Lab: Introduction to Data Mining

  • Exercise 1: (Level 200) Creating a Data Mining Structure
  • Exercise 2: (Level 200) Adding a Data Mining Model
  • Exercise 3: (Level 200) Exploring Data Mining Models
  • Exercise 4: (Level 200) Validating Data Mining Models

After completing this module, students will be able to:

  • Describe data mining.
  • Create a data mining solution.
  • Validate data mining models.

 
Prerequisites & Certificates
Pre-Requisites

Conceptual understanding of OLAP solutions. Experience navigating the Microsoft Windows Server environment. Experience with Windows services (starting and stopping). Experience creating service accounts and permissions. Experience with Microsoft SQL Server, including: SQL Server Agent. SQL Server query language (SELECT, UPDATE, INSERT, and DELETE). SQL Server System tables. SQL Server accounts (users and permissions).

Certificates offered

Certificate of Completion


Cancellation Policy
DesTech may cancel or reschedule a class at its sole discretion. In the event of a cancellation or class date reschedule DesTech will use reasonable efforts to notify participants at least one week in advance. Students will not be charged for the class cancellation or rescheduling.

Please notify DesTech immediately should a registered student have to reschedule or cancel training. Cancellation fees may apply as outlined below.

For publicly scheduled instructor-led training events the following cancellation policy applies:

1) If the student cancels or reschedules a registration 7 or more calendar days before the scheduled start date of the class there is no charge.
2) If the student cancels or reschedules a registration between 1 and 6 calendar days prior to the scheduled start date of the class a late notice fee of 50% of the course cost will be charged.
3) If the student cancels or reschedules on the first day of the class or does not show up the full class cost (100%) will be charged.

For privately scheduled instructor-led training events the following cancellation policy applies:

4) If the class is canceled or rescheduled 14 or more calendar days before the scheduled start date of the class there is no charge.
5) If the class is canceled or rescheduled between 1 and 13 calendar days prior to the scheduled start date of the class 50% of the class cost will be charged.
6) If the class is canceled on the first day of the class or some or all of the students do not attend the full class cost (100%) will be charged.
Map & Reviews
DesTech
[ View Provider's Profile ]

DesTech Toronto
69 Yonge Street
Suite 1200

Toronto, ON
Canada   M5E 1K3


Reviews
 

This course has not yet been rated by one of our members.

If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.

Here are some reviews of the training vendor.
Denny was a great instructor and made the course very interesting and easier to grasp
Reviewed by 2016
Our Instructor Denny Eapen was great. He was very enthusiastic and made some dry material very interesting. The few issues that I had with this session are the following. The Virtual machines that were provided by Microsoft were very slow, clunky, and only accessible by a flaky browser. The room felt sort of stuffy and everyone in the room was sneezing constantly as if there were no air filters or the ducts hadn't been cleaned. Over all this was a great training course and you could really tell that Denny knew his stuff.
Reviewed by 2016
Excellent course and process. Made learning the materials easy and everything was relevant.
Reviewed by 2015
The only negative about the facilities is the poor windows that let in a lot of street noise, especially sirens, that were disruptive to concentration
Reviewed by 2015
The instructor was very professional and pleasant. Would definitely take another course from this training provider in the future.
Reviewed by 2015
Note: there is no instruction provided for this course. You review the book and do the labs on a provided workstation independently. There is a knowledgeable person available if you need to ask questions.
Reviewed by 2014
The Course needs to upgrade the Report Builder version to the latest. It impacts the lab sessions and corresponding course ware.
Reviewed by 2014
The volume in the course presentation delivery (modern classroom and hence remote delivery) can be slightly higher. Otherwise everything was good.
Reviewed by 2014
Great course material and having the labs available afterwards is fantastic!
Reviewed by 2014
I provided written feedback on the last day of training. The most notable feedback is that the facilitator, while very knowledgeable and fluent in the topic, was not very engaging. The material is dry and the facilitator read text almost word for word and with very little engaged conversation. It was difficult at times to maintain concentration. Also, I appreciated the monitors on the desks for the presentation (much nicer idea than an overhead or projector) but the facilitator was very distracting in her use of the cursor (a lot of movement such as following along with every word or circles around text and pages).
Reviewed by 2014
20-November-2017 $1485 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 25 times.