Anbieterbeschreibung…

Dieser fünftägige Kurs vermittelt detaillierte Kenntnisse in der Gestaltung einer Business Intelligence-Lösung mithilfe von Microsoft SQL Server 2008

Das Seminar dient zur Vorbereitung auf die MCITP-Prüfung 70-452.

Seminar-Inhalte

A. Designing a Business Intelligence Architecture in Microsoft SQL Server 2008|(Overview of BI Concepts-Planning BI Solutions-Planning the Development of a BI Solution-Determining BI Requirements-Determining Architectural Requirements of a BI Solution-Planning the Microsoft BI Environment-Overview of BI Operations Management ) B. Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services|(Planning Data Sources and Destinations-Determining Staging Requirements-Planning SSIS Packages-Planning the Development of SSIS Packages-Designing Data Flow-Planning Data Flow Operations-Extending SSIS Packages with Scripts ) C. Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services|(Designing a Strategy for Logging ETL Operations-Designing a Strategy for Managing Errors-Designing and Implementing Reliable ETL Processes-Designing a Strategy for Deploying and Maintaining SSIS Packages-Designing a Strategy for Optimizing an SSIS Solution ) D. Designing an OLAP Solution Architecture by Using Microsoft SQL Server 2008 Analysis Services|(Overview of an OLAP Solution-Gathering Requirements for an OLAP Solution-Designing a Logical OLAP Solution Architecture-Designing Dimensions-Designing Dimension Relationships-Considerations for Implementing Cubes, KPIs, and Actions-Global Considerations for an SSAS Solution ) E. Designing Physical Storage for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services|(Designing and Implementing Physical Storage for Dimensions-Designing and Implementing a Partitioning Strategy for Relational Data-Designing a Partitioning Strategy for Multidimensional Data-Designing Aggregations ) F. Designing an Administration and Maintenance Strategy for a Microsoft SQL Server 2008 Analysis Services Solution|(Determining SSAS Resource Requirements-Considerations for Providing SSAS Scalability-Considerations for Providing SSAS Availability-Planning and Implementing a Deployment Strategy for an SSAS Solution-Designing a Strategy for Monitoring an SSAS Solution-Securing an SSAS Solution-Designing a Strategy for Optimizing the Performance of SSAS ) G. Designing Effective Queries for an OLAP Solution by Using Microsoft SQL Server 2008 Analysis Services|(Designing Business Driven Calculations by Using MDX-Working with MDX Queries-Exploring MDX Query Context and Execution-Optimizing MDX Queries-Extending Multidimensional Expressions ) H. Designing and Developing a Microsoft SQL Server 2008 Reporting Services Solution Architecture|(Analyzing the Business Requirements for a Reporting Solution-Planning the Architecture for an SSRS Solution-Designing a Data Acquisition Strategy-Planning a Reporting Solution-Designing Report Models-Extending Reporting with Custom Code ) I. Designing a Strategy for Deploying and Managing a Microsoft SQL Server 2008 Reporting Services Solution Architecture|(Planning the Integration of Reports with Applications-Planning Security for a Reporting Solution-Planning Reports Distribution-Designing a Strategy for Managing Report Execution-Designing a Strategy for Optimizing Report Performance-Planning the Administration of SSRS ) J. Designing Data Mining Solutions by Using Microsoft SQL Server 2008|(Fundamentals of Data Mining-Designing a Mining Model and Structure-Designing Strategies for Staging Data-Visualizing Data Mining Results-Testing Mining Models )

Zielgruppen

IT-Professionals, Entwickler

Teilnehmer: Max. 6