Course Outline
Introduction to PowerQuery
1. What is PowerQuery
2. Use Cases for PowerQuery
Data Retrieval and Data Set Operations:
- Importing data from:
- a. MS Excel
- b. web
- c. MS SQL
- d. text files
- e. importing multiple files
- Query Operations:
- a. Joining queries
- b. Merging queries
- c. Types of joins between queries
- d. Fuzzy matching
- e. Data loading settings
- f. Duplicating and referencing queries
Data Operations
- Combining data from multiple sheets (consolidation),
- Deleting rows/columns,
- Grouping data,
- Merging data,
- Filtering data,
- Sorting data,
- Changing data types,
- Working with numerical data,
- Working with date and time data,
- Working with text data.
Parameterization and Query Automation
- Managing parameters
- Parameterizing queries
- Automating imports
PowerPivot
- Creating a data model based on data prepared in PowerQuery
- Demonstrating an example of using PowerPivot in a real-world scenario
Requirements
missing
Testimonials (7)
the way how we learned everything. First the explanation with showing, and then we got the time
- The Boston Consulting Group Sp. z o.o.
Course - PowerQuery - poziom podstawowy
I really enjoyed the training, what I liked most was that if someone got lost somewhere or something didn't work for them, the trainer would immediately approach and help them
Agnieszka - LKQ Polska Sp. z o. o.
Course - PowerQuery - poziom podstawowy
Machine Translated
No pressure to rewrite the entire material in a short time
Daniel
Course - PowerQuery - poziom podstawowy
Machine Translated
Practical exercises
Karolina
Course - PowerQuery - poziom podstawowy
Machine Translated
Showing us Power Query from many angles with the help of great examples and exercises
Gabor - THE BOSTON CONSULTING GROUP Sp. z o.o.
Course - PowerQuery - poziom podstawowy
Exercises were very practical, and especially much appreciated that trainer was very opened to questions during the session
Yulia Skrynnyj - THE BOSTON CONSULTING GROUP Sp. z o.o.
Course - PowerQuery - poziom podstawowy
Course topic. I learned a lot of new things that I didn't know before. I also appreciate the instructor's engagement and their willingness to help, as well as their approach towards the participants.
Paulina - LKQ Polska Sp. z o. o.
Course - PowerQuery - poziom podstawowy
Machine Translated