Final Exam: Mastering Power BI Service and Power Query

WHAT YOU WILL LEARN

• 

  Recall key concepts of power query
  

  perform operations using power query
  

  perform column deletion and rename operations
  

  cleaning and transformations
  

  split columns and remove duplicates
  

  create query duplicates and query references
  

  perform basic and advanced filtering
  

  add calculated and conditional columns
  

  set up relationships between tables in power bi
  

  perform inner joins in power bi
  

  perform left outer joins in power bi
  

  configure settings for fuzzy merging
  

  tweak the similarity threshold for fuzzy merging
  

  perform fuzzy merging with a transformation table
  

  perform anti-joins in power bi
  

  recall the main features of the power bi service
  

  create an account with the power bi service
  

  create and view datasets
• 

  create and use dataflows
  

  refresh dataflows with updated data
  

  create autogenerated reports
  

  create reports manually
  

  create a report and a dashboard
  

  connect to a dataflow from power bi desktop
  

  create and share power bi apps
  

  create a paginated report
  

  embed a paginated report in a dashboard
  

  create and use a deployment pipeline
  

  create scorecards with metrics
  

  create connected metrics and submetrics
  

  create metrics and perform metrics filtering
  

  create multiple reports from a dataflow
  

  install and use the power bi app
  

  configure the mobile layout of a report
  

  add visual and report-level filters