SKILL BENCHMARK

Data Loading and Visualization in Power BI Competency (Intermediate Level)

  • 20m
  • 20 questions
The Data Loading and Visualization in Power BI Competency (Intermediate Level) benchmark measures your recognition of how to load data from cloud storage and data modeling using Power BI. A learner who scores high on this benchmark demonstrates that they have good expertise in using Power BI to load data from the cloud, model data, and perform advanced visualizations in Power BI.

Topics covered

  • configure many-to-many relationship's cross-filter direction
  • create a calculated measure
  • create a map visualization
  • create calculated columns
  • create calculated tables using INTERSECT
  • create multiple calculated columns in a table
  • load data for calculated tables
  • load data from an application programming interface (API) into Power BI
  • load data from an HTML page into Power BI
  • load data from Azure Blob Storage
  • load data from BigQuery
  • load data from S3 with a Python script
  • set up a many-to-many relationship
  • set up a matrix visualization
  • upload data to Amazon S3
  • upload data to BigQuery
  • use time intelligence and the date hierarchy
  • visualize data using line chart
  • visualize data using scatter plots
  • write a DAX formula to create a calculated measure