 |
Please contact us
for GSA pricing
and CMAS pricing.
Contract #
GS-35F-0307T
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
|
|
|
SSAS 2008 Training: Introduction to SQL Server 2008 Analysis Services
|
Course Number: SQL-222
GSA/Previous Course Number: 933
Duration: 3 days
view class outline
Looking for SSAS 2005 training?
SSAS 2008 Training Overview
Accelebrate's Introduction to SQL Server 2008 Analysis Services training teaches attendees best-practice usage of SQL Server 2008 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. 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.
SSAS 2008 Training Prerequisites
All SSAS training attendees should have prior experience with SQL Server 2008.
Hands-on/Lecture Ratio
This SSAS training class is 50% hands-on, 50% lecture, with the longest lecture segments lasting for 20 minutes.
SSAS 2008 Training Materials
All SSAS training students receive a copy of Microsoft Press' SQL Server 2008 Analysis Services Step-by-Step.
Software Needed on Each Student PC
- SQL Server 2008, including Analysis Services.
Note: If you have purchased this course, please contact us for a detailed setup sheet.
SSAS 2008 Training Objectives
All attendees will learn to:
- Perform OLAP modeling
- Use SSAS inside of BIDS
- Store and aggregate data cubes
- Write multi-dimensional expressions (MDX)
- Administer SSAS
- Use SSAS in conjunction with reporting clients and Microsoft Office
|
SSAS 2008 Training Outline
- What Is Microsoft Business Intelligence?
- Define Business Intelligence
- Understand the Cube Structure
- Deploy and View a Sample Cube
- View a Cube by using Excel
- View a Cube by using SQL Reporting Services
- OLAP Modeling
- Understand Basic OLAP Modeling (star schema)
- Understand Dimensional Modeling (stars and snowflakes)
- Understand Measure (fact) and Cube Modeling
- Model with SQL Server Business Intelligence Development Studio (BIDS)
- Using SSAS in BIDS
- Understand the Development Environment
- Create Data Sources
- Create Data Source Views
- Create Cubes by using the Cube Wizard
- Intermediate SSAS
- Learn how to Create Key Performance Indicators (KPIs)
- Discover how to Create Perspectives
- See how to Create Translations for Cubes and Dimensions
- Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting
- Advanced SSAS
- Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
- Explore Advanced Dimension Types
- Learn how to use the Business Intelligence Wizard
- Understand Writeback in Dimensions
- Review Semi-Additive Measures in OLAP Cubes
- Cube Storage and Aggregation
- View Aggregation Designs
- Customize Aggregation Designs
- Implement Proactive Caching
- Use Relational and SSAS Partitions
- Customize Cube and Dimension Processing
- Introduction to MDX Queries
- Understand Basic MDX Syntax
- Use the MDX Query Editor in SSMS
- Understand Common MDX Functions and Tasks
- Review MDX Functions New to SSAS 2008
- MDX Expressions
- Understand the Calculation Subtab
- Learn how to add Calculated Members
- Explore how to add MDX Script Commands
- Discover how to add .NET Assemblies
- Introduction to Data Mining
- Understand Data Mining Concepts
- Review the Algorithms that SSAS Includes
- Consider Data Mining Clients
- Understand Mining Structure Processing
- SSAS Administration
- Implement SSAS Security
- Implement XMLA Scripts in SSMS
- Deploy and Synchronize Databases
- Understand SSAS Database Backup and Restore
- Advanced Administration and Optimization
- Implement SSIS to Manage SSAS Databases
- Explore Clustering
- Explore Scalability Options
- Understand Performance Tuning and Optimization
- Introduction to SSAS Clients
- Design Reports using Reporting Services
- Design Reports by using Report Builder
- Implement Excel 2007 Pivot Tables and Charts
- Use Excel 2007 as a Data Mining Client
- Review Microsoft Office SharePoint Server 2007
- Conclusion
|
| |
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
|
|
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.
|
|
|
|
