|
Provided by: Ahana Systems and Solutions (P) Ltd SQL Server 2005 Analysis Services Training |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
SQL Server 2005: Analysis Services Training
|
|
||||||||||
SQL Server 2005 Analysis Services Training
MSSQL Server 2005: Implementing and Maintaining SQL Server 2005 Analysis Services (SSAS)
SQL Server 2005: Analysis Services
Module 1: Introduction to Microsoft SQL Server 2005 Analysis Services
Introduces common analysis scenarios and describes how Analysis Services provides a powerful platform for multidimensional OLAP solutions and data mining solutions. The module then describes the main considerations for installing Analysis Services.
Module 2: Creating Multidimensional Analysis Solutions
Introduces the development tools you can use to create an Analysis Services multidimensional analysis solution, and describes how to create data sources, data source views, and cubes.
Module 3: Working with Dimensions
Describes how to edit dimensions and to configure dimensions, attributes, and hierarchies.
Module 4: Working with Measures and Measure Groups
Explains how to edit and configure measures and measure groups.
Module 5: Querying Multidimensional Analysis Solutions
Introduces multidimensional expressions (MDX) and describes how to implement calculated members and named sets in an Analysis Services cube.
Module 6: Customizing Cube Functionality
Explains how to customize a cube by implementing key performance indicators (KPIs), actions, perspectives, and translations.
Module 7: Deploying and Securing an Analysis Services Database
Describes how to deploy an Analysis Services database to a production server, and how to implement security in an Analysis Services multidimensional solution.
Module 8: Maintaining a Multidimensional Solution
Discusses the maintenance tasks associated with an Analysis Services solution, and describes how administrators can use the Analysis Services management tools to perform them.
Module 9: Introduction to Data Mining
Introduces data mining, and describes how to implement data mining structures and models. It then explains how to validate data model accuracy.
SQL Server 2005: Analysis Services
Module 1: Introduction to Microsoft SQL Server 2005 Analysis Services
Introduces common analysis scenarios and describes how Analysis Services provides a powerful platform for multidimensional OLAP solutions and data mining solutions. The module then describes the main considerations for installing Analysis Services.
Module 2: Creating Multidimensional Analysis Solutions
Introduces the development tools you can use to create an Analysis Services multidimensional analysis solution, and describes how to create data sources, data source views, and cubes.
Module 3: Working with Dimensions
Describes how to edit dimensions and to configure dimensions, attributes, and hierarchies.
Module 4: Working with Measures and Measure Groups
Explains how to edit and configure measures and measure groups.
Module 5: Querying Multidimensional Analysis Solutions
Introduces multidimensional expressions (MDX) and describes how to implement calculated members and named sets in an Analysis Services cube.
Module 6: Customizing Cube Functionality
Explains how to customize a cube by implementing key performance indicators (KPIs), actions, perspectives, and translations.
Module 7: Deploying and Securing an Analysis Services Database
Describes how to deploy an Analysis Services database to a production server, and how to implement security in an Analysis Services multidimensional solution.
Module 8: Maintaining a Multidimensional Solution
Discusses the maintenance tasks associated with an Analysis Services solution, and describes how administrators can use the Analysis Services management tools to perform them.
Module 9: Introduction to Data Mining
Introduces data mining, and describes how to implement data mining structures and models. It then explains how to validate data model accuracy.
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...
