Design and implement a data warehouse (35–40%)Design and implement dimension tables
Design and implement fact tables
Design and implement indexes for a data warehouse workload
Design storage for a data warehouse
Design and implement partitioned tables and views
|
Extract, transform, and load data (40–45%)Design and implement an extract, transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package
Design and implement an ETL data flow by using an SSIS package
Implement an ETL solution that supports incremental data extraction
Implement an ETL solution that supports incremental data loading
Debug SSIS packages
Deploy and configure SSIS packages and projects
|
Build data quality solutions (15–20%)Create a knowledge base
Maintain data quality by using DQS
Implement a Master Data Services (MDS) model
Manage data by using MDS
|
Design a multidimensional business intelligence (BI) semantic model (25–30%)Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
Design and implement dimensions in a cube
Implement measures and measure groups in a cube
|
Design a tabular BI semantic model (20–25%)Design and publish a tabular data model
Configure, manage, and secure a tabular model
Develop a tabular model to access data in near real time
|
Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) (15–20%)Create basic MDX queries
Implement custom MDX solutions
Create formulas by using the DAX language
|
Configure and maintain SQL Server Analysis Services (SSAS) (30–35%)Plan and deploy SSAS
Monitor and optimize performance
Configure and manage processing
Create Key Performance Indicators (KPIs) and translations
|