cm logo
To speak to a training advisor please call
0800 40 848 40
training@coursemonster.com
All Courses / Microsoft Courses / Microsoft SQL Server 2005: Business Intelligence: Analysis Services (SSAS): Implementing and Maintaining
Share: Follow us: Bookmark with: twiter Print Page:

Microsoft SQL Server 2005: Business Intelligence: Analysis Services (SSAS): Implementing and Maintaining

Course Code: MS2791 (Also known as: M2791, MOC 2791)      Days: 3
Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

This three-day instructor-led course teaches students how to implement an Analysis Services solution in their organization. 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.

Microsoft are one of the world's popular software companies, this SQL Server course will help keep your skills up to date.

Related Courses

Audience

This course is intended for information technology (IT) professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services.

Skills Gained

  • Describe how SQL Server Analysis Services can be used to implement analytical solutions.
  • Create multidimensional analysis solutions with SQL Server Analysis Services.
  • Implement dimensions in an Analysis Services solution.
  • Implement measures and measure groups in an Analysis Services solution.
  • Query a multidimensional Analysis Services solution.
  • Customize an Analysis Services cube.
  • Deploy and Secure an Analysis Services database.
  • Maintain a multidimensional Analysis Services solution.
  • Implement a Data Mining solution.

Prerequisites

Before attending this course, students must have:

  • 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)

Course Outline

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

If you would prefer the flexibility of online training, use the link(s) below:

More Online Training>>



Top Selling Brands
cisco HP IBM ISEB ITIL Microsoft Nebosh oracle prince2 vmware


How to make a booking for the MS2791 course

Scheduled Dates

Request availability or enquire by clicking a date:

Sort by Location

London Region
London (Central)
£ 1,150
London (Central)
£ 1,150
London (Central)
£ 1,150
London (Central)
£ 1,150
London (Central)
£ 1,150

Sort by Date

London Region
£ 1,150
London Region
£ 1,150
London Region
£ 1,150
London Region
£ 1,150
London Region
£ 1,150

No Suitable Dates?

Please click above and we will take care of the rest.

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

Browse By Brands

  • Adobe
  • Cisco
  • Citrix
  • CompTIA
  • HP
  • IBM
  • ISEB
  • ITIL
  • Java
  • Linux
  • Apple
  • VMware
  • Novell
  • Microsoft
  • Oracle
  • PRINCE2
Brand index >>
Click here to browse our full range of courses >

Most popular courses
© 2012 CourseMonster® (Powered by CourseMonsterData)

CourseMonster books thousands of public training courses, classes and boot camps both in London, City of London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Aylesbury, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Newcastle, Norwich, Nottingham, Plymouth, Reading, Sheffield, Southampton, Surrey, Sussex, Midlands and Yorkshire. Topics range from software to administration, project management and development.