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