Home > Courses Certifications > Data Management > Course 6234 synopsis

6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

Prerequisites: Before attending this course, students must have:

• Conceptual understanding of OLAP solutions.
• Experience navigating the Microsoft Windows Server environment.
• Experience with Windows services (starting and stopping).
• Experience creating service accounts and permissions.
• Experience with Microsoft SQL Server, including:
• SQL Server Agent.
• SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
• SQL Server System tables.
• SQL Server accounts (users and permissions).

Duration: 3 days

 

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

Module 2: Creating Multidimensional Analysis Solutions

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

Module 3: Working with Cubes and Dimensions

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

Module 4: Working with Measures and Measure Groups

• Working With Measures
• Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions

• MDX Fundamentals
• Adding Calculations to a Cube

Module 6: Customizing Cube Functionality

• Implementing Key Performance Indicators
• Implementing Actions
• Implementing Perspectives
• Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• 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

Module 9: Introduction to Data Mining

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