Data Warehouse & Power BI For Beginners -DW ,SSIS, ETL, BI

Implement a MS SQL Server Data Warehouse & Power BI Solution

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I Learn?

• 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 a MS SQL Server 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
• Deploy SSIS projects
• Implement a Master Data Services model
• Describe how you can use custom components to extend SSIS
• Describe BI and common BI scenarios
• Create a data warehouse with Microsoft SQL Server
• Implement ETL with SQL Server Integration Services
• validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Requirements

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of relational databases.
• Some experience with database design

Target audience

• Database professionals
• Business Analyst professionals
• Data Engineering professionals