-----------------------------------------------------------------------
â–ş To Download the Files Used, Access:
-----------------------------------------------------------------------
If you prefer the video in text format:
-----------------------------------------------------------------------
TO HIRE HASHTAG FOR YOUR COMPANY:
-----------------------------------------------------------------------
Hello Impressionadores! Today we will start the Basic Power Query Course! This is a course for you to understand the importance and how to use Power Query in Power BI to create your projects.
In this first lesson, we will have a brief introduction to Power Query so that you know how to import the database, how to process data in Power Query.
This part of processing the database is very important, as it ensures that your information is all correct when presenting your dashboard, making it an essential step in any project.
I will show you some important tools and steps within Power Query so that you have a minimally adjusted database.
We will see how to delete a column in Power Query (remove unnecessary information), how to delete rows in Power Query (empty rows that may hinder analysis).
I will show you how to adjust the column headers, how to split a column in Power Query (to separate information and perform more detailed analyses), I will talk about applied steps in Power Query (which is a history of your actions within the program).
To finish, I will teach you how to use the example column tool in Power Query (to separate information automatically using some examples).
-----------------------------------------------------------------------
Recommended Videos:
â–ş How to Start from ZERO in POWER BI in just ONE LESSON
â–ş Power BI Course - Lesson 01 - First Steps in Power BI
â–ş Power BI Course - Lesson 0 - First Steps in Power BI
â–ş Power BI Course - Lesson 02 - Manipulating Texts and Values in the Database
â–ş ANIMATED BAR CHART RACE in Power BI
-----------------------------------------------------------------------
Hashtag Treinamentos
â–ş Turn on notifications (click the bell)!
â–ş Like our video!
-----------------------------------------------------------------------
Social Media
In our videos, we teach various Power BI tips and tricks so that you can impress using this tool in the job market!
-----------------------------------------------------------------------
Lesson Content
00:00 Introduction
01:02 What is the purpose of Power Query? (BI Process)
04:58 Understanding the Database
07:28 Importing the Database (Transform Data)
10:10 Opening the Database in Power Query
10:47 What is Power BI and what is Power Query?
11:50 What do we need to edit in Power Query? (Data Processing)
12:38 Deleting Columns in Power Query
13:17 Deleting Rows in Power Query
16:01 Adjusting the Column Headers
17:41 Splitting a Column in Power Query
22:08 Replacing Values in Power Query
23:55 Applied Steps in Power Query (history)
26:26 Example Column in Power Query
29:34 Example Column (more complex cases)
31:18 Saving the file (sending to Power BI)
32:25 Conclusion
#powerbi #pbi #hashtagtreinamentos