MS50399

Ladda ner som PDF

Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008

This five-day instructor-led course provides in-depth knowledge on designing a Business Intelligence solution by using Microsoft SQL Server 2008.

Audience:

The primary audience for this course is developers who have knowledge of Business Intelligence (BI) concepts, with an experience of 4-5 years in BI. The audience has an understanding of how to use SQL Server 2005 BI tools to implement a BI infrastructure and solution. However, the audience needs to develop an understanding of design principles and best practices when designing a BI solution. The target audience also includes BI developers with experience in using SQL Server 2008 BI features and tools, and who want to obtain a professional certification in BI development and design.  The secondary audience for this course is information technology (IT) professionals, and Business Analysts who specialize in the area of BI.

Course Outline:

Module 1: 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

Module 2: 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

Module 3: Designing a Strategy for Managing Packages by Using Microsoft SQL Server 2008 

  • 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

Module 4: 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

Module 5: 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

Module 6: 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

Module 7: 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

Module 8: 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

Module 9: 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

Module 10: 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

Förkunskaper

The primary audience for this course is developers who have knowledge of Business Intelligence (BI) concepts, with an experience of 4-5 years in BI

Kursmaterial

Microsofts officiella elektroniska kursmaterial på engelska ingår.

Utbildningen levereras i samarbete med

Kurs-ID: MS50399
Längd: 5 dagar
Kan betalas med:
TRAINING CARD SA-VOUCHER

Lämna dina kontaktuppgifter om du önskar en företagsintern utbildning.