Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
Seminar
In Nürnberg
Beschreibung
-
Kursart
Seminar
-
Niveau
Anfänger
-
Methodik
Inhouse
-
Ort
Nürnberg
-
Dauer
3 Tage
Sie verfügen mit der Teilnahme am Seminar über die Kenntnisse wie eine Analysis Solution geplant und entwickelt wird, nicht wie Sie Analysis Services Objekte erstellen oder mit den Entwicklertools umgehen. weiterer Hinweis: Zur Zertifizierung zum MCITP (MS Certified IT Professional) Business Intelligence Developer geeignet. Gerichtet an: Datenbankentwickler, Datenbankdesigner, BI Spezialisten, Führungskräfte
Standorte und Zeitplan
Lage
Beginn
Beginn
Hinweise zu diesem Kurs
sicherer Umgang mit den Komponenten des SQL Server 2005 (OLAP, ETL, Reporting), fundierte Kenntnisse zur Implementierung einer SQL Server 2005 Datenbank mit dem Management Studio, Vertrautheit in Transact SQL
Meinungen
Inhalte
Capturing Business and Technical Requirements
- Planning an Analysis Solution
- Identifying Requirements and Constraints
Designing and Implementing a Logical OLAP Solution Architecture
- Planning an OLAP Solution
- Designing and Implementing Fact and Dimension Tables
- Designing and Implementing Cubes
Designing Physical Storage for a Multidimensional Solution
- Designing Physical Storage
- Partitioning Relational Data
- Partitioning Multidimensional Data
Creating Calculations
- Implementing Calculated Members
- Implementing Named Sets
- Implementing Scoped MDX Scripts
Extending Cube Functionality
- Key Performance Indicators
- Actions
- Stored Procedures
Designing an Analysis Services Infrastructure
- Considerations for Analysis Services Resource Requirements
- Considerations for Analysis Services Scalability
- Considerations for Analysis Services Availability
Deploying a Multidimensional Solution into Production
- Deploying an Analysis Services Database
- Managing Analysis Services Security
Optimizing an OLAP Solution
- Monitoring Analysis Services
- Optimizing Performance
Implementing Data Mining
- Introduction to Data Mining
- Implementing a Data Mining Solution
- Using Data Mining in a BI Solution
Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services