SQL Server 2005 Analysis Services

3 day course

In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions.  This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions.  This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.  Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%.

Overview of Course Topics:
(for a full detailed outline, visit our PDF link above)

• Microsoft BI
• OLAP Modeling
• Using SSAS in BIDS
• Intermediate SSAS
• Advanced SSAS
• Cube Storage and Aggregation
• Beginning MDX
• Intermediate MDX
• SSAS Administration
• Introduction to Data Mining
• Introduction to Reporting Clients
• Integration with Office