Course Outline
Introduction to PowerQuery
1. What is PowerQuery
2. PowerQuery use cases
Data retrieval and operations on data sets:
- Data import from:
- a. MS Excel
- b. web
- c. MS SQL
- d. text files
- e. importing multiple files
- Query operations:
- a. Combining queries
- b. Scalano inquiries
- c. Types of joins between queries
- d. Scalanot blurred
- e. Data loading settings
- f. Duplication and query references
Data operations
- combining data from multiple sheets (consolidation),
- deleting rows/columns,
- data grouping,
- data merging,
- data filtering,
- organizing data,
- changing data type,
- working with numerical data,
- working with date and time data,
- working with text data.
Parameterization and query automation
- Parameter management
- Query parameterization
- Import automation
PowerPivot
- Creating a data model based on data prepared in PowerQuery
- Presentation of an example of using PowerPivot in a real case
Requirements
lack
Testimonials (6)
No pressure to cover all the 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
Topics of the classes. I learned many new things that I had no idea about before. I also appreciate the involvement of the instructor and his willingness to help, approach to the participants.
Paulina - LKQ Polska Sp. z o. o.
Course - PowerQuery - poziom podstawowy
Machine Translated
Method of conducting and knowledge included
Pawel - LKQ Polska Sp. z o. o.
Course - PowerQuery - poziom podstawowy
Machine Translated