Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to PowerQuery
1. What is PowerQuery 2. PowerQuery use cases
Data retrieval and operations on datasets:
- Data import from:
- a. MS Excel b. web c. MS SQL d. text files e. importing multiple files
- Query operations:
- a. Query merging b. Scalanot queries c. Types of joins between queries d. Scalanot fuzzy e. Data load settings f. Duplication and query references
Data operations
- combining data from multiple sheets (consolidation), deleting rows/columns, grouping data, combining data, filtering data, organizing data, changing data type, working with numerical data, working with date and time data, working with text data.
Parameterization and automation of queries
- Parameter management Parameterization of queries 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
14 Hours
Testimonials (1)
Method of conducting and knowledge included
Paweł - LKQ Polska Sp. z o. o.
Course - PowerQuery - poziom podstawowy
Machine Translated