Corso Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008 2008 Specialist

Nessun prerequisito richiesto Module 1: Designing a Business Intelligence Architecture in Microsoft SQL Server 2008 This module explains basic BI concepts to the student and provides the framework to start planning and designing for a BI infrastructure. This includes getting to know the various BI methodologies, Microsoft’s BI vision, common terminologies used in a BI environment, and gathering system and organizational requirements. The module also introduces the various Microsoft BI tools available, which can be used both in the front-end and back-end of a BI solution. Lessons 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 Lab : Designing a Business Intelligence Architecture in Microsoft SQL Server 2008 Determining Business Requirements for a BI Solution Designing the Architecture for a BI Solution Creating a Test Environment for a BI Solution After completing this module, students will be able to: Describe BI concepts. Plan a BI solution. Plan the development of a BI solution. Determine BI requirements. Determine architectural requirements of a BI solution. Plan the Microsoft BI environment. Describe the overview of BI operations management. Module 2: Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services This module introduces you to designing extract, transform, and load (ETL) packages by using SQL Server 2008 Integration Services (SSIS). This module covers information on how to create an ETL package to extract source data from multiple heterogeneous systems, apply transformations to the ETL package, and load it in data marts or data warehouses. Lessons 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 Lab : Designing a Strategy for Implementing ETL by Using Microsoft SQL Server 2008 Integration Services Designing Data Flow Logic Implementing Control and Data Flow Modifying the Package to Work with Incremental Loads Determining a Strategy for Scrubbing Data After completing this module, students will be able to: Plan data sources and destinations. Determine staging requirements. Plan SSIS packages. Plan the development of SSIS packages. Design data flow. Plan data flow operations. Extend SSIS packages with scripts. Module 3: Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services This module describes how to design a management and deployment strategy for packages. Once a data warehouse has been created by using an ETL package, the next step is to build an OLAP database and OLAP cubes to aggregate the data. Lessons 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 Lab : Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 Integration Services Designing a Package Management Strategy Implementing Package Configurations Implementing an Error-Handling Strategy Implementing a Logging Strategy Implementing Reliability by Using Transactions After completing this module, students will be able to: Design a strategy for logging ETL operations. Design a strategy for managing errors. Design and implementing reliable ETL processes. Design a strategy for deploying and maintaining SSIS packages. Design a strategy for optimizing an SSIS solution. Module 4: Designing an OLAP Solution Architecture by Using Microsoft SQL Server 2008 Analysis Services This module explains what an OLAP solutio