Corso Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 2008 SpecialistThecla Informatica
Chiedi il prezzo
Cosa impari in questo corso?
Microsoft SQL Server
Nessun prerequisito richiesto Module 1: SQL Server 2008 R2 for BI Professionals This module discusses the key themes and features of the SQL Server 2008 R2 release, and the business issues that it was designed to address. It then discusses integration between SQL Server 2008 R2 and SharePoint technologies before introducing data warehousing in SQL Server 2008 R2. Lessons Introduction to SQL Server 2008 R2 SQL Server 2008 R2 and SharePoint 2010 SQL Server 2008 R2 data Warehousing After completing this module, students will be able to: Identify the key features and scenarios addressed by SQL Server 2008 R2. Describe the ways in which SQL Server 2008 R2 and SharePoint 2010 can be integrated to create a comprehensive self-service BI platform. Identify the options available for data warehousing with SQL Server and describe the key features of SQL Server 2008 R2 Parallel Data Warehouse. Module 2: Implementing Self-Service BI with PowerPivot This module introduces PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010 and describe how they can be used to empower business users to create their own business analyses by using familiar tools. Lessons Introduction to PowerPivot Power Pivot for Excel 2010 Data Analysis Expressions (DAX) Power Pivot for SharePoint 2010 Lab : Implementing Self-Service BI with PowerPivot Using PowerPivot for Excel 2010 Using PowerPivot for SharePoint After completing this module, 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. Module 3: SQL Server 2008 R2 Reporting Services Tool and API Enhancements This module describes the enhancements to Reporting Services tools and APIs in SQL Server 2008 R2 (enhanced reporting functionality is covered in the next module; this module is specifically focused on changes to the management and development tools and APIs). Lessons Deploying 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 Viewing and Managing Reports Using Report Builder 3.0 Working with Shared Datasets and Report Parts After completing this module, students will be able to: 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 APIs Module 4: SQL Server 2008 R2 Report Authoring Enhancements This module describes the enhancements to Reporting Services in SQL Server 2008 R2. Lessons Overview of Report Authoring Enhancements Visualizing Data Visualizing Spatial Data with Maps Lab : Authoring Reports Using Lookups Paginating Reports Visualizing Data with Databars and Sparklines Visualizing Data with Indicators Visualizing Spatial Data After completing this module, students will be able to: Use new features to create reports that include rotated text boxes, linked data from multiple datasets, include rollup aggregations, and custom pagination behavior. Create reports that include graphic visualizations of data with Sparklines, Data Bars, and Indicators. Create reports that include visualizations of spatial data. Module 5: Building Complex Event Processing Solutions with StreamInsight This module introduces StreamInsight with an emphasis on its use to enable analytical solutions for real-time streams of data. Lessons Introduction to StreamInsight StreamInsight Core Concepts Developing a StreamInsight Solution Lab : Building a StreamInsight Solution Creating a StreamInsight Application Using Filters and Aggregates Using the StreamInsight Debugger After completing th Corso di gruppo Corso personalizzato (1 o 2 partecipanti) 24 ore 24 ore (consigliate) min. 5 - max. 10 partecipanti 2 persone: sconto del 50% Corso individuale a distanza su VoIP non previsto