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

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

What you’ll 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.

Deal Score0
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase