Microsoft Business Intelligence 2010 Stack
Course Code: 50511
Course Duration: 5 Days
Overview:
This instructor-led course provides participants with the
knowledge and skills to develop Microsoft End-to-End business
solutions using SQL Server 2008 R2 in an integrated environment
with SharePoint 2010 and Office 2010.
The course introduces the participants to Microsoft Unified Data
Model, SQL 2008 R2 Analysis Services, Integration Services,
Reporting Services, Report Builder 3.0, SharePoint 2010
Integration, and the Business Intelligence Center, PerformancePoint
Services, Business Connectivity Services, Dashboard Designer, Excel
Services, Power Pivot and Data Mining.
Who Should Attend
This course is intended for DBAs, Developers and Business
Intelligence Professionals seeking an introduction to the Microsoft
BI Stack whether for new or existing projects or migration to the
Microsoft environment or having a desire to view the new features
in the entire stack.
Course Objectives
After completing this course, students will be able to:
- Describe the Microsoft Business Intelligence stack
- Explain the concept of the Unified Data Model
- Explain what SQL 2008 and the R2 release change in Microsoft BI
and how best to leverage these technologies.
- Gain a good working knowledge of SQL Integration Services and
the Extract Transform and Load (ETL) process
- Create a Report using Report Builder 3.0
- Understand SharePoint Load Integration and Manage Reports with
SharePoint
- Use tools to design reports in either ad-hoc mode or for
distribution once or scheduled on subscriptions
- Discover, design and implement KPIs
- Understand Multidimensional space in SQL Server Analysis
Services
- Explore Excel Services 2010 to successfully implement a "Single
version of the Truth workbook" deployment Using Dashboard
Designer
- Generate Visual Reports and tie them into Dashboards
Course Prerequisites
Before attending this course, participants should have:
- A working knowledge of RDBMS
- A working knowledge of Business Intelligence Studio
- A working knowledge of Excel and the Office Ribbon
- Understanding of the goals of Business Intelligence