Career Training >> Information Technology Training >> SQL Server Training >> 2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Training Seminar
Course ID: 14466 | Course Duration: 3 Days
Course Dates: 
 
Career Training
 

2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Training Class

Course ID: 14466 		 
 
Course Snapshot View Dates Add To My Courses Get More Information About This Course Register Online Register By Fax On-Site Training View Printer Friendly Version
 
     
 

2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Training Seminar

Overview:
In this course, business intelligence (BI) professionals working in enterprise environments learn how to design a multidimensional solution architecture that supports their BI solution.

Who Should Attend:
This course is intended for experienced BI professionals. The target students for this course already have an understanding of how to use SQL Server 2005 tools to implement Analysis Services functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying an Analysis Services solution.

At Course Completion:
After completing this course, students will be able to: - Capture the business and technical requirements for an analysis solution. - Design and implement a logical Online Analytical Processing (OLAP) solution architecture. - Design physical storage for a multidimensional solution. - Create calculated members and named sets. - Implement Key Performance Indicators (KPIs), actions, and stored procedures. - Design the infrastructure for an OLAP solution. - Deploy and secure an Analysis Services solution in a production environment. - Monitor and optimize an Analysis Services solution. - Implement a data mining solution.
 

  
     
     
  Course Details  
     
     
  Agenda  
 

Outline: 
Lesson 1: Capturing Business and Technical Requirements

Planning an Analysis Solution
Identifying Requirements and Constraints


 
Lesson 2: Designing and Implementing a Logical OLAP Solution Architecture

Planning an OLAP Solution
Designing and Implementing Fact and Dimension Tables
Designing and Implementing Cubes


 
Lesson 3: Designing Physical Storage for a Multidimensional Solution

Designing Physical Storage
Partitioning Relational Data
Partitioning Multidimensional Data


 
Lesson 4: Creating Calculations

Implementing Calculated Members
Implementing Named Sets
Implementing Scoped MDX Scripts


 
Lesson 5: Extending Cube Functionality

Key Performance Indicators
Actions
Stored Procedures
Create KPIs
Create actions
Create stored procedures

 
Lesson 6: Designing an Analysis Services Infrastructure

Considerations for Analysis Services Resource Requirements
Considerations for Analysis Services Scalability
Considerations for Analysis Services Availability


 
Lesson 7: Deploying a Multidimensional Solution into Production

Deploying an Analysis Services Database
Managing Analysis Services Security


 
Lesson 8: Optimizing an OLAP Solution

Monitoring Analysis Services
Optimizing Performance


 
Lesson 9: Implementing Data Mining

Introduction to Data Mining
Implementing a Data Mining Solution
Using Data Mining in a BI Solution
 

  
     
     
     
 
On-Site Training Bring this 2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services training class in-house at your facility. Request More Information Request More Information On 2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
 
Career Training
 
 
Career Training
  2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Training Course Dates and Locations  
     
  Course ID: 14466 | Course Duration: 3 Days  
     
  Locations:  
     
  User Incentive For Registering on TrainUp.com! Gift card when you register today!  
     
 
Start Date Price      Location/Event Details Register Online Request
More Info		   Print/Fax
Register
02/04/2009 $1,425.00    Boston, MA Register Online For The 02/04/2009 Event Request More Information   Register By Fax For The 02/04/2009 Event
03/09/2009 $1,425.00    Anaheim, CA Register Online For The 03/09/2009 Event Request More Information   Register By Fax For The 03/09/2009 Event
03/09/2009 $1,425.00    Burbank, CA Register Online For The 03/09/2009 Event Request More Information   Register By Fax For The 03/09/2009 Event
03/09/2009 $1,425.00    Culver City, CA Register Online For The 03/09/2009 Event Request More Information   Register By Fax For The 03/09/2009 Event
04/27/2009 $1,350.00    King of Prussia, PA Register Online For The 04/27/2009 Event Request More Information   Register By Fax For The 04/27/2009 Event
09/28/2009 $1,350.00    King of Prussia, PA Register Online For The 09/28/2009 Event Request More Information   Register By Fax For The 09/28/2009 Event
 
     
 
On-Site Training Bring this 2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services training class in-house at your facility. Request More Information Request More Information On 2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
 
Career Training
 
 
Career Training
  Browse Our Catalog  
     
  Select a market segment to view more courses

  
     
  Or, select a category to view more Information Technology courses

  
     
  Browse By Category Browse By Category

Browse By Location Browse By Location

Browse New Courses Browse New Courses

  
     
Career Training
 
   
 
 
Career Training
   
Career Training
 
 
 
 


Site Map -- Top Training Courses -- Request On-Site Training

Find Jobs -- Degree Programs -- Training Providers -- Resource Center -- About Us -- Contact us

TrainUp.com Your Career Training Marketplace