Providing Technology Training and Mentoring For Modern Technology Adoption
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.
After completing this course, students will be able to:
Before attending this course, students must have:
This course is intended for BI professionals with experience of using SQL Server 2008 R2.
This module provides an overview of how SQL Server 2012 can be used to build BI solutions.
After completing this module, students will be able to:
This 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.
Lab : Using SQL Server Integration Services
This 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.
Lab : Cleansing Data
Lab : Deduplicating Data
This module provides an introduction to master data management with SQL Server 2012 Master Data Services.
Lab : Implementing Master Data Services
This module provides an introduction to new and enhanced features in SQL Server 2012 Reporting Services.
Lab : Using SQL Server 2012 Reporting Services
This module provides an introduction to new and enhanced features in PowerPivot.
Lab : Using PowerPivot for Excel
Lab : Creating Calculated Columns and Measures
This module describes how to create tabular Analysis Services databases.
Lab : Working with an Analysis Services Tabular Data Model
This module provides an introduction to Power View, and describes how it can be used to create interactive data visualizations.
Lab : Creating Interactive Reports with Power View
This module introduces Microsoft cloud technologies that can be used in a BI solution.
Lab : Using Cloud Data in a BI Solution