Final Exam: From Data Loading to Stunning Visualization

WHAT YOU WILL LEARN

• 

  Install power bi and work with the ui
  

  load and view data from a csv file
  

  view column profile and data distributions
  

  visualize data using a bar chart
  

  rename columns and remove duplicates in power bi
  

  load data into power bi from sharepoint
  

  load data from sql server into power bi
  

  connect to mysql from power bi
  

  reset cached mysql credentials from power bi
  

  visualize data using pie and donut charts
  

  visualize hierarchical data using treemaps
  

  load data from azure blob storage
  

  load data from an html page into power bi
  

  load data from bigquery
  

  visualize data using line chart
  

  load data from an application programming interface (api) into power bi
  

  visualize data using scatter plots
  

  set up a matrix visualization
• 

  load data for calculated tables
  

  create calculated tables using intersect
  

  create calculated tables using union
  

  create calculated columns
  

  create calculated tables using naturalinnerjoin
  

  create multiple calculated columns in a table
  

  set up a one-to-one relationship
  

  set up a many-to-many relationship
  

  write a dax formula to create a calculated measure
  

  read data with the default date hierarchy
  

  use time intelligence and the date hierarchy
  

  visualize data using a gauge chart
  

  visualize data using a funnel chart
  

  visualize data using a sankey chart
  

  visualize data using a heatmap
  

  visualize data using a calendar layout
  

  visualize data using a gantt chart