Power Query – Intermediate Level Training
Level
IntermediateDuration
8h / 1 dayDate
Individually arrangedPrice
Individually arrangedPower Query – Intermediate Level Training
The Power Query – Intermediate Level training is an intensive course for people who already have basic knowledge of Power Query and want to expand their skills with advanced techniques in data processing and visualization.
What You Will Learn
- As a result, participants will gain skills that enable advanced analysis, processing, and visualization of data in Excel, allowing for more effective decision-making and visual communication of information.
Who is this training for?
The target group includes people working with data in Excel, business analysts, reporting specialists, and anyone who wants to use data analysis tools more effectively in their work.
Training Program
-
Importing Data from Various Sources
- Databases
- Text files
- Folder import
- Web pages
- Excel workbooks
-
Managing Queries
- Refreshing queries
- Different ways of loading data from queries
- Appending queries
- Merging queries
- Working with multiple queries
-
Data Transformation and Cleaning in Power Query Editor
- Working with columns
- Working with rows
- Defining and changing data types
- Unpivoting columns
- Pivoting columns
- Grouping and summarizing data
- Text, numeric, and date transformations
