SKILL BENCHMARK

Power BI Competency

  • 22m
  • 22 questions
The Power BI Competency benchmark will measure your ability to recall and relate the underlying data analysis and visualization concepts in Power BI. You will be evaluated on your ability to recognize the concepts of data analysis, loading and transforming data, customizing charts, querying, and visualizations in Power BI. A learner who scores high on this benchmark demonstrates that they are able to work on Power BI projects with minimal supervision.

Topics covered

  • apply the M formula language to perform data transformations in Power BI
  • build a simple column chart from the contents of a Power BI table and distinguish between Import and DirectQuery storage modes in Power BI
  • connect to a relational database in DirectQuery mode
  • create a basic column chart to visualize data in Power BI
  • create a line chart
  • create column charts and bar charts
  • filter out unnecessary data by defining row-level filters
  • import and transform data in Power Query
  • import data from a relational database and load it into Power BI
  • import data from CSV and XML files into Power BI and recall the role of Power Query in transforming the data
  • list and describe the specialized charts in Power BI
  • load data from a JSON file into Power BI
  • load data from multiple separate but related files located in a single directory
  • merge the contents of two related columns in Power Query
  • modify the types of columns in a table using Power Query
  • outline the purpose of Power BI reports and how to design them, with reference to features and best practices
  • perform aggregations on data in a table to summarize the contents of a dataset
  • perform a join operation to merge two related tables into a single unit
  • perform basic and top N filters
  • remove unnecessary columns and rows from a data source using Power Query
  • use Power BI's column profiling feature to recognize what information is stored in a dataset
  • visualize different types of data in Power BI