Updating your Business Intelligence Skills to Microsoft SQL Server 2012
€1440, aangeboden door Master it Training
Deze training biedt bestaande SQL Server Business Intelligence professionals kennis en vaardigheden voor het toepassen van de vernieuwde en verbeterde BI mogelijkheden binnen SQL Server 2012.Na afronding van deze training kun je: De nieuwe en verbeterde functionaliteiten voor BI binnen SQL Server2012 beschrijven; De nieuwe en verbeterde mogelijkheden binnen SQL Server Data Integration Services gebruiken; Data kwaliteit beheren met de SQL Server Data Quality Services; Master data beheren met de nieuwe en verbeterde functionaliteiten van SQL Server Master Data Services; De nieuwe en verbeterde functionaliteiten van SQL Server Reporting Services toepassen; Tabellarische data modellen maken met PowerPivot en DAX; Tabellarische data modellen implementeren in SQL Server Analyse Services; Power View gebruiken voor het maken van interactieve data visualisaties; Microsoft cloud technologieën integreren in een BI solution.
Let op. Deze training is exclusief het examen.
Doelgroep
Deze training is bedoeld voor BI professionals met ervaring in het werken met SQL Server 2008 R2.
Voorkennis voor de Updating your Business Intelligence Skills to Microsoft SQL Server 2012 training
Voor deelname aan deze training die je:Ervaring te hebben met maken van database solutions in SQL Server, waaronder basis TransactSQL programmeren;Bekend te zijn met data warehousing en BI solutions, waaronder data selecteren, transformeren en laden (ETL), modelleren en rapporteren.
Onderwerpen in de Updating your Business Intelligence Skills to Microsoft SQL Server 2012 training
Module 1: Introduction to SQL Server 2012 for Business IntelligenceThis module provides an overview of how SQL Server 2012 can be used to build BI solutions.Lessons Overview of SQL Server 2012 for Business Intelligence SQL Server 2012 for Enterprise Integration Management SQL Server 2012 for Data Warehousing SQL Server 2012 for Data Analysis and ReportingAfter completing this module, students will be able to: Describe the role of SQL Server in a BI solution. Describe features of SQL Server 2012 that support enterprise information management. Describe features of SQL Server 2012 that support data warehousing. Describe features of SQL Server 2012 that support data analysis and reporting.Module 2: New and Enhanced Features in SQL Server Integration ServicesThis module describes the new and enhanced features in SQL Server Integration Services that can be used to create an ETL solution to load a data warehouse.Lessons Using the CDC Control Task for Incremental Data Loads Deploying and Operating SSIS PackagesLab : Using SQL Server Integration Services Extracting Modified Data Deploying and Operating an SSIS ProjectAfter completing this module, students will be able to: Use the CDC Control task to perform incremental data extractions in an ETL solution. Deploy and operate an SSIS project.Module 3: Data Quality ServicesThis module provides an introduction to SQL Server Data Quality Services, and teaches you how to build knowledge based data quality solutions for cleansing and matching data.Lessons Introduction to Data Quality Using Data Quality Services to Cleanse Data Using Data Quality Services to Match DataLab : Cleansing Data Creating a DQS Knowledge Base Using a DQS Project to Cleanse Data Using DQS in an SSIS PackageLab : Deduplicating Data Creating a Matching Policy Using a DQS Project to Match DataAfter completing this module, students will be able to: Describe how Data Quality Services can help you manage data quality. Use Data Quality Services to cleanse data. Use Data Quality Services to match data.Module 4: Master Data ServicesThis module provides an introduction to master data management with SQL Server 2012 Master Data Services.Lessons Introduction to Master Data Services Implementing a Master Data Services Model Managing Master Data Creating a Master Data HubLab : Implementing Master Data Services Creating a Master Data Services Model Using the Master Data Services Addin for Excel Enforcing Business Rules Loading Data into a Model Consuming Master Data Services DataAfter completing this module, students will be able to: Describe key Master Data Services concepts. Implement a Master Data Services model. Use Master Data Services tools to manage master data. Use Master Data Services tools to create a master data hub.Module 5: SQL Server 2012 Reporting ServicesThis module provides an introduction to new and enhanced features in SQL Server 2012 Reporting Services.Lessons Reporting Services Overview Reporting Services and Microsoft SharePoint Server Introduction to Data AlertsLab : Using SQL Server 2012 Reporting Services Viewing SharePoint Mode Configuration Authoring, Publishing, and Viewing a Report Creating and Managing Data AlertsAfter completing this module, students will be able to: Describe the key capabilities of Reporting Services. Install and configure Reporting Services in SharePoint Mode. Use data alerts to notify users of changes to report data.Module 6: Creating Tabular Data Models with PowerPivotThis module provides an introduction to new and enhanced features in PowerPivot.Lessons Introduction to Tabular Data Models and PowerPivot Technologies Using PowerPivot Using DAX in a PowerPivot Data ModelLab : Using PowerPivot for Excel Creating a Tabular Data Model by Using PowerPivot for Excel Using a Tabular Data Model in Excel Sharing a PowerPivot Workbook to PowerPivot GalleryLab : Creating Calculated Columns and Measures Creating Calculated Columns Creating MeasuresAfter completing this module, students will be able to: Describe the key features and benefits of tabular data models and PowerPivot technologies. Create a PowerPivot for Excel workbook. Share a PowerPivot for Excel workbook to PowerPivot Gallery and use a PowerPivot for Excel workbook as a data source.Module 7: Implementing an Analysis Services Tabular Data ModelThis module describes how to create tabular Analysis Services databases.Lessons Introduction to Analysis Services Tabular Data Model Projects Developing an Analysis Services Tabular Data ModelLab : Working with an Analysis Services Tabular Data Model Creating an Analysis Services Tabular Data Model Project Implementing a Perspective Implementing Partitions Deploying an Analysis Services Tabular Data Model Using a Tabular Data Model Configuring DirectQuery Storage Mode Implementing Security in a Tabular Data ModelAfter completing this module, students will be able to: Describe Analysis Services tabular data model projects. Implement an Analysis Services tabular data model by Using SQL Server Data Tools.Module 8: Creating Data Visualizations with Power ViewThis module provides an introduction to Power View, and describes how it can be used to create interactive data visualizations.Lessons Introduction to Power View Visualizing Data with Power ViewLab : Creating Interactive Reports with Power View Configuring a Tabular Data Model for Power View Creating a Simple Power View Report Using Interactive Visualizations Creating a Scatter Chart and a Play Axis Exporting a Power View Report to PowerPointAfter completing this module, students will be able to: Describe the Power View and its place in the BI ecosystem. Create data visualizations by using Power View.Module 9: Using Cloud Technologies in a BI SolutionThis module introduces Microsoft cloud technologies that can be used in a BI solution.Lessons Overview of Cloud Data Sources SQL Azure SQL Azure Reporting Services The Windows Azure Marketplace DataMarketLab : Using Cloud Data in a BI Solution Creating a SQL Azure Solution Extracting Data from SQL Azure Obtaining Data from the Windows Azure Marketplace DataMarketAfter completing this module, students will be able to: Describe cloud data scenarios. Use SQL Azure. Use SQL Azure Reporting Services. Use the Windows Azure Marketplace DataMarket.