ASP.NET, VB.NET, and C# Training Classes     
Accelebrate delivers SharePoint , ASP.NET, SQL Server, Java, and other training courses in the USAAccelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Canada     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the UK     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Ireland     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in the Netherlands     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses in Sweden     Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses internationally  
1 877 849 1850   0808 234 2132   1 800 550 311   0 800 022 6730   020 795 420   +1 678 648 3113  
Microsoft and .NET TrainingSQL Server TrainingSharePoint TrainingJava TrainingAdobe TrainingDatabase and Reporting TrainingXML, PHP, Perl and Other TrainingWeb/Application Server Training
HomeAboutContact Us 


Please contact us
for GSA pricing
and CMAS pricing.

GSA - Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
GS-35F-0307T

 CMAS Approved Contractor Accelebrate delivers SharePoint, ASP.NET, SQL Server, and Java training courses
Contract #
3-09-70-2645A



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Edmonton & Calgary, Alberta
  • Phoenix, Arizona
  • Tucson, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Amsterdam, The Netherlands / Brussels, Belgium
  • Kamloops / Vancouver, British Columbia
  • Oakland / San Jose / San Francisco, California
  • Sacramento, 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
  • 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
  • Boise, Idaho
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge/New Orleans, Louisiana
  • Portland, Maine
  • Hagerstown & Frederick, Maryland
  • Annapolis / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Flint, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • St. Louis, Missouri
  • Whiteman Air Force Base / Kansas City, Missouri
  • Lincoln / Omaha, Nebraska
  • Reno and Las Vegas, Nevada
  • Fredericton / Moncton / Saint John, New Brunswick
  • Santa Fe / Albuquerque, New Mexico
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • Trenton, New Jersey
  • Albany, New York
  • Buffalo, New York
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bismarck & Fargo, North Dakota
  • Bowling Green / Toledo, Ohio
  • Canton / Akron, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Dayton, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Saskatoon / Regina, Saskatchewan
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Spartanburg & Greenville, South Carolina
  • Stockholm, Sweden
  • Chattanooga / Knoxville, Tennessee
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas
  • 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
  • Charleston, West Virginia
  • Madison / Milwaukee, Wisconsin

 

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

Print This Outline
E-mail This Outline
Get A Quote
Course Number: SQL-122
GSA/Previous Course Number: 654
Duration: 3 days
view class outline

Looking for SSAS 2008 training?

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). In addition, all SSAS training students master beginning and intermediate MDX.

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. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, 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 SSAS training attendees should have prior experience with SQL Server 2005.

Hands-on/Lecture Ratio

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

SQL Server 2005 Analysis Services Training Materials

All SSAS training 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 (SSAS) 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
 

Print This OutlineE-mail This OutlineGet A Quote


Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.

 
Request Information for Group Training at Your Site   Request Information for Group Training at Your Site
 
Accelebrate®
Focuses on You!


Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.

 
Accelebrate was extremely comprehensive in their coverage of the complex BI subject matter.
The instructor's willingness to go off the map to met our customized needs was extremely helpful!
 
—Jason Stele
Indiana Business College
Indianapolis, Indiana
       
Delivering training in a city near you:
Albany, NY
Atlanta, GA
Austin, TX
Baltimore, MD
Birmingham, AL
Boston, MA
Buffalo, NY
Charlotte, NC
Chicago, IL
Cincinnati, OH
Cleveland, OH
Columbus, OH
Dallas, TX
Denver, CO
Des Moines, IA
Detroit, MI
Houston, TX
Indianapolis, IN
Jacksonville, FL
Kansas City, MO
Las Vegas, NV
Los Angeles, CA
Memphis, TN
Miami, FL
Minneapolis, MN
Nashville, TN
New York City, NY
Oklahoma City, OK
Orlando, FL
Philadelphia, PA
Phoenix, AZ
Pittsburgh, PA
Portland, OR
Raleigh, NC
Richmond, VA
Salt Lake City, UT
San Diego, CA
San Francisco, CA
Seattle, WA
St. Louis, MO
Tampa, FL
Toronto, ON
Tulsa, OK
Washington, DC
     
               

VB.NET, C#, ASP, & ASP.NET Training Java Training SQL Server Training
SharePoint Training  Adobe Training PHP Training XML Training Perl Training Sitemap

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

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | Sacramento, CA | San Diego, CA | San Francisco, CA | San Jose, CA | Denver, CO | Washington, DC | Jacksonville, FL | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | Las Vegas, NV | Albany, NY | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Dayton, OH | Oklahoma City, OK | Toronto, ON | Portland, OR | Philadelphia, PA | Pittsburgh, PA | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | San Antonio, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK