Microsoft Courses

 

 

Authorised Training Partner


 

Home SQL Server 2005 2791: Implementing & Maintaining SQL Server 2005 Analysis Services

2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services

Course Length: 3 days.   

 

Overview

This course provides students with the knowledge and skills to implement an Analysis Services solution in their organisation. In addition, students will learn to use the Analysis Services development tools to create an Analysis Services database and OLAP cubes. Furthermore, students will also be able to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

 

After completing this course, students will be capable of describing how SQL Server Analysis Services can be used to implement analytical solutions as well as creating multidimensional analysis solutions with SQL Server Analysis Services. Students will also be skilled in customising an Analysis Services cube and deploying and securing an Analysis Services database.

 

Audience

This course is intended for Information Technology Professionals and Developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services.

 

Outline

  1. Introduction to Microsoft SQL Server 2005 Analysis Services
  2. Creating Multidimensional Analysis Solutions
  3. Working with Dimensions
  4. Working with Measures and Measure Groups
  5. Querying Multidimensional Analysis Solutions
  6. Customising Cube Functionality
  7. Deploying and Securing an Analysis Services Database
  8. Maintaining a Multidimensional Solution
  9. Introduction to Data Mining

 

Prerequisites

Students must have a conceptual understanding of OLAP solutions. They should also have experience navigating the Microsoft Windows Server environment and starting and stopping the Windows services. In addition, students should have experience with creating service accounts and permissions as well as with Microsoft SQL server including SQL server Agent, server query language, server system tables and server accounts.

 

Select your location for times:



Didn't find what you are looking for? If this course is not listed in your preferred city or timeframe, please call EXCOM on (09) 913 9266 and we'll look to provide a solution based on your requirements.

Price: $2070


Call us today to see whether you may be eligible for any discounts.

Latest Offers

Maximise Your 2010 - 2011
Training Budget

Back by Popular Demand: SAVE 35% to 50% off all EXCOM training with our Bonus Training Credits offer!

 

Cisco CCNA for just $2,990*
At LESS THAN HALF PRICE, enjoy best ever savings on the CCNA at just $2,990 plus GST ... also check out the further savings to be made on the CCNP.

 

PRINCE2® Foundations & Practitioner for just $2,990*
Enhance your Project Management skills and secure your formal PRINCE2® Foundations & Practitioner Qualifications for just $2,990
plus GST.

 

ITIL Foundations for just $1,400*
A must for all IT Professionals: save over 25% on ITIL V3 Foundations. Pay just $1,400
plus GST - SAVE over $500!

 

Get your 2nd Microsoft course
HALF PRICE

Double Whammy offer: book one Microsoft course and get your second half price!
SAVE up to $1,725!

 

 

MORE OFFERS >

porno izle porno izle porno izle porno izle dizi izle