 |
SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration
SQL Server Training: Introduction to Microsoft SQL Server 2005 Administration
SQL Server 2005: Advanced Topics
SQL Server 2005 Reporting Services Training: Introduction to SQL Server 2005 Reporting Services
SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services
SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services
Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writing
T-SQL Training: T-SQL for SQL Server 2005 for Developers
Live Online Training
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T

Complimentary SQL Server Training Seminar
Organizations in the Atlanta, Georgia area are encouraged
to contact Accelebrate® about having a complimentary, one-hour SQL Server seminar delivered for their developers. Contact
us today for more information.

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
|
 |
 |
SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services (SSAS)
|
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
|
| |
|
 |
Accelebrate®
Comes to You! |
 |
Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.
For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

|
 |
|
| |
| Accelebrate E-Newsletter |
 |
Get the latest Web development news delivered to your email box once a month!

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