This three-day instructor-led course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.


Objectivos

_ Describe key new and enhanced features for BI in SQL Server 2012.
_ Use new and enhanced features in SQL Server Integration Services.
_ Manage data quality by using SQL Server Data Quality Services.
_ Manage master data by using new and enhanced features of SQL Server Master Data Services.
_ Use new and enhanced features of SQL Server Reporting Services.
_ Create tabular data models with PowerPivot and DAX.
_ Implement a tabular data model in SQL Server Analysis Services.
_ Use Power View to create interactive data visualizations.
_ Integrate Microsoft cloud technologies into a BI solution.


Duração: 12 horas


Conteúdo Programático

Module 1: Introduction to SQL Server 2012 for Business Intelligence
_ 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 Reporting

Module 2: New and Enhanced Features in SQL Server Integration Services
_ Using the CDC Control Task for Incremental Data Loads
_ Deploying and Operating SSIS Packages

Module 3: Data Quality Services
_ Introduction to Data Quality
_ Using Data Quality Services to Cleanse Data
_ Using Data Quality Services to Match Data

Module 4: Master Data Services
_ Introduction to Master Data Services
_ Implementing a Master Data Services Model
_ Managing Master Data
_ Creating a Master Data Hub




Module 5: SQL Server 2012 Reporting Services
_ Reporting Services Overview
_ Reporting Services and Microsoft SharePoint Server
_ Introduction to Data Alerts

Module 6: Creating Tabular Data Models with PowerPivot
_ Introduction to Tabular Data Models and PowerPivot Technologies
_ Using PowerPivot
_ Using DAX in a PowerPivot Data Model

Module 7: Implementing an Analysis Services Tabular Data Model
_ Introduction to Analysis Services Tabular Data Model Projects
_ Developing an Analysis Services Tabular Data Model

Module 8: Creating Data Visualizations with Power View
_ Introduction to Power View
_ Visualizing Data with Power View

Module 9: Using Cloud Technologies in a BI Solution
_ Overview of Cloud Data Sources
_ SQL Azure
_ SQL Azure Reporting Services
_ The Windows Azure Marketplace DataMarket


Requisitos

_ Experience of creating database solutions in SQL Server, including basic Transact-SQL programming.
_ Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting.



Solicite mais informação

Inscreva-se neste curso