Crushing your data in Power BI is easy with Power Query. It helps you to crush and modify data from different sources.
Goal
The goal of the course is that you know how to use Power Query to edit data so that it works with a data model.
Target audience
This training is for those who already know the basics of Power BI and also, imports data from different sources into data model.
Program version
In training, we use the latest version of Power BI Desktop. We recommend downloading the application before the start of the training.
Content
What is Power Query?
- How to use Power Query
- What can you do with Power Query
- Data preparation, the most important phase on analyzing
Combining your data
- Merge and append queries.
Fix your raw data
- Fix your data by deleting unnecessary columns and rows
- Control your data types
- Fix errors and replace wrong data
- Create cross reference pivot or unpivot columns.
Use steps to update your data
- Meaning of step and their use
Customs columns to add calculations
- Create new column from text, numbers or time data
- How to use columns from example
- Create conditional column
Keywords
Power BI, Desktop, Business Intelligence, Power Query, Microsoft Office 365, O365, reporting, visualization, data model, data analyzing, DAX, function, Query Editor, raw data, editing data