Data analysis using Power BI – Obtaining and preparing data

Important to know:
The course video is English with Romanian subtitles and test questions are in Romanian.

Overview

Power BI can extract data from many files, databases, and web sources. Sometimes data needs to be transformed for use in analytics software such as Power BI.

 

Objectives

  •  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 Power Service BI to quickly generate interactive data views
  • 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 Power BI Gateway
  • Configure the Power BI Location Gateway
  • Describe why raw data is sometimes not suitable for use with Power BI
  • Determine when it is appropriate to use queries
  • Recognize when data should be combined
  • explain how raw values can be grouped and rows filtered to remove unnecessary data
  • create an adjacent query
  • create a merge query
  • thread treat unnecessary rows
  • create a calculated column

Be the first to add a review.

Please, login to leave a review
Get Course
Enrolled: 8 students
Video: 01:33:53
Level: Intermediate

Related Courses

Data Science
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analytics involves a...
Intermediate
€12.90
Data Science
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview For any organization, predictiv...
Intermediate
€12.90
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analysis provides th...
Intermediate
€7.90
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview The business world is full of d...
Intermediate
€7.90
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Useful information can be extra...
Intermediate
€7.90
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Most of the data collected by o...
Intermediate
€7.90
Data Science
€15.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Power BI can extract data from ...
Intermediate
€15.90
Data Science
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Data science means using scient...
Intermediate
€6.40
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Business intelligence comes dow...
Intermediate
€7.90
Data Science
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Data modeling can help companie...
Intermediate
€6.40
Data Science
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using social intelligence (IS) ...
Intermediate
€6.40
Data Science
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Organizations around the world ...
Intermediate
€6.40
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analysis involves wi...
Intermediate
€7.90
Data Science
€7.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analytics uses techn...
Intermediate
€7.90
Data Science
€6.40
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Successful data management in t...
Intermediate
€6.40
Data Science
€12.90
Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Sometimes data needs to be mode...
Intermediate
€12.90
Individual
Business
Partner

Register as Individual

For those who are individual learners, team members of a business, business professionals.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Business

Business Leaders / HR Responsibilities / Other company representatives who want to upskill employees.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Register as Partner

For companies which want to colobrate with DB Academy and publish educational content for their customers.

{{this.errorMessage}}

{{this.successMessage}}

By registering you accept terms and conditions

Already on DB Academy?

Login

Authanticate to DB Academy.

{{this.errorMessage}}

{{this.successMessage}}

New to DB Academy?

Forgot your password?