Implementing a SQL Data Warehouse - SSIS

• Describe the key elements of a data warehousing solution • Describe the main hardware considerations for building a data warehouse • Implement a logical design for a data warehouse • Implement a physical design for a data warehouse • Create columnstore indexes • Implementing an Azure SQL Data Warehouse • Describe the key features of SSIS • Implement a data flow by using SSIS • Implement control flow by using tasks and precedence constraints • Create dynamic packages that include variables and parameters • Debug SSIS packages • Describe the considerations for implement an ETL solution • Implement Data Quality Services • Implement a Master Data Services model • Describe how you can use custom components to extend SSIS • Deploy SSIS projects • Describe BI and common BI scenarios