Zero to BI in 2 Intense Days using MS SQL Server 2005 (Course Code: 154)

Overview:

To keep pace with change, today's organisations need access to up-to-date accurate business data to enable them to make informed and intelligent decisions. This course has been designed to cover the entire life-cycle development of a multi-dimensional data warehouse.

SQL Server 2005 offers an enterprise-ready and proven relational engine that can store vast quantities of data. It supports high query loads, high performance, clustering, and scale to the largest enterprise needs.

SQL Server 2005 provides three core Business Intelligence components:

1. Microsoft SQL Server 2005 Integration Services brings data together from disparate sources. This powerful ETL tool can help you synthesise new data, enrich it for high-performance, and reload it back into SQL Server 2005. Integration Services are built to work in various environments and with virtually any data source.

2. Microsoft SQL Server 2005 Analysis Services adds additional value to your data by placing complex calculations and key performance indicators (KPI’s) into the system. It allows you to enrich your organisation with a centralised and shared business logic. Analysis Services also reorganises data hierarchically to rationalise and supports reporting and analysis needs.

3. Microsoft SQL Server 2005 Reporting Services helps end users retrieve and publish data and make data easily accessible to a large number of users

This course concentrates on the first two components, and highlights new improved aspects of Reporting Services.

Learning Method:

Instructor Led
The training takes place in a hands-on lab environment where you will explore end-to-end data warehousing using Microsoft SQL Server 2005 to deliver Business Intelligence solutions. The course is presented using a combination of instructor presentations, facilitated group discussions and practical exercises. Participants are provided with course notes.

Who will benefit from this course?

• Data analysts
• Data base analyst’s wishing to extend their skill set
• OLAP designers

Pre-requisites:

A basic familiarity with SQL Server 2000/2005 or a similar database system would be helpful.

What can you expect to gain from this course?

At the completion of this course you will have been exposed to and have a greater understanding of:

• the Business Intelligence life-cycle
• the Business Intelligence tools available in SQL Server 2005
• SSIS package designer
• package control and data flow
• data sources and destinations
• basic Analysis Services concepts
• the Analysis Services management tools
• what MDX is used for
• basic data mining concepts
• data mining algorithms
• the data structures used for a Business Intelligence solution.
• SSIS basic and complex tasks.

In addition, you will have obtained the skills to:

• debug a SSIS package
• deploy and execute SSIS
• create cubes
• create dimensions
• create fact tables
• create measures and relationships.

Course Content: