MS SQL Server 2008 for BI

This course focuses on the new features SQL Server 2008 R2 for BI specialists. BI Professionals who have 3-4 years of experience with SQL Server. This audience has an understanding of how to use SQL Server 2008 BI tools to implement a BI infrastructure

After completing this course, students will be able to: Install and configure PowerPivot for Excel and PowerPivot for SharePoint. Use PowerPivot for Excel to create a PowerPivot workbook. Use Data Analysis Expressions to build formulas in PowerPivot. Use PowerPivot for SharePoint to manage PowerPivot workbooks. Use the enhanced Reporting Services management tools Use the enhanced Reporting Services authoring tools Collaborate with other report developers by using shared datasets and report parts Use the enhanced Reporting Services development API Create reports that include visualizations of spatial data Describe scenarios where Complex Event Processing can be used effectively Describe the core concepts related to Microsoft StreamInsight Create a StreamInsight Application Use Filters and Aggregates Implement MDS Business Rules Export MDS data Secure MDS Create a Business Rule Exporting Data to a Subscribing System Use the Dallas cloud-data service Use the StreamInsight Debugger Use Utility Control Points to manage BI database server resource utilization

Mode of delivery: Fully instructor-led classroom training
Duration:  35 hours

For more information click Course Details