Course Description | Outline | SQL Server Training | IT Training

Module 1: Introduction to Microsoft SQL Server Analysis Services

* Overview of Data Analysis Solutions
* Overview of SQL Server Analysis Services
* Installing SQL Server Analysis Services

Lab : Using SQL Server Analysis Services

* (Level 200) Installing SQL Server Analysis Services
* (Level 200) Verifying Installation

Module 2: Creating Multidimensional Analysis Solutions

* Developing Analysis Services Solutions
* Creating Data Sources and Data Source Views
* Creating a Cube

Lab : Creating Multidimensional Analysis Solutions

* (Level 200) Creating a Data Source
* (Level 200) Creating and Modifying a Data Source View
* (Level 200) Creating and Modifying a Cube

Module 3: Working with Cubes and Dimensions

* Configuring Dimensions
* Defining Attribute Hierarchies
* Sorting and Grouping Attributes

Lab : Working with Cubes and Dimensions

* (Level 200) Configuring Dimensions
* (Level 200) Defining Relationships and Hierarchies
* (Level 200) Sorting and Grouping Dimension Attributes

Module 4: Working with Measures and Measure Groups

* Working With Measures
* Working with Measure Groups

Lab : Working with Measures and Measure Groups

* (Level 200) Configuring Measures
* (Level 200) Defining Dimension Usage and Relationships
* (Level 200) Configuring Measure Group Storage

Module 5: Querying Multidimensional Analysis Solutions

* MDX Fundamentals
* Adding Calculations to a Cube

Lab : Querying Multidimensional Analysis Solutions

* (Level 200) Querying a Cube by Using MDX
* (Level 200) Creating a Calculated Member
* (Level 200) Defining a Named Set

Module 6: Customizing Cube Functionality

* Implementing Key Performance Indicators
* Implementing Actions
* Implementing Perspectives
* Implementing Translations

Lab : Customizing Cube Functionality

* (Level 200) Implementing a KPI
* (Level 200) Implementing an Action
* (Level 200) Implementing a Perspective
* (Level 200) Implementing a Translation

Module 7: Deploying and Securing an Analysis Services Database

* Deploying an Analysis Services Database
* Securing an Analysis Services Database

Lab : Deploying and Securing an Analysis Services Database

* (Level 200) Deploying an Analysis Services Database
* (Level 200) Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution

* Configuring Processing
* Logging, Monitoring, and Optimizing an Analysis Services Solution
* Backing Up and Restoring an Analysis Services Database

Lab : Maintaining a Multidimensional Solution

* (Level 200) Configuring Processing
* (Level 200) Implementing Logging and Monitoring
* (Level 200) Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining

* Overview of Data Mining
* Creating a Data Mining Solution
* Validating Data Mining Models

Lab : Introduction to Data Mining

* (Level 200) Creating a Data Mining Structure
* (Level 200) Adding a Data Mining Model
* (Level 200) Exploring Data Mining Models
* (Level 200) Validating Data Mining Models