KT-10337 Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 - Course 10337 Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 - Course 10337


Description: 

About this Course

  • This 3 day ILT course focuses on the new features SQL Server 2008 R2 for BI specialists

Audience Profile

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.  

At Course Completion

After completing this course, students will be able to:

  • Describe the new and enhanced features in SQL Server 2008 R2 that relate to Business Intelligence, describe how SQL Server 2008 R2 can be integrated with Microsoft SharePoint technologies in a BI infrastructure, and describe the options available for implementing large-scale data warehousing solutions built on SQL Server 2008 R2.
  • 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.
  • Integrate data from SQL Azure into a SQL Server BI solution.
  • Describe the new features of SQL Server 2008 R2, and use them to manage BI applications.

 
Click here to view the Course Outline
     
Prerequisite: 
  • Three to four years of experience using SQL Server 2008 BI components
  • Knowledge of relational and multi-dimensional database schemas
  • Experience creating and deploying SQL Server Reporting Services (SSRS) reports
  • Experience debugging, monitoring, and troubleshooting BI solutions
  • Experience working with the Microsoft .NET Framework
  • Experience in using the following tools:
  • Microsoft SQL Server 2008 BI Development Studio
  • Microsoft SQL Server 2008 Management Studio
  • Report Builder and Report Manager
  • Possible experience in using Microsoft Visual Studio

 

 
   
     
Duration: 
3 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.