dp-600

Explore and analyze data (20–25%)

Perform exploratory analytics

• Implement descriptive and diagnostic analytics

  • Understand star schema and the importance for Power BI
  • Create and view decomposition tree visuals in Power BI
  • Tutorial: Create a decomposition tree with a Power BI sample

• Integrate prescriptive and predictive analytics into a visual or report

  • Use the Analytics pane in Power BI Desktop
  • Build a machine learning model in Power BI
  • Consume Azure Machine Learning models in Power BI

• Profile data

  • Using the data profiling tools
  • ydata-profiling

Query data by using SQL

• Query a lakehouse in Fabric by using SQL queries or the visual query editor

  • SQL analytics endpoint of the Lakehouse

• Query a warehouse in Fabric by using SQL queries or the visual query editor

  • Query using the visual query editor
  • Query using the SQL query editor
  • Create cross-warehouse queries with the SQL query editor

• Connect to and query datasets by using the XMLA endpoint

  • Integration tenant settings
  • Datasets - Execute Queries
  • EVALUATE