Microsoft - Microsoft Designing and Implementing Enterprise-Scale

Curriculum

Module 1: Implement and manage a data analytics environment (25–30%)

Govern and administer a data analytics environment

• Manage Power BI assets by using Azure Purview
• Identify data sources in Azure by using Azure Purview
• Recommend settings in the Power BI admin portal
• Recommend a monitoring and auditing solution for a data analytics environment, including Power BI REST API and PowerShell cmdlets

Integrate an analytics platform into an existing IT infrastructure

Manage the analytics development lifecycle

• Commit code and artifacts to a source control repository in Azure Synapse Analytics
• Recommend a deployment strategy for Power BI assets
• Recommend a source control strategy for Power BI assets
• Implement and manage deployment pipelines in Power BI
• Perform impact analysis of downstream dependencies from dataflows and datasets
• Recommend automation solutions for the analytics development lifecycle, including Power BI

REST API and PowerShell cmdlets

Module 2: Query and transform data (20–25%)

Query data by using Azure Synapse Analytics

Module 3: Implement and manage data models (25–30%)

Design and build tabular models

• Choose when to use DirectQuery for Power BI datasets
• Choose when to use external tools, including DAX Studio and Tabular Editor 2
• Create calculation groups
• Write calculations that use DAX variables and functions, for example handling blanks or errors, creating virtual relationships, and working with iterators
• Design and build a large format dataset
• Design and build composite models, including aggregations
• Design and implement enterprise-scale row-level security and object-level security

Optimize enterprise-scale data models

• Identify and implement performance improvements in queries and report visuals
• Troubleshoot DAX performance by using DAX Studio
• Optimize a data model by using Tabular Editor 2
• Analyse data model efficiency by using VertiPaq Analyzer
• Implement incremental refresh
• Optimize a data model by using denormalization

Module 4: Explore and visualize data (20–25%)

Explore data by using Azure Synapse Analytics

• Explore data by using native visuals in Spark notebooks
• Explore and visualize data by using the Azure Synapse SQL results pane

Visualize data by using Power BI

• Create and import a custom report theme
• Create R or Python visuals in Power BI
• Connect to and query datasets by using the XMLA endpoint
• Design and configure Power BI reports for accessibility
• Enable personalized visuals in a report
• Configure automatic page refresh
• Create and distribute paginated reports in Power BI Report Builder