At Course Completion After completing this course, students will be able to: · 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. |