Microsoft Training 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.

 

More Information
For further information about our IT courses and certifications or to book ...


Call EXCOM today

Call us today on +65 6496 7706    
to speak with an EXCOM representative
about a customised training solution

Email EXCOM today

Register your interest via Email
and an EXCOM representative will call you
shortly to assist you with your training needs

Ready to Book? Click here!

Ready to Book?
If you have found a course time that suits you and are ready to book, simply click here to
download the course registration form.

 

 


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 6496 7706 and we'll look to provide a solution based on your requirements.

Price: $1800


Latest Offers

Certification Kick Off
Be among the first ten people to book for our eligible certifications and you can save between $3,200 and $5,100!

 

Extra Discounts on Government Funded Certifications
Enjoy additional discounts on a range of Microsoft and Cisco certifications approved for Singapore Government funding and save up to $3,294 per certification!

 

Discounted CCNA pack
For a limited time, book your CCNA with EXCOM Education and you pay only S$3,800 including exams!

 

Get your 2nd course HALF PRICE
Double Whammy Offer: Buy one course and get the second HALF PRICE ... check out the list of eligible courses ...

 

MORE OFFERS >