Data analysis using Power BI – Obtaining and preparing data

Teacher

DB Academy

Category:

Data Science

Description
Reviews

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

Related Courses

Data Science

How to find quality in data

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Successful data management in t...

Intermediate

Preview this course

Add to Wishlist

€6.40

Data Science

Key statistical concepts

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analytics involves a...

Intermediate

Preview this course

Add to Wishlist

€12.90

Data Science

Process and application

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview For any organization, predictiv...

Intermediate

Preview this course

Add to Wishlist

€12.90

Data Science

Leveraging the power of data science for business development

€6.40

DB Academy

Leveraging the power of data science for business development

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Data science means using scient...

Intermediate

Preview this course

Add to Wishlist

€6.40

Data Science

Data analysis using Power BI – Obtaining and preparing data

€15.90

DB Academy

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

Intermediate

Preview this course

Add to Wishlist

€15.90

Data Science

Data collection and exploration

€7.90

DB Academy

Data collection and exploration

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

Preview this course

Add to Wishlist

€7.90

Data Science

Data analysis using Power BI – Concepts

€7.90

DB Academy

Data analysis using Power BI – Concepts

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Business intelligence comes dow...

Intermediate

Preview this course

Add to Wishlist

€7.90

Data Science

Predictive analysis and big data

€7.90

DB Academy

Predictive analysis and big data

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analytics uses techn...

Intermediate

Preview this course

Add to Wishlist

€7.90

Data Science

Transforming social information into applicable information

€6.40

DB Academy

Transforming social information into applicable information

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Using social intelligence (IS) ...

Intermediate

Preview this course

Add to Wishlist

€6.40

Data Science

Explore data visualization

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

Preview this course

Add to Wishlist

€7.90

Data Science

Data-driven decision making

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Organizations around the world ...

Intermediate

Preview this course

Add to Wishlist

€6.40

Data Science

Data preprocessing

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analysis provides th...

Intermediate

Preview this course

Add to Wishlist

€7.90

Data Science

Data mining, data distribution and hypothesis testing

€7.90

DB Academy

Data mining, data distribution and hypothesis testing

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Useful information can be extra...

Intermediate

Preview this course

Add to Wishlist

€7.90

Data Science

Data analysis using Power BI – Data modeling and visualization

€12.90

DB Academy

Data analysis using Power BI – Data modeling and visualization

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

Preview this course

Add to Wishlist

€12.90

Data Science

Correlation and regression

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Predictive analysis involves wi...

Intermediate

Preview this course

Add to Wishlist

€7.90

Data Science

Organizing business data by modeling data

€6.40

DB Academy

Organizing business data by modeling data

Important to know: The course video is English with Romanian subtitles and test questions are in Romanian. Overview Data modeling can help companie...

Intermediate

Preview this course

Add to Wishlist

€6.40

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Functional

Performance

Analytics

Others