Course 2942 New Features of Microsoft SQL Server 2005 Analysis Services

In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions. This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445.

Plus, Course 2942 New Features of Microsoft SQL Server 2005 Analysis Services E-Learning lets you learn at your own pace. Work online or download courses to your computer to study when you are not connected to the Internet.  

Our Price:  $99

Add to Cart

Purchase Course 2942 New Features of Microsoft SQL Server 2005 Analysis Services to save on Microsoft SQL Server E-learning

Title: Course 2942 New Features of Microsoft SQL Server 2005 Analysis Services
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 6 Hours
Language: English

Course 2942 New Features of Microsoft SQL Server 2005 Analysis Services Objectives:
At the end of the course, students will be able to:

Understand the core concepts of SQL Server Analysis Services (SSAS) and the new features in the SSAS architecture.

Design and deploy a Unified Dimensional Model.

Upgrade to and configure SSAS 2005.

Understand the new MDX and programming features in SSAS 2005.

Understand data mining concepts and the tools used to develop data mining models.

System Requirements:
To view this course, you need:

A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ

Microsoft® Windows® 2000 or higher

Microsoft Internet Explorer 6.0 or higher

Macromedia Flash 7.0 or higher (1MB disk space needed to install)

Microsoft Windows Media Player 7.0 or higher

Microsoft XML Core Services 3.0 or higher

A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.

A sound card, and either speakers or headphones (for multi-media audio).

Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Accessibility Requirements:
The following software must be running on your computer in order to access this course with Screen Reader Software:

Microsoft Internet Explorer 6.0 or higher

Window-Eyes from GS Micro

JAWS from Freedom Scientific

MSAA enabled

Course 2942 New Features of Microsoft SQL Server 2005 Analysis Services course contents
Course Overview
Module Introduction
How to Use This Course
Course Information
Exploring SSAS Core Concepts and Architecture
Module Introduction
SSAS Core Concepts
Lesson Introduction
Data Sources and Data Source Views
Dimensions
Measures and Measure Groups
Cubes
The Unified Dimensional Model (UDM)
Self Test
New Features in the SSAS Architecture
Lesson Introduction
New Server Features for Administrators
New Server Features for Developers
New Client Programmability Features
Self Test
Module Summary
Designing and Deploying a Unified Dimensional Model
Module Introduction
Creating an Analysis Services Project
Lesson Introduction
The Business Intelligence Development Studio
The Visual Studio Integrated Development Environment
Creating a Data Source
Creating a Data Source View
Modifying the Properties of a Data Source View
Self Test
Building a Cube
Lesson Introduction
Starting the Cube Wizard
Selecting the Build Method
Identifying Fact and Dimension Tables
Selecting Time Periods
Selecting Measures and Reviewing Dimension Hierarchies
Deploying a Cube
Self Test
Implementing Advanced Features of a Cube
Lesson Introduction
Adding Business Intelligence to a Cube
Adding Key Performance Indicators to a Cube
Adding Translations to a Cube
Adding Perspectives to a Cube
Adding Actions to a Cube
Adding User-Defined Functions to a Cube
Self Test
Lab: Building a Cube
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Administering SSAS
Module Introduction
Upgrading and Migrating to SSAS 2005
Lesson Introduction
Considerations for Upgrading to SSAS 2005
Migrating to SSAS 2005
Self Test
Configuring Roles, Groups, and Permissions
Lesson Introduction
User Authentication
Granting Administrative Access
Granting User Access
Granting Permissions to Roles
Self Test
Managing SSAS
Lesson Introduction
Configuring SSAS
Backing Up an SSAS Database
Restoring an SSAS Database
Processing a Cube
Optimizing SSAS Performance
Self Test
Managing Partitions and Real Time BI
Lesson Introduction
Managing Partitions
Creating a New Partition
Managing Proactive Caching
Self Test
Lab: Administering SSAS
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Programming in SSAS 2005
Module Introduction
Exploring SQL Server Management Studio
Lesson Introduction
The Toolbar in SQL Server Management Studio
The MDX Query Editor
The Object Explorer
Self Test
New Features of MDX
Lesson Introduction
Attributes
Hierarchies
Subcubes
Named Sets
Calculated Members
Self Test
Scripting with MDX
Lesson Introduction
An Overview of MDX Scripts
Storing Calculations with a Cube
Scripting Scope and Context Elements
Scripting Variables and Parameters
Handling Exceptions in MDX Scripts
Self Test
New Programming Features
Lesson Introduction
XML for Analysis (XMLA)
ADOMD.NET
Analysis Management Objects (AMO)
Self Test
Lab: Programming in SSAS 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Working with Data Mining Solutions in SSAS
Module Introduction
Data Mining Concepts and New Features
Lesson Introduction
An Introduction to Data Mining
Using Data Mining to Enhance Business Solutions
Data Mining Algorithms
Self Test
Exploring Data Mining Models
Lesson Introduction
Data Mining Models
Considerations for Developing Data Mining Models
Self Test
Working with Data Mining Tools
Lesson Introduction
Creating a Data Mining Structure
The Data Mining Designer
Validating Data Mining Models
Data Mining Extensions (DMX)
Data Mining Using SQL Server Management Studio
Self Test
Lab: Working with Data Mining Solutions
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Our Price:  $99

Add to Cart

Frequently Asked Questions on Microsoft E-Learning

Question: What is Microsoft E-learning?
Answer: Official Microsoft E-Learning products provide a thorough learning experience by incorporating features designed to improve your product proficiency and boost your productivity. Assessments, hands-on virtual labs, expert advice, and an interactive, non-linear approach all contribute to make Microsoft E-Learning an engaging and flexible learning experience. Regardless of your type of organization, skill levels, or learning styles; Microsoft E-Learning can provide access to just the right software training anytime and anywhere - for IT Professional, developers, and home and office workers. Microsoft E-Learning content is created by Microsoft experts, so the training comes straight from the source.

Question: How Long and how I will have access to purchased Microsoft E-Learning?
Answer: When you purchase any Microsoft Elearning course from us, we will send product key to activate your Microsoft E-learning subscription directly on Microsoft official website. You will need internet access to attend your course. Subscription is for 365 days from your activation date.

Question: How we are able to sell Microsoft E-Learning so cheap?
Answer: We are an Authorized reseller for Microsoft E-Learning Solutions. As a reseller we have special pricing from Microsoft E-learning. You attend Microsoft E-Learning course directly at official Microsoft Elearning website. We only provide you activation key to activate your Microsoft elearning course. Only difference is you save money when you purchase from us.

Question: Can I try one of the course before I purchase?
Answer: Absolutely, There are plenty of courses available to try Free of cost and of course no obligation to purchase. Click here for complete Free Microsoft E-Learning Courses.

Question: Can I get Refund for my Microsoft Elearning purchase?
Answer: Sorry NO! All of our orders are FINAL. There is NO RETURN, NO REFUND, NO EXCHANGE. Once order is processed, everything is FINAL. So If you have any questions, please contact customer service at elearning@solartechlearning.com before you place an order.