PNG.png){kind=tracking}
This one day course offers a thorough overview of Power Query concepts and tools, including data transformation and relational databases. You'll learn to create reports from multiple tables, understand primary and foreign keys, and explore different types of relationships and joins. The course covers data shaping techniques such as filtering, sorting, and formatting, as well as transforming data through splitting, merging, and cleaning. You'll also delve into adding custom columns using M language, creating and storing queries, and linking queries to Excel worksheets for live updates. This course equips you with the skills to efficiently manage and transform data using Power Query.
Introduction to Power Query
Introduction to Relational databases
Shaping data
Transforming data
Adding Columns
Creating & Storing Queries
| Group discount | ||
| 1 place | £ 350 | n/a |
| 2 places | £ 700 | n/a |
| 3 places | £ 1050 | £ 956 |
| 4 places | £ 1400 | £ 1260 |
| 5 places | £ 1750 | £ 1558 |
| 6 places | £ 2100 | £ 1848 |
| 7 places | £ 2450 | £ 2132 |
| 8 places | £ 2800 | £ 2408 |
