Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions Print Page
Course Description

OLAP Solutions Using Microsoft SQL Server 2005 Analysis Services (SSAS)

Course Objective


In-House Training for as few as 3 Attendees >>

Or Call Toll Free
1-888-230-9052

Knowledge is power! As its name suggests, the promise of Microsoft SQL Server Analysis Services 2005 is to promote better data analytics by giving information workers the right tool to analyze consistent, timely, and reliable data.

This four day instructor led course shows database administrators and developers how to build complete OLAP solutions with Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform. Database administrators will learn how to design and manage sophisticated OLAP cubes that provide rich data analytics. In addition, this course gives developers the necessary background to extend UDM with custom programming logic, in the form of MDX expressions, scripts and .NET code.

This course also helps prepare you for certification exam 70-445.

What you will learn

  • 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

Who should attend

  • This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server.

Prerequisites

  • Be familiar with SQL Query and MS SQL Server database
  • Have rudimentary programming skills
  • Dimensional modeling understanding would be a plus
  • Data warehouse fundamentals would be a plus
  • Have basic knowledge of the Windows operating system and platform

 

Onsite Training  Class Schedule  Registration

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey