Overview
This three-day, instructor-led course provides students with the knowledge and skills necessary to implement an Analysis Services solution in an organisation.
What’s Included?
All our public scheduled training courses offer delegates the following facilities which are all included at no extra cost: -
Mini Continental Breakfast, with a choice of Croissants, Pastries, Cereals, Juices, and of course Tea and Coffee
Buffet Lunch
A Selection of Soft Beverages are available throughout the Training Day
Full Course Manual (Official Curriculum Courseware for Technical Courses)
Course Exercise Files on CD or Floppy Disk
Course Stationery Pack (Pen, Pencil and Paper)
Framed Course Certificate (Vendor Accredited where required)
Objectives
At the end of the course, students will be able to:
Describe Microsoft SQL Server 2005 Analysis Services
Create Multidimensional Analysis Solutions
Work with Dimensions
Work with Measures and Measure Groups
Query Multidimensional Analysis Solutions
Customise Cube Functionality
Deploy and Secure an Analysis Services Database
Maintain a Multidimensional Solution
Describe Data Mining
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.
Prerequisites
Before attending this course, students must have:
Conceptual understanding of OLAP solutions
Experience navigating the Microsoft Windows Server Environment
Experience with Windows Services
Experience creating Service Accounts and Permissions