Course Outline
Introduction to PowerQuery
1. What is PowerQuery
2. Use cases for PowerQuery
Fetching Data and Operations on Data Sets:
- Data import from:
- a. MS Excel
- b. web network
- 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. Query duplication and references
Data Operations
- Merging data from multiple sheets (consolidation),
- deleting rows/columns,
- grouping data,
- joining 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
- Query parameterization
- Automating imports
PowerPivot
- Creating a data model based on data prepared in PowerQuery
- Presentation of an example of using PowerPivot in a real-world scenario
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