Contactar
About this course:
This 3 day ILT course focuses on the new features SQL Server 2008 R2 for BI specialists.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.
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.Before attending this course, students must have:
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.
Faculty:
Our team of highly qualified instructors combine training activities with the development of their profession as experts in the field of TIC. Professionals certified by the major manufacturers capable of transferring an enjoyable and easy to understand technical concepts more abstract.Documentation:
A copy of the official Microsoft documentation.Certification:
Lets get the Microsoft official diploma of the course " MOC 10377 - Updating your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2".Course outline:
Overview of SQL Server 2008 R2
1.1 Introduction to SQL Server 2008 R2.
1.2 SQL Server 2008 R2 and SharePoint 2010.
1.3 SQL Server 2008 R2 data Warehousing.
Implementing Self-Service BI with PowerPivot
2.1 Introduction to PowerPivot.
2.2 Power Pivot for Excel 2010.
2.3 Data Analysis Expressions (DAX).
2.4 Power Pivot for SharePoint 2010.
SQL Server 2008 R2 Reporting Services Tool and API Enhancements
3.1 Deploying and Managing Reporting Services.
3.2 Reporting Services Authoring Tool Enhancements.
3.3 Enabling Self-Service BI Through Item Re-Use.
3.4 Developing Custom Reporting Services Solutions.
SQL Server 2008 R2 Report Authoring Enhancements
4.1 Overview of Report Authoring Enhancements.
4.2 Visualizing Data.
4.3 Visualizing Spatial Data with Maps.
Building Complex Event Processing Solutions with StreamInsight
5.1 Introduction to StreamInsight.
5.2 StreamInsight Core Concepts.
5.3 Developing a StreamInsight Solution.
Master Data Services
6.1 Introduction to MDS.
6.2 Key Concepts in Master Data Services.
6.3 Importing and Browsing Data.
6.4 Business Rules.
6.5 Exporting Data to Subscribing Systems.
6.6 Securing Master Data Services.
Introduction to SQL Azure
7.1 Overview of SQL Azure and Cloud Services.
7.2 Using SQL Azure.
7.3 Introduction to “Dallas”.
Managing SQL Server 2008 R2
8.1 Database Server Provisioning by Using SQL Server SysPrep.
8.2 Application Management by Using Data-Tier Applications.
8.3 Managing Multiple Servers by Using Utility Control Points.