Course Description
This course focuses on the new features SQL Server 2008 R2 for BI specialists.
After completing this course, students will be able to:
- Describe the new
features of SQL Server 2008 R2, and use them to manage BI applications.
-
Use SQL Server PowerPivot to create self-service BI solutions
- Use new and
enhanced Reporting Services tools to create and manage self-service reporting
solutions
- Use new report features to create compelling reports
- Use
StreamInsight to create an application that captures and analyzes streams of
event data.
- Use Master Data Services to enable data consistency across the
enterprise to help increase the accuracy of BI solutions.
- Describe the
options available for implementing large-scale data warehousing solutions built
on SQL Server 2008 R2.
- Integrate data from SQL Azure into a SQL Server BI
solution
Agenda
Lesson 1: SQL Server 2008 R2 for BI ProfessionalsIntroduction to SQL Server 2008 R2
SQL Server 2008 R2 and SharePoint 2010
Database Server Provisioning by Using SQL Server SysPrep
Application Management by Using Data-Tier Applications
Managing Multiple Servers by Using Utility Control Points
Lab : Managing SQL Server 2008 R2
Lesson 2: Implementing Self-Service BI with PowerPivotIntroduction to PowerPivot
Power Pivot for Excel 2010
Data Analysis Expressions (DAX)
Power Pivot for SharePoint 2010
Lab : Implementing Self-Service BI with PowerPivot
Lesson 3: SQL Server 2008 R2 Reporting Services Tool and API EnhancementsDeploying and Managing Reporting Services
Reporting Services Authoring Tool Enhancements
Enabling Self-Service BI Through Item Re-Use
Developing Custom Reporting Services Solutions
Lab : Working with Reporting Services
Lesson 4: SQL Server 2008 R2 Report Authoring EnhancementsOverview of Report Authoring Enhancements
Visualizing Data
Visualizing Spatial Data with Maps
Lab : Authoring Reports
Lesson 5: Building Complex Event Processing Solutions with StreamInsightIntroduction to StreamInsight
StreamInsight Core Concepts
Developing a StreamInsight Solution
Lab : Building a StreamInsight Solution
Lesson 6: Master Data ServicesIntroduction to MDS
Key Concepts in Master Data Services
Importing and Browsing Data
Business Rules
Exporting Data to Subscribing Systems
Securing Master Data Services
Lab : Working with Master Data Services
Lesson 7: Enterprise Data WarehousingSQL Server 2008 R2 Data Warehousing
Overview of Parallel Data Warehouse
Lesson 8: Introduction to SQL AzureOverview of SQL Azure and Cloud Services
Using SQL Azure
Introduction to “Dallas”
Audience
The primary audience for this course is BI Professionals who have 3-4 years of
experience with SQL Server. The audience has an understanding of how to use SQL
Server 2008 BI tools to implement a BI infrastructure and solution.
Comments
Virtual 10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet.
The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.
There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.
This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students.
You will hear and see your instructor as they teach the course and answer your questions via voice or text.
Choose the online live virtual training option and you can access the recorded version even after the class has finished.
The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.
Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.