SQL Server 2005 Analysis Services Course

Topics covered on the 3 day SQL Server 2005 Analysis Services course

WHAT IS MICROSOFT BUSINESS INTELLIGENCE?

• Defining Microsoft Business Intellignece
• Why Use OLAP?
• Understanding the UDM
• Dimensions and Measures
• OLAP Schemas
• Building and Viewing a Sample Cube
• The AdventureWorksDW Source Database
• Building a Cube with BIDS
• Viewing the Results in BIDS
• Viewing the Results Using Excel
• Cubes in Reporting Services

OLAP MODELING

• Selecting a Modeling Tool
• Understanding OLAP Modeling
• Understanding Dimensional Modeling
• Dimension Types
• Understanding Cube Modeling
• Modeling with BIDS
• Understanding the BIDS Interface
• Two Ways to Build a Model
• A Note about ETL

USING SSAS IN BIDS

• Understanding BIDS
• Offline vs. Online Mode
• Creating Data Sources
• Creating Data Source Views
• Creating a Cube Using the Wizard
• Refining Dimensions and Measures
• Working with Your Cube

INTERMEDIATE SSAS

• Creating KPIs
• How KPIs are Implemented in SSAS
• Customizing the KPI Templates
• Other KPI Considerations
• Creating Perspectives
• Creating Translations
• Localizing Measure Values
• Currency Localization
• Creating Actions

ADVANCED SSAS

• Working with Multiple Fact Tables
• Linked Objects
• Dimension Usage Configurations
• Using Advanced Dimension Types
• Snowflake Dimensions
• Degenerate Dimensions
• Parent-Chile Dimensions
• Many-to-Many Dimensions
• Role Playing Dimensions
• Writeback Dimensions
• Working with Changing Dimensions
• More about Error Handling for Dimension Attribute Loads
• Using the Business Intelligence Wizard

CUBE STORAGE AND AGGREGATION

• Basic Storage: MOLAP
• About XMLA
• Three Storage Modes
• About Aggregations
• Customizing Aggregations
• Using Profiler
• Advanced Storage: MOLAP, HOLAP, or ROLAP
• Using Partitions with Advanced Storage Options
• ROLAP Dimensions
• Implementing Proactive Caching
• Notification Settings for Proactive Caching
• Fine Tuning Proactive Caching
• Using Partitions: Relational or SSAS
• Relational Table Partitioning in SQL Server 2005
• How to Implementing OLTP Partitioning
• Other Capabilities of OLAP Partitions
• Cube and Dimension Processing Options

BEGINNING MDX

• Understanding MDX
• MDX Structure Names
• MDX Syntax Rules
• Writing your First MDX Query
• About Members, Tuples, and Sets
• Common MDX Functions Explained
• New or Updated MDX Functions and Keywords

INTERMEDIATE MDX

• Understanding the Calculations Subtab
• Adding Calculated Members
• Examine a Calculated Measure
• Why Use Calculated Members?
• Adding MDX Scripts
• Adding Named Sets
• Adding .NET Assemblies
• Why Use External Assemblies?

SSAS ADMINISTRATION

• Implementing SSAS Security
• Reducing the Attack Surface
• Data Source Connection Methods
• Implementing Cube Roles
• Other Security Considerations
• Implementing XMLA Scripts
• SSAS Database Synchronization
• Understanding SSAS Backup and Restore
• Understanding Clustering
• Improving Scalability
• Understanding Performance Optimization

INTRODUCTION TO DATA MINING

• Understanding Data Mining Concepts
• About Algorithms
• More Data Mining Concepts
• Implementing Algorithms
• Reviewing Data Mining Structures
• Mining Structure Subtab
• Mining Model Properties
• Decision Tree Viewer
• Dependency Network Viewer
• Naïve Bayes Viewer
• Mining Accuracy Charts
• Mining Prediction Viewers
• Understanding Data Mining Algorithms
• Content and Data Types
• Other Model Properties
• Considering Data Mining Clients
• Understanding Mining Structure Processing
• Using SSIS to Process Mining Models
• SSIS and Data Mining
• Working with the DMX (Data Mining Extensions) Language
• A Simple DMXQuery

INTRODUCTION TO SSAS CLIENTS

• Using Excel 2003 Pivot Tables
• Pivot Charts
• The Limits of Excel 2003 as a BI Client
• Using SQL Server Reporting Services
• Build and SSRS Report
• Write and MDX Query
• View the SSRS Report
• Design the SSRS Report
• Deploy the SSRS Report
• Report Builder
• Using .NET 2.0 Report Viewer Controls
• Using SharePoint 2003 Web Parts
• Business Scorecard Manager 2005
• Data Mining Clients

OFFICE 2007 INTEGRATION WITH SSAS

• Implementing SQL Server SP2
• SSAS SP2
• Implementing Excel 2007 Pivot Tables
• Excel 2007 Pivot Charts
• Implementing Excel 2007 as a Data Mining Client
• Configuring the Add-In
• Using Excel 2007 as a Data Mining Client
• Using the Query Function
• Using the Data Preparation Menu
• Using the Data Modeling Menu
• Using the Accuracy and Validation Menu
• Implementing MOSS BI Features
• Excel 2007 Web Services
• MOSS Data Connection Libraries
• MOSS KPIs
• Other MOSS BI Capabilities
• Performance Point Server (PPS)