Choose when to use external tools, including DAX Studio and Tabular Editor 2
Optimize a data model by using denormalization
Deploy and manage datasets by using the XMLA endpoint
Choose when to use DirectQuery for Power BI datasets
Recommend a monitoring and auditing solution for a data analytics environment, including Power BI REST API and PowerShell cmdlets
Implement incremental refresh (including the use of query folding)
Query advanced data sources, including JSON, Parquet, APIs, and Azure Machine Learning models
Recommend automation solutions for the analytics development lifecycle, including Power BI REST API and PowerShell cmdlets
Recommend settings in the Power BI admin portal
Create queries, functions, and parameters by using the Power Query Advanced Editor
Analyze data model efficiency by using VertiPaq Analyzer
Identify data sources in Azure by using Microsoft Purview
Perform impact analysis of downstream dependencies from dataflows and datasets
Optimize a data model by using Tabular Editor 2
Implement and manage deployment pipelines in Power BI
Identify and manage privacy settings on data sources