|
|
|
 |
M2074Designing and Implementing OLAP Solutions Using Microsoft? SQL Server 2000
This course the Program of course will help students to acquire necessary knowledge and skills for planning, developments and implantations OLAP of solutions on usage of Microsoft SQL Server 2000 Analysis Services
:
- Introduction in OLAP and Repositories
- Acquaintance to the Wizard of Analytical Tools
- the Architecture of Analytical Tools
- Construction of Dimensions by resources of the Editor
- Additional customizations of Dimension
- Operation with cubes and measures
- the Example of construction of a cube
- the Memory management and optimization
- Processing of Dimensions and cubes
- Handle of fragments of a cube
- Calculations by resources MDX
- Operation with virtual cubes
- Usage EXCEL as OLAP client
- Navigating on a cube
- Protective mechanisms
- Development of technology on base OLAP
- Introduction in the analysis of the data (mining)
- the Example of operation with base Foodmart
Necessary preparation:
Understanding of bases of development of databases, administrations. Knowledge the Microsoft Windows 2000 operating system.
This course will help you to prepare for the next tests:
070-019 Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
Given cource inserted in next comlex programs:
OLAP2000 The complex program of preparation of developers of OLAP-systems on the basis of DB Microsoft SQL Server 2000
Education coast on cource - USD 400
Cource duration (days) - 5
|
|
