50008A: SQL Server Business Intelligence
Introduction
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
This course is intended for IT professionals.
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