Power Query for beginners
https://TutGee.com
Instructors: Bluelime Learning Solutions
2 sections • 22 lectures • 1h 57m total length
Video: MP4 1280x720 44 KHz | English + Sub
Updated 2/2022 | Size: 767 MB
Prepare and Transform Data with Power Query
What you'll learn
Connect to data source
Create and manage query groups
Merge queries
Append queries
Create conditional columns
Split columns
Transform less structured data
Requirements
Basic knowledge of excel advised
Basic knowledge of Power BI advised
Description
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.
Business users spend up to 80 percent of their time on data preparation, which delays the work of analysis and decision-making. Several challenges contribute to this situation, and Power Query helps address many of them.