PowerQuery - poziom podstawowy

lack

Power Query is a tool for importing, transforming and combining data from various sources in Microsoft Excel and Power BI. The basic version of the training includes an introduction to Power Query, importing data from various sources, data operations, parameterization and automation of queries, and a presentation of an example of using Power Pivot in a real case. In short, this training focuses on learning how to use Power Query to prepare data for analysis in Excelu or Power BI.

Introduction to PowerQuery

1. What is PowerQuery
2. PowerQuery use cases

Data retrieval and operations on data sets:

1. Data import from:

• a. MS Excel
• b. web
• c. MS SQL
• d. text files
• e. importing multiple files

2. 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

1. combining data from multiple sheets (consolidation),
2. deleting rows/columns,
3. data grouping,
4. data merging,
5. data filtering,
6. organizing data,
7. changing data type,
8. working with numerical data,
9. working with date and time data,
10. working with text data.

Parameterization and query automation

1. Parameter management
2. Query parameterization
3. Import automation

PowerPivot

1. Creating a data model based on data prepared in PowerQuery
2. Presentation of an example of using PowerPivot in a real case