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