• Overview
• Outline
• Schedule

About This Course

Elements of this syllabus are subject to change.

This two-day instructor-led course provides students with the knowledge of the many new and enhanced Microsoft SQL Server business intelligence (BI) features designed to give a students a competitive advantage. These advantages include integrating multiple data sources with Integration Services; enriching data and building complex business analytics with Analysis Services; and writing, managing, and delivering rich reports with Reporting Services.

Audience Profile

This course is intended for IT professionals.

Prerequites

Before attending this course, students must have:

• Basic knowledge of SQL Server

At Course Completion

After completing this course, students will be able to:

• Explain the elements of SQL Server Business Intelligence.
• Input and output data, script to branch control, and configure and deploy packages.
• Create an account and work with measures.
• Scale Analysis Services.
• Use Client Reporting Tools and the web service.
• Create custom OLAP clients.
• Create queries using Analytical MDX.
• Create and execute a package using Integration Services.