Power Query and Get & Transform: Intermediate

by

Take your knowledge and application of Power Query and Get & Transform Data to the next level. This course looks at adding custom, index and conditional columns, covers the basics of JSON and M (Mashup), and explores the uses of parameters and custom functions.

£100 +VAT

4 CPD hours

120 days’ access

Use ACPD101 for 10% off any purchase.

Power Query and Get & Transform: Intermediate

£100 +VAT

4 CPD hours 120 days’ access
Use ACPD101 for 10% off any purchase.

Power Query and Get & Transform: Intermediate

This course is not currently available. To find out more, please get in touch.

This course will enable you to

  • Add custom, index and conditional columns to your data, and use the Column From Examples feature.
  • Confidently transform data structures. such as records, lists and JSON.
  • Learn how to duplicate queries and change source data in reports.
  • Understand the basics of reading, writing and using Mashup (M).
  • Use parameters and custom functions to create dynamic reports in Power Query and explore the various uses of parameters.

About the course

As an accountant, organising and analysing data are important skills that you need to get jobs done. Organisations often have a vast quantity of data that comes in different forms, so it can be difficult to effectively organise data and analyse it. Using Get & Transform you can connect, combine and transform your data, so it’s easier and faster to analyse.

If you’re looking to take your knowledge and application of Power Query to the next level, this course will enable you to do just that. You will look at adding custom, index and conditional columns, as well as using the Column from Examples feature. This course also covers the basics of JSON, working with records and lists, duplicating queries, and changing the source file. It explores the uses of parameters and custom functions.

Contents

Additional Columns

Welcome
Columns From Examples
Custom columns
Index columns
Index and custom columns: the solution
Conditional columns
Other column types
Custom date calendar: the solution

Data Structures

Welcome
Records and lists
JSON data
Connect to JSON
Parse JSON
Parsing JSON: the solution
Getting file names from a folder
Duplicate or reference a query
Transforming data: the solution

Mashup (M)

Welcome
M
Read and write M
Create lists, records and tables with M
Using M in a custom column
Merging files: the solution

Parameters and Custom Functions

Welcome
Parameters
Filter a query
Custom functions
Driving queries
Connecting to data sources: the solution

How it works

Author

Paula Guilfoyle

Paula Guilfoyle

Paula practiced in Industry for over 15 years, working with both small and large private companies, before moving on to teach Excel and Power BI to accountants and professionals.