Perform common query tasks in Power BI Desktop

Focused View

Bluelime Learning Solutions

1:35:09

6 View

1. Power BI Setup

1. Introduction.mp4

00:20

2. What is Power BI.mp4

05:47

3. What is Power BI Desktop.mp4

03:40

4. Install Power BI Desktop.mp4

02:55

5. Explore Power BI Desktop.mp4

05:02

2. Perform common query tasks in Power BI Desktop

1.1 AccessDatabasePowerBI.zip

1. Connect to data.mp4

07:09

2. Power Query Editor and Queries.mp4

06:49

3. Creating and Managing Query Groups.mp4

04:35

4. Renaming Queries.mp4

04:54

5. Splitting Columns in a query.mp4

07:06

6. Changing Data Types.mp4

05:47

7. Removing and Reordering Columns.mp4

06:54

8. Duplicating and Adding Columns.mp4

03:31

9. Creating Conditional Columns.mp4

06:18

10. Connecting to Files in a Folder.mp4

07:17

11. Appending Queries.mp4

06:58

12. Merging Queries.mp4

05:35

13. Query Dependency View.mp4

04:32

Description

Gain Real World Data Analytic Skills by performing query tasks in Power BI Desktop

What You'll Learn?

Connect to data
Power Query Editor and Queries
Shape and combine data
Group rows
Pivot columns
Create custom columns
Query formulas
Creating and Managing Query Groups
Creating Conditional Columns
Appending Queries
Merging Queries

Who is this for?

Beginner Power BI Data Analyst

Beginner Data Analyst

Beginner Data Scientist

What You Need to Know?

Basic knowledge of excel

More details

Description
Power BI is a data analytics tool developed by Microsoft used to visualize data and find useful insights. In this article, you will see how to work with the Query Editor in Power BI desktop. Power BI comes in various versions, i.e., Power BI Desktop, Power BI Service, Power BI Mobile, and Power BI Developer. Power BI desktop is the free version, and the query editor is available in all three versions.
Power BI Desktop has several components to transform, model, and visualize data and also generate reports from data. The Query Editor in Power BI is used to transform or edit data files before they are actually loaded into the Power BI.
The Query Editor plays the role of an intermediate data container where you can modify data by selecting rows and columns, splitting rows and columns, pivoting and unpivoting columns, etc. The changes made by the Query Editor in Power BI are not reflected in the actual dataset. Once you have pre-processed the data and have transformed it into the required format, you can load the data into the Power BI environment.
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.
Who this course is for:
Beginner Power BI Data Analyst
Beginner Data Analyst
Beginner Data Scientist

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Bluelime Learning Solutions

Instructor's Courses

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.