SKILL BENCHMARK

Data Loading and Visualization in Power BI Literacy (Beginner Level)

  • 14m
  • 14 questions
Explore all Skills Benchmarks
The Data Loading and Visualization in Power BI Literacy (Beginner Level) benchmark measures your recognition of how to process and clean the data stored in tables, import data into Power BI from SharePoint, load data from SQL Server, and read data in from MySQL. A learner who scores high on this benchmark demonstrates that they possess the basic Power BI skills to load and visualize data.

Topics covered

  • connect to MySQL from Power BI
  • create and view an area chart
  • load and view data from a CSV file
  • load data from SQL Server into Power BI
  • load data into Power BI from SharePoint
  • merge and split columns in Power BI
  • rename columns and remove duplicates in Power BI
  • reset cached MySQL credentials from Power BI
  • store data using the DirectQuery mode
  • store data using the import mode
  • view column profile and data distributions
  • visualize data using a bar chart
  • visualize data using pie and donut charts
  • visualize hierarchical data using treemaps