SKILL BENCHMARK

Power Query in Power BI Competency (Intermediate Level)

  • 19m
  • 19 questions
Explore all Skills Benchmarks
The Power Query in Power BI Competency (Intermediate Level) benchmark measures your recollection of how to perform data transformation using Power Query. A learner who scores high on this benchmark demonstrates that they have good expertise in using Power Query in Power BI for data transformation.

Topics covered

  • add calculated and conditional columns
  • combine queries using append
  • configure settings for fuzzy merging
  • create columns using merge queries
  • create parameterized queries
  • create query duplicates and query references
  • filter error rows with anti joins
  • perform anti joins in Power BI
  • perform basic and advanced filtering
  • perform full outer joins in Power BI
  • perform fuzzy merging
  • perform fuzzy merging with a transformation table
  • perform grouping and summarization operations
  • perform inner joins in Power BI
  • perform left outer joins in Power BI
  • perform right outer joins in Power BI
  • pivot and unpivot columns
  • split columns and remove duplicates
  • tweak the similarity threshold for fuzzy merging