- Price: $2070.00
This course provides students with the knowledge and skills to implement an Analysis Services solution in their organisation. In addition, students will learn to use the Analysis Services development tools to create an Analysis Services database and OLAP cubes. Furthermore, students will also be able to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
After completing this course, students will be capable of describing how SQL Server Analysis Services can be used to implement analytical solutions as well as creating multidimensional analysis solutions with SQL Server Analysis Services. Students will also be skilled in customising an Analysis Services cube and deploying and securing an Analysis Services database.
Microsoft Certifications – Overview
Microsoft Learning Paths
Microsoft Training FAQs
This course is intended for Information Technology Professionals and Developers who need to implement analysis solutions by using Microsoft SQL Server 2005 Analysis Services.
Students must have a conceptual understanding of OLAP solutions. They should also have experience navigating the Microsoft Windows Server environment and starting and stopping the Windows services. In addition, students should have experience with creating service accounts and permissions as well as with Microsoft SQL server including SQL server Agent, server query language, server system tables and server accounts.
I. Introduction to Microsoft SQL Server 2005 Analysis Services
II. Creating Multidimensional Analysis Solutions
III. Working with Dimensions
IV. Working with Measures and Measure Groups
V. Querying Multidimensional Analysis Solutions
VI. Customising Cube Functionality
VII. Deploying and Securing an Analysis Services Database
VIII. Maintaining a Multidimensional Solution
IX. Introduction to Data Mining