SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services (SSAS)

Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

Huntsville, Alabama

Montgomery / Birmingham, Alabama

Anchorage, Alaska

Calgary, Alberta

Phoenix, Arizona

Fayetteville / Little Rock, Arkansas

Oakland / San Jose / San Francisco, California

Oceanside / San Diego, California

Pasadena / Orange County / Los Angeles, California

San Bernardino / Riverside, California

Boulder / Colorado Springs / Denver, Colorado

Washington, DC

Wilmington, Delaware

Manchester / London, England

DeLand / Orlando, Florida

Fort Lauderdale / Miami, Florida

Gainesville / Jacksonville, Florida

Saint Petersburg / Tampa, Florida

Titusville & Melbourne, Florida

Alpharetta & Atlanta, Georgia

Augusta & Savannah, Georgia

Macon & Columbus, Georgia

Bloomington, Illinois

Chicago, Illinois

Indianapolis, Indiana

Cedar Rapids / Des Moines, Iowa

Dublin, Ireland

Kingston, Jamaica

Wichita, Kansas

Paducah / Lexington / Louisville, Kentucky

Baton Rouge, Louisiana

Valletta, Malta

Hagerstown & Frederick, Maryland

Greenbelt / Silver Spring / Baltimore, Maryland

Boston / Cambridge, Massachusetts

Hartford, Connecticut / Springfield, Massachusetts

Taunton, Massachusetts / Providence, Rhode Island

Ann Arbor / Farmington Hills / Detroit, Michigan

Grand Rapids, Michigan

Lansing, Michigan

Saginaw / Flint / Bay City / Midland, Michigan

Saint Paul / Minneapolis, Minnesota

Jackson, Mississippi

Gulfport / Biloxi, Mississippi

Whiteman Air Force Base / Kansas City, Missouri

Reno and Las Vegas, Nevada

Santa Fe / Albuquerque, New Mexico

Newark, New Jersey

Princeton, New Jersey & Philadelphia, Pennsylvania

White Plains / New York City, New York

Charlotte, North Carolina

Durham / Raleigh, North Carolina

Bowling Green / Toledo, Ohio

Cincinnati, Ohio

Cleveland & Columbus, Ohio

Tulsa / Oklahoma City, Oklahoma

Toronto, Ontario

Portland, Oregon

Pittsburgh, Pennsylvania

Providence, Rhode Island

Edinburgh / Glasgow, Scotland

Columbia & Charleston, South Carolina

Memphis / Jackson / Nashville, Tennessee

College Station and Houston, Texas

El Paso, Texas / Ciudad Juarez, Mexico

San Antonio / Austin, Texas

Wichita Falls & Dallas, Texas

Ogden / Salt Lake City, Utah

Burlington, Vermont

Fairfax / Dulles / McLean / Herndon / Reston, Virginia

Richmond / Alexandria / Arlington, Virginia

Virginia Beach / Norfolk, Virginia

Tacoma / Seattle, Washington

Madison / Milwaukee, Wisconsin

Course Number: 654
Duration: 3 days
view class outline

SQL Server 2005 Analysis Services Training Overview

Accelebrate's Introduction to SQL Server 2005 Analysis Services training teaches attendees how to setup, utilize, and administer SQL Server 2005 Analysis Services (SSAS).

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.

SQL Server 2005 Analysis Services Training Prerequisites

All attendees should have prior experience with SQL Server 2005.

Hands-on/Lecture Ratio

This class is 50% hands-on, 50% lecture, with the longest lecture segments lasting for 20 minutes.

SQL Server 2005 Analysis Services Training Materials

All students receive comprehensive courseware and a copy of Wrox Press's Professional SQL Server 2005 Analysis Services with MDX and comprehensive courseware covering all topics taught.

Software Needed on Each Student PC

SQL Server 2005, including Analysis Services.

Note: If you have purchased this course, please contact us for a detailed setup sheet.

SQL Server 2005 Analysis Services Training Objectives

All attendees will learn to:

Perform OLAP modeling
Use SSAS inside of BIDS
Store and aggregate data cubes
Write multidimensional expressions (MDX)
Administer SSAS
Use SSAS in conjunction with reporting clients and Microsoft Office

SQL Server 2005 Analysis Services Training Outline

What is Microsoft BI?

Core concept – BI is the cube or UDM
Example cube as seen using Excel pivot table
MS BI is comprehensive – more than Analysis Services on SQL Server
Demonstration of SQL Reporting Services with cube as data source

OLAP modeling

Modeling source schemas—stars and snowflakes
Understanding dimensional modeling—Dimensions (Type 1, 2, or 3) or rapidly changing
Understanding fact (measures) and cube modeling
Other types of modeling—data mining etc.

Using SSAS in BIDS

Understanding the development environment
Creating Data Sources and Data Source Views
Creating cubes – using the UDM and the Cube Build Wizard
Refining Dimensions and Measures in BIDS

Intermediate SSAS

KPIs
Perspectives
Translations – cube metadata and currency localization
Actions – regular, drillthrough and reporting

Advanced SSAS

Using multiple fact tables
Modeling intermediate fact tables
Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
Modeling changing dimensions – Dimension Intelligence w/ Wizard
Using the Add Business Intelligence Wizards – writeback, semi-additive measures, time intelligence, account intelligence

Cube storage and aggregation

Storage topics – basic aggregations, MOLAP
Advanced Storage Design – MOLAP, ROLAP, HOLAP
Partitions – relational and Analysis Services partitions
Customizing Aggregation Design - Processing Design
Rapidly changing dimensions / ROLAP dimensions
Welcome to the Real Time -- Proactive Caching
Cube processing options

Beginning MDX

Basic syntax
Using the MDX query editor in SQL Server Management Studio
Most-used Functions & Common tasks
New MDX functions

Intermediate MDX

Adding calculated members
Adding scripts
Adding named sets
.NET Assemblies

SSAS administration

Best practices – health monitoring
XMLA scripting (SQL Mgmt Studio)
Other Documentation methods
Security – roles and permissions
Disaster Recovery – backup / restore
Clustering – high availability

Introduction to Data Mining

What and why?
Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naive Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
Data Mining dimensions
Data Mining clients
Processing mining models

Introduction to Reporting clients

Excel 2003 and 2007 Pivot Tables
SQL Server 2005 Reporting Services (SSRS) & Report Builder
SPS RS web parts & .NET report viewer controls
Business Scorecards & ProClarity

Integration with Office 2007

SharePoint 2007 and AS
Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
Excel Services 2007 and AS (Web Services)

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
Adobe Training

PHP Training

XML Training

Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003-2006 by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Complimentary SQL Server Training Seminar