2014-MOC20463D Implementing a Data Warehouse with Microsoft SQL Server 2014
•Considerations for a Data Warehouse Solution
•Describe the key considerations for a data warehousing project
•Data Warehouse Reference Architectures and Appliances
•Plan data warehouse infrastructure.
•Physical design for a data warehouse
•Design dimension tables for a data warehouse
•Design fact tables for a data warehouse
•Design and implement effective physical data structures for a data warehouse
•Exploring Data Sources
•Implementing Data Flow
•Explore source data for an ETL solution.
•Implement a data flow by using SSIS
•Creating Dynamic Packages
•Create dynamic packages that include variables and parameters
•Use containers in a package control flow
•Enforce consistency with transactions and checkpoints
•Logging SSIS Package Events
•Handling Errors in an SSIS Package
•Implement logging for an SSIS package
•Handle errors in an SSIS package
•Extracting Modified Data
•Loading Modified data
•Extract modified data
•Using Data Quality Services to Cleanse Data
•Using Data Quality Services to Match data
•Use Data Quality Services to cleanse your data
•Use Data Quality Services to match data
•Implementing a Master Data Services Model
•Managing Master Data
•Creating a Master Data Hub
•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
•Using Custom Components in SSIS
•Describe how custom components can be used to extend SSIS
•Deploying SSIS Projects
•Planning SSIS Package Execution
•Deploy SSIS projects.
•Plan SSIS package execution.
•Introduction to Reporting
•An Introduction to Data Analysis
Detalii logistice si de pret
6-8 trainees 439 Euro without VAT / trainee (-20% off)
>=9 trainees 384 Euro without VAT / trainee (-30% off)
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft® SQL Server® 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
This course is intended for database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:
•Implementing a data warehouse.
•Developing SSIS packages for data extraction, transformation, and loading.
•Enforcing data integrity by using Master Data Services.
•Cleansing data by using Data Quality Services.
•Describe data warehouse concepts and architecture considerations.
•Select an appropriate hardware platform for a data warehouse.
•Design and implement a data warehouse.
•Implement Data Flow in an SSIS Package.
•Implement Control Flow in an SSIS Package.
•Debug and Troubleshoot SSIS packages.
•Implement an ETL solution that supports incremental data extraction.
•Implement an ETL solution that supports incremental data loading.
•Implement data cleansing by using Microsoft Data Quality Services.
•Implement Master Data Services to enforce data integrity.
•Extend SSIS with custom scripts and components.
•Deploy and Configure SSIS packages.
•Describe how BI solutions can consume data from the data warehouse.