VIEWS: 7 PAGES: 3 POSTED ON: 8/21/2012
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.
Pages to are hidden for
"Implementing and Maintaining Microsoft SQL Server ... - Knowlogy"Please download to view full document