• Online, Self-Paced
Course Description

Power BI can draw data from numerous file, database and web sources. Data must sometimes be transformed for use in analytic software such as Power BI.

Learning Objectives

Getting Data Into Power BI

  • start the course
  • describe where Power BI data comes from
  • recognize how Power BI can use data from files
  • recognize how Power BI can use data from databases
  • recognize how Power BI can use data from online sources
  • use Quick Insights in the Power BI Service to quickly generate interactive data visualizations
  • import a file data source into Power BI
  • import a database data source into Power BI
  • import a web URL data source into Power BI
  • recognize the purpose of the Power BI Gateway
  • configure the Power BI on-premises Gateway

Data Preparation

  • describe why data in its raw form is sometimes not suitable for use with Power BI
  • determine when the use of queries is appropriate
  • recognize when data should be combined
  • explain how row values can be grouped together and how rows can be filtered out to remove unnecessary data
  • create an append query
  • create a merge query
  • filter out rows that are unnecessary
  • create a calculated column

Practice: Prepare Data for Visualization

  • ensure data is in a form usable by Power BI for querying and visualization

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.