New Horizons Computer Learning Center
410-597-9722

SQL Server 2005 Analysis Services

Course Length: 3 Days

Overview:
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%.

Prerequisites:
Experience with SQL Server 2000 or 2005
Experience with basic relational database concepts (e.g., tables, queries, and indexing)
Experience with data transformation services
Experience with Excel 2003
Experience with SharePoint Server 2003.

Course Objectives:
Upon successful completion of this course, students will be able to:

• Learn the core concepts in building solutions using Microsoft Business Intelligence with SSAS
• Understand OLAP (cube) modeling and data mining
• See how to develop solutions using Business Intelligence Development Studio (BIDS)
• Understand advanced storage design including MOLAP, ROLAP, and HOLAP
• Learn the fundamentals of MultiDimensional Expressions (MDX)
• See best practices for SSAS administration using SQL Server Management Studio (SSMS) and XMLA (XML for Analysis)
• Work with OLAP reporting clients including Microsoft Excel and SQL Server Reporting Services
• See integration with Microsoft Office 2007 and Microsoft SharePoint 2007

Course Content

Lesson 1: What Is Microsoft Business Intelligence?

• Defining Microsoft Business Intelligence
• Understanding the UDM
• Building and Viewing a Sample Cube
• Viewing a Cube Using Excel
• Cubes in Reporting Services

Lesson 2: OLAP Modeling

• Selecting a Modeling Tool
• Understanding OLAP Modeling
• Understanding Dimensional Modeling
• Modeling with BIDS

Lesson 3: Using SSAS in BIDS

• Understanding BIDS
• Creating Data Sources
• Creating Data Source Views
• Creating a Cube Using the Wizard
• Refining Dimensions and Measures

Lesson 4: Intermediate SSAS

• Creating KPIs
• Creating Perspectives
• Creating Translations
• Creating Actions

Lesson 5: Advanced SSAS

• Working with Multiple Fact Tables
• Using Advanced Dimension Types
• Working with Changing Dimensions
• Using the Business Intelligence Wizard

Lesson 6: Cube Storage and Aggregation

• Basic Storage: MOLAP
• Customized Aggregations
• Advanced Storage: MOLAP, HOLAP, or ROLAP
• Implementing Proactive Caching
• Using Partitions: Relational or SSAS
• Cube and Dimensions Processing Options

Lesson 7: Beginning MDX

• Understanding MDX
• About Members, Tuples, and Sets
• Common MDX Functions Explained
• New or Updated MDX Functions or Keywords

Lesson 8: Intermediate MDX

• Understanding the Calculations Subtab
• Adding Calculated Members
• Adding MDX Scripts
• Adding Named Sets
• Adding .NET Assemblies

Lesson 9: SSAS Administration

• Implementing SSAS Security
• Implementing XMLA Scripts
• Understanding SSAS Backup and Restore
• Understanding Clustering
• Understanding Performance Optimization

Lesson 10 Introduction to Data Mining

• Understanding Data Mining Concepts
• Understanding Data Mining Algorithms
• Considering Data Mining Clients
• Understanding Mining Structure Processing

Lesson 11: Introduction to SSAS Clients

• Using Excel 2003 Pivot Tables
• Using SQL Server Reporting Services
• Using .NET 2.0 Report Viewer Controls
• Using SharePoint 2003 Web Parts

Lesson 12: Office 2007 Integration with SSAS

• Implementing SQL Server SP2
• Implementing Excel 2007 Pivot Tables
• Implementing Excel 2007 as a Data Mining Client
• Implementing MOSS BI Features

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com