|
Training Syllabus
|
NCSQL005
-
Microsoft SQL Server 2008 Analysis Services
|
|
Training ini memberikan pengetahuan dan skill untuk melakukan implementasi sebuah solusi Analysis Services didalam sebuah organisasi. Modul ini membahas bagaimana caranya untuk develop database Analysis Service dan OLAP cube dengan menggunakan Analysis Services Development tools. Selain itu juga dibahas tentang penggunaan Analysis Services
Management dan administrative tools untuk memanage solusi Analysis Services di Microsoft SQL Server 2008
Durasi : 5 hari
- Introduction to Business Intelligence
- OLAP And Analysis Services
- Using Business Intelligence Development Studio
- Data Source and Data Source View
- Creating Dimension
- Creating Cube
- Advanced Measures and Calculations
- Advanced Dimension Design
- Account Intelligence
- Currency Conversion and Multiple Language
- Action and Writeback
- Creating Perspectives and MDX Queries
- Analysis Services Reporting Using Excel 2007
- Analysis Services Reporting Using Reporting Services
- Roles and Administrative Access
- Designing Aggregations
- Partitions and Analysis Services Processing
- Deployment
- Using Windows Reliability and Performance Monitor Tools
- Using SQL Server Profiler Tool
- Dynamic Management Views
|
|
|