Course Details

Previous Page


Data Analytics Using Power BI: Data Sourcing and Preparation


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/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.

Target Audience
IT technicians and business analysts who need to analyze data utilizing Power BI

Prerequisites
None

Expected Duration (hours)
1.8

Lesson Objectives

Data Analytics Using Power BI: Data Sourcing and Preparation

  • 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
  • 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
  • ensure data is in a form usable by Power BI for querying and visualization
  • Course Number:
    df_mpbi_a02_it_enus