SQL Server Training

End to End Microsoft Business Intelligence. An exploration of the entire stack.

Microsoft 50491

Microsoft Certification

Length:	4 Days
Published:	November 15, 2010
Language(s):	English
Audience(s):	IT Professionals
Level:	200
Technology:	Microsoft SQL Server 2008 R2
Type:	Course
Delivery Method:	Instructor-led (classroom)

About this Course

This instructor-ledcourse 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, Reporting Services Content Types, PerformancePoint Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining

Audience Profile

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.

At Course Completion

After completing this course, students will be able to:

Describe the Microsoft Business Intelligence stack
Explain the Unified Dimension Model and when it can and cannot be used.
Use the new Business Intelligence Features in SQL 2008 R2
Create a SSAS Project using the Microsoft Unified Dimension Model
Create a Data Mart using Business Intelligence Studio
Create a Integration Services project and load a Data Mart
Load a Data Mart from a flat file.
Model Dimensions, Measures and Cubes
Understand the pros and cons of Integration into SharePoint
Create a Report using Report Builder 3.0
Load and Manage Reports with SharePoint
Utilize the Business Intelligence add-ins for Excel
Discover, design and implement KPIs
Understand the role of SQL Server Analysis Services in measurement for KPIs
Implement Time Intelligence features to query such as Year-To-Date, Last 6 Months etc.
Use Excel Services and Excel Workbooks in Scorecards or as a data source
Utilize the document management capabilities of SharePoint 2010 for objects for versioning, document retention and reverting.
Use Dashboard Designer
Gain a generalized understanding of MDX to write basic queries
Generate Visual Reports and tie them into Dashboards
Utilize decomposition trees
Understand what the advantages of having SharePoint as the platform are.
Use dynamic hierarchies in Scorecards
Implement User Menus in Scorecards