To speak to a training advisor please call

0800 40 848 40

training@coursemonster.com

All Courses / Microsoft Courses / Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 (M6234-6235-6236)

Share: Follow us:

Bookmark with:

Print Page:

Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 (M6234-6235-6236)

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

The purpose of this instructor-led course is to teach Business Intelligence (BI) Professionals working in enterprise environments to design and mangae a multidimensional architeture that supports their BI solution.

The course consists of three parts: SQL Analysis services, SQL Integration services, SQLReporting services.

Also applicable for people who use SQL 2005

Save hours of endless web browsing for the right course, if this Microsoft training course isn't suitable, use our advanced search function and you could be attending your next Microsoft training course in 3 simple clicks.

Related Courses

Audience

Business Intelligence Development Studio
Management Studio
Performance Monitor
Server Profile

Skills Gained

SQL Server Analysis Services

Here students will be taught to design, create and manage cubes, dimensions, KPI, data mining models. Students will also learn how to use MDX, how to extend the functionality of a cube with MDXscripts and actions. We will also teach how to partition cubes, how to process cubes and dimensions and how to create an aggreagation design for partitions. Performance optimization and maintenance of a multidimensional database is also part of the curriculum.

SQL Server Integration Services

Here students will be taught to design an ETL (Extract Transform and Load) solution that supports their BI Solution. Students will also learn how to create a dataflow task and work with sources, transformations and destinations. In addition the use of scripting to extend the functionality of SSIS will be taught. Finally optimizing a SSIS solution and deploying it is also taught.

SQL Server Reporting Services

Students will learn how to design a reporting services solution that supports their BI solution. Students will go through the entire process of authoring their reports, deploying and managing of their reports and finally rendering of the report. Students will be taught how to optimize the execution of reports and how to secure reports. Finally students will also learn how to use reports models to allow end users to do ad hoc reporting.

Prerequisites

Creating Transact-SQL queries
Writing and optimizing advanced queries (for example, queries that contain complex joins or subqueries)
Creating database objects such as tables, views, and indexes
Be familiar with SQL Server 2008 features, tools, and technologies.
Have foundational conceptual understanding of data warehousing, data marts, and Business Intelligence.
Have foundational understanding of Microsoft Windows security. For example, how groups, delegation of credentials, and impersonation function in a security context.
Have a conceptual understanding of OLAP technologies, multidimensional data, MDX, and relational database modeling. For example, know what facts, dimensions, measures, calculated measures, and foreign keys are.
Have foundational understanding of Web-based architecture. For example, SSL, SOAP, IIS