Design and build composite models, including aggregations
Query relational data sources in dedicated or serverless SQL pools, including querying partitioned data sources
Create R or Python visuals in Power BI
Recommend and configure a Power BI tenant or workspace to integrate with Azure Data Lake Storage Gen2
Design and build a large format dataset
Recommend appropriate file types for querying serverless SQL pools
Create and import a custom report theme
Recommend and configure an on-premises gateway in Power BI
Write calculations that use DAX variables and functions, for example handling blanks or errors, creating virtual relationships, and working with iterators
Identify an appropriate Azure Synapse pool when analyzing data
Configure and manage Power BI capacity
Explore and visualize data by using the Azure Synapse SQL results pane
Create calculation groups
Explore data by using native visuals in Spark notebooks
Identify requirements for a solution, including features, performance, and licensing strategy
Create reusable assets, including Power BI templates, Power BI data source (.pbids) files, and shared datasets