 |
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
|
|
|
SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services (SSAS)
|
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
|
| |
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.
|
|
| |
 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 |
|
|
