SQL Server 2005 OLAP - Projektierung

Diese Kurse wenden sich an erfahrene BI-Entwickler und Projektleiter. Es werden die Kenntnisse des "Doing" vorausgesetzt, die in den Kursen OLAP - Implementierung vermittelt werden.

• Capture the business and technical requirements for a Business Intelligence solution architecture
• Describe the major stages and requirements of a Business Intelligence project lifecycle
• Determine Business Intelligence development requirements and implement a Business Intelligence development project
• Assess and design a Business Intelligence infrastructure
• Describe and plan Business Intelligence operations and their management

• Plan data transfer and staging solutions for an ETL operation
• Plan an SSIS Solution
• Design and implement data flows
• Incorporate logging, error handling, and reliability into a package
• Optimize an SSIS solution
• Deploy and operate an SSIS solution

• Capture the business and technical requirements for an analysis solution
• Design and implement a logical Online Analytical Processing (OLAP) solution architecture
• Design physical storage for a multidimensional solution
• Create calculated members and named sets
• Implement Key Performance Indicators (KPIs), actions, and stored procedures
• Design the infrastructure for an OLAP solution
• Deploy and secure an Analysis Services solution in a production environment
• Monitor and optimize an Analysis Services solution
• Implement a data mining solution

• Design a reporting solution
• Develop a reporting solution
• Collaborate with application developers to complete reporting and analytical interfaces
• Deploy and manage a Reporting Services solution
• Design security for a Reporting Services solution
• Optimize report execution performance

Die Schulungsunterlagen sind nur auf Englisch verfügbar.