Power Query and Get & Transform: Intermediate - eLearning

As an accountant, you know that organisations often have a vast quantity of data. That data will often be in many different forms, from lists to reports, so it can be difficult to organise and analyse. Using Get & Transform you can connect, combine and transform your data, so that it meets your analysis needs.

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.


Upon satisfactory completion of this activity you will be able to:
•Add custom, index and conditional columns to your data.
•Confidently transform data structures.
•Understand the basics of reading and writing Mashup (M).
•Use parameters and custom functions.


Benefits:
Elevate your Power Query skills by going beyond simple use cases and using it in more sophisticated ways.