Implementing and Maintaining Microsoft SQL Server ... - Knowlogy by wuyunyi

VIEWS: 7 PAGES: 3

									Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Course MS6234    3 Days



►      COURSE OVERVIEW                                     ►      PREREQUISITES
 This three-day instructor-led course teaches students     Before attending this course, students must have:
 how to implement an Analysis Services solution in an       • Conceptual understanding of OLAP solutions.
 organization. The course discusses how to use the          • Experience navigating the Microsoft Windows
 Analysis Services development tools to create an              Server environment.
 Analysis Services database and an OLAP cube, and           • Experience with Windows services (starting and
 how to use the Analysis Services management and               stopping).
 administrative tools to manage an Analysis Services        • Experience creating service accounts and
 solution.                                                     permissions.
                                                            • Experience with Microsoft SQL Server, including:
►      AUDIENCE                                             • SQL Server Agent.
                                                            • SQL Server query language (SELECT,
 The primary audience for this course is individuals who       UPDATE, INSERT, and DELETE).
 design and maintain business intelligence solutions for    • SQL Server System tables.
 their organization. These individuals work in              • SQL Server accounts (users and permissions).
 environments where databases play a key role in their
 primary job and may perform database administration        In addition, it is recommended, but not required, that
 and maintenance as part of their primary job               students have completed:
 responsibilities.                                          • Course MS6231: Maintaining a Microsoft SQL
                                                              Server 2008 Database.
 The secondary audience for this course is individuals      • Course MS6232: Implementing a Microsoft SQL
 who develop applications that deliver content from           Server 2008 Database.
 SQL Server Analysis Services to the organization.

►      OBJECTIVES                                          ►      COURSE OUTLINE
 After completing this course, students will be able to:    Module 1: Introduction to Microsoft SQL Server
                                                            Analysis Services
 • Describe how SQL Server Analysis Services can
   be used to implement analytical solutions.               This module introduces common analysis scenarios
 • Create multidimensional analysis solutions with          and describes how Analysis Services provides a
   SQL Server Analysis Services.                            powerful platform for multidimensional OLAP solutions
 • Implement dimensions and cubes in an Analysis            and data mining solutions. The module then describes
   Services solution.                                       the main considerations for installing Analysis
 • Implement measures and measure groups in an              Services.
   Analysis Services solution.
 • Query a multidimensional Analysis Services               Lessons
   solution.                                                • Overview of Data Analysis Solutions
 • Customize an Analysis Services cube.                     • Overview of SQL Server Analysis Services
 • Deploy and secure an Analysis Services                   • Installing SQL Server Analysis Services
   database.
 • Maintain a multidimensional Analysis Services            Lab: Using SQL Server Analysis Services
   solution.                                                • Installing SQL Server Analysis Services
 • Implement a Data Mining solution.                        • Verifying Installation
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Course MS6234    3 Days



 After completing this module, students will be able       After completing this module, students will be able to:
 to:                                                       • Configure dimensions.
 • Describe data analysis solutions.                       • Define hierarchies.
 • Describe the key features of SQL Server Analysis        • Sort and group attributes.
   Services.
 • Install SQL Server Analysis Services.                   Module 4: Working with Measures and Measure
                                                           Groups
 Module 2: Creating Multidimensional Analysis
 Solutions                                                 This module explains how to edit and configure
                                                           measures and measure groups.
 This module introduces the development tools you can
 use to create an Analysis Services multidimensional       Lessons
 analysis solution, and describes how to create data       • Working With Measures
 sources, data source views, and cubes.                    • Working with Measure Groups

 Lessons                                                   Lab: Working with Measures and Measure Groups
 • Developing Analysis Services Solutions                  • Configuring Measures
 • Creating Data Sources and Data Source Views             • Defining Dimension Usage and Relationships
 • Creating a Cube                                         • Configuring Measure Group Storage

 Lab: Creating Multidimensional Analysis Solutions         After completing this module, students will be able to:
 • Creating a Data Source                                  • Work with measures.
 • Creating and Modifying a Data Source View               • Work with measure groups.
 • Creating and Modifying a Cube
                                                           Module 5: Querying Multidimensional Analysis
 After completing this module, students will be able to:   Solutions
 • Develop Analysis Services solutions.
 • Create a data source and a data source view.            This module introduces multidimensional expressions
 • Create a cube.                                          (MDX) and describes how to implement calculated
                                                           members and named sets in an Analysis Services
 Module 3: Working with Cubes and Dimensions               cube.

 This module describes how to edit dimensions and to       Lessons
 configure dimensions, attributes, and hierarchies.        • MDX Fundamentals
                                                           • Adding Calculations to a Cube
 Lessons
 • Configuring Dimensions                                  Lab: Querying Multidimensional Analysis
 • Defining Attribute Hierarchies                          Solutions
 • Sorting and Grouping Attributes                         • Querying a Cube by Using MDX
                                                           • Creating a Calculated Member
 Lab: Working with Cubes and Dimensions                    • Defining a Named Set
 • Configuring Dimensions
 • Defining Relationships and Hierarchies                  After completing this module, students will be able
 • Sorting and Grouping Dimension Attributes               to:
                                                           • Describe Multidimensional Expression (MDX)
                                                             fundamentals.
                                                           • Add calculations to a cube.
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
Course MS6234    3 Days



 Module 6: Customizing Cube Functionality                  Module 8: Maintaining a Multidimensional Solution

 This module explains how to customize a cube by           This module discusses the maintenance tasks
 implementing key performance indicators (KPIs),           associated with an Analysis Services solution, and
 actions, perspectives, and translations.                  describes how administrators can use the Analysis
                                                           Services management tools to perform them.
 Lessons
 • Implementing Key Performance Indicators (KPI)           Lessons
 • Implementing Actions                                    • Configuring Processing
 • Working with Perspectives                               • Logging, Monitoring, and Optimizing an Analysis
 • Working with Translations                                 Services Solution
                                                           • Backing Up and Restoring an Analysis Services
 Lab: Customizing Cube Functionality                         Database
 • Implementing a KPI
 • Implementing an Action                                  Lab: Maintaining a Multidimensional Solution
 • Implementing a Perspective                              • Configuring Processing
 • Implementing a Translation                              • Implementing Logging and Monitoring
                                                           • Backing Up and Restoring an Analysis Services
 After completing this module, students will be able to:     Database
 • Implement Key Performance Indicators (KPIs).
 • Implement actions.                                      After completing this module, students will be able to:
 • Implement perspectives.                                 • Configure processing settings.
 • Implement translations.                                 • Log, monitor, and optimize an Analysis Services
                                                             solution.
 Module 7: Deploying and Securing an Analysis              • Back up and restore an Analysis Services
 Services Database                                           database.

 This module describes how to deploy an Analysis           Module 9: Introduction to Data Mining
 Services database to a production server, and how to
 implement security in an Analysis Services                This module introduces data mining, and describes
 multidimensional solution.                                how to implement data mining structures and models.
                                                           It then explains how to validate data model accuracy.
 Lessons
 • Deploying an Analysis Services Database                 Lessons
 • Securing an Analysis Services Database                  • Overview of Data Mining
                                                           • Creating a Data Mining Solution
 Lab: Deploying and Securing an Analysis Services          • Validating Data Mining Models
 Database
 • Deploying an Analysis Services Database                 Lab: Introduction to Data Mining
 • Securing an Analysis Services Database                  • Creating a Data Mining Structure
                                                           • Adding a Data Mining Model
 After completing this module, students will be able to:   • Exploring Data Mining Models
 • Deploy an Analysis Services database.                   • Validating Data Mining Models
 • Secure an Analysis Services database.
                                                           After completing this module, students will be able to:
                                                           • Describe data mining.
                                                           • Create a data mining solution.
                                                           • Validate data mining models.

								
To top