MOC 50511 The Microsoft Business Intelligence 2010 Stack

    

Summary:
This instructor-led course provides students 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 students 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.

Duration:
5 days/Lecture & Lab

Audience:
This course is designed for BI Project managers, BI Developers, I.T. Professionals, end-user ombudsman, BI analyst . This course was designed from the perspective of team immersion drawing on the author's 20 plus years in IT and over 10 years in Business Intelligence/OLAP Reporting and dashboard design. This course will expose team members to all aspects of the Microsoft BI stack from the source data through the reporting of the data be it in a subscribed report or through an interactive digital dashboard.

Elevator Pitch:
The intention of this course is to allow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, and the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.

Topics:

• The Business Intelligence Stack
• Unified Data Model
• SQL Server Integration Services
• SQL Server Analysis Services
• SQL Server Reporting Services
• MDX (0ptional)
• PerformancePoint Services 2010
• Excel Services, Business Connectivity Services
• Excel PowerPivot
• Data Mining

Prerequisites:

Students 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

Last Update: May 25, 2013