SQL Server 2005 OLAP - Implementierung

Diese Kurse wenden sich an Entwickler, die BI Lösungen mit SQL Server 2005 entwickeln wollen.

• Describe how SQL Server Analysis Services can be used to implement analytical solutions
• Create multidimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions in an Analysis Services solution
• Implement measures and measure groups in an Analysis Services solution
• Query a multidimensional Analysis Services solution
• Customize an Analysis Services cube
• Deploy and Secure an Analysis Services database
• Maintain a multidimensional Analysis Services solution
• Implement a Data Mining solution

Als Vertiefung empfehlen wir ein MDX-Training. Dies ist zur Zeit nur für SQL Server 2000 (MOC 2093) verfügbar, wird von uns aber gerne mit Bezug auf die neuen Fähigkeiten des SQL Server 2005 durchgeführt.

• Describe SQL Server Integration Services and its tools
• Create an Integration Services package
• Implement control flow in an Integration Services package
• Implement data flow in an Integration Services package
• Implement logging in an Integration Services package
• Debug and implement error handling in an Integration Services package
• Implement checkpoints and transactions in an Integration Services package
• Deploy an Integration Services package
• Manage and secure an Integration Services package

• Describe SQL Server Reporting Services and its components
• Create a Reporting Services report
• Enhance a Reporting Services report
• Create and manipulate data sets
• Use report models to implement reporting for business users
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Administer Reporting Services
• Implement custom Reporting Services applications

Die Schulungsunterlagen sind nur auf Englisch verfügbar.