Destinatários

The primary audience for this course are 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.

Pré-requisitos

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

Objetivos

• 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
• Describe the components, architecture, and nature of a BI solution
• Create a multidimensional database with analysis services
• Implement dimensions in a cube
• Implement measures and measure groups in a cube
• Use MDX syntax
• Customize a cube
• Implement a tabular database
• Use DAX to query a tabular model
• Use data mining for predictive analysis

Programa

Estrutura do percurso:

• Implementing a SQL Data Warehouse (20767)
• Developing SQL Data Models (20768)

Exames de Certificação:

• 70-767
• 70-768

Composição:

• 2 Cursos de Formação MOC
• 2 Exames, incluídos no valor do percurso