SQL - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 6234

Course Type

Scheduled:

Date	Location	Duration	Cost
18 Jul 2012 (Wed) 19 Jul 2012 (Thu) 20 Jul 2012 (Fri)	Sunderland	3	£ 1195
All prices exclude VAT

Private:

This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice.

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Course Overview

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

Prerequisites

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

Objectives

Delegates will be able to:

Describe how SQL Server Analysis Services can be used to implement analytical solutions.
Create multidimensional analysis solutions with SQL Server Analysis Services.
Implement dimensions and cubes 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.

Related Courses

Course Content

Introduction to Microsoft SQL Server Analysis Services

Creating Multidimensional Analysis Solutions

Working with Cubes and Dimensions

Working with Measures and Measure Groups

Querying Multidimensional Analysis Solutions

Customizing Cube Functionality

Deploying and Securing an Analysis Services Database

Maintaining a Multidimensional Solution

Introduction to Data Mining

Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
For further information please contact us on 0191 377 8377

What's Included

1 delegate per computer
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises

SQL Training Courses in Newcastle, Darlington, Durham, Gateshead, Sunderland and throughout the North East - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 6234 Microsoft courses

"Trainer was excellent and very approachable"
L.C. CLRN - VBA Using Excel

"Excellent as always"
S.W. National Grid - PhotoShop Level 1

"The trainer was excellent, he listened to what we wanted to gain from the course and didn’t waste time trying to teach us things we would never use, he explained in simple terms..."
P.C. Northumbria Police - Excel Level 2

"Great, exactly what I wanted at a level I could understand"
P.A. Straughans - Access Level 1

"Having one-on-one training was unexpected but was a tremendous bonus. Could not fault the day"
D.R. UK Asset Resolution - PowerPoint Level 2

"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T.S. Bell Truck and Van - Excel 2007 / 2010 Level 2

"This is my third course and I have enjoyed them all"
T.S. Bell Truck and Van - PowerPoint Level 2

"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J.M. The Cyrenians - VBA using Excel

"I enjoyed the course and was pleased with the speed it progressed"
G.J. NCFE - HTML Level 1

"Very good way to teach. Nice mix of theory and practice"
K.F. Durham University - Access Level 2

View More | Hide