IT Training > Database / Business Intelligence > SQL
logo

Designing a Business Intelligence Solution by Using Microsoft SQL Server 2008 – N°50399A

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

Reserve

Course Description

Description

After completing this course, students will be able to:

  • Design a Business Intelligence (BI) architecture in SQL Server 2008. 
  • Design a strategy for implementing the extract, transform, load (ETL) processby using SQL Server 2008 Integration Services (SSIS).
  • Design a strategy for managing packages by using SSIS.
  • Design an online analytical processing (OLAP) solution architecture by using SQL Server 2008 Analysis Services (SSAS).
  • Design a physical storage for an OLAP solution by using SSAS.
  • Design an administration and maintenance strategy for an SSAS solution.
  • Design effective queries for an OLAP solution by using SSAS.
  • Design and develop a SQL Server 2008 Reporting Services (SSRS) solution architecture.
  • Design a strategy for deploying and managing an SSRS solution architecture. 
  • Design data mining solutions by using SQL Server 2008

Prerequisites

Before attending this course, students must have:

  • Knowledge of data warehousing, data marts, and industry-accepted Business Intelligence (BI) methodologies 
  • Conceptual understanding of SQL Server 2005 and SQL Server 2008 components, such as online analytical processing (OLAP), extract, transform, load (ETL), and reporting tools and technologies
  • Experience in developing and implementing cubes at the physical level
  • Experience in working with data transformations
  • Experience in creating star and snowflake schemas at both conceptual and logical levels
  • Experience in writing MDX for customization and querying
  • Fundamental understanding of Microsoft Windows security, such as how groups, delegation of credentials, and impersonation function in a security context
  • Fundamental understanding of Web-based architecture
  • Experience in using the following tools:
  • Microsoft SQL Server BI Development Studio
  • Microsoft SQL Server Management Studio
  • Report Builder and Report Manager
  • Source Code Control (SCC) product
  • Possible experience in using the following tools:
  • Microsoft Office Visio
  • System Monitor

Who Should Attend this course ?

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.

Check also