• Home
  • eLearning
  • Power Query and Get & Transform: Intermediate - eLearning

Power Query and Get & Transform: Intermediate - eLearning


This activity is published by accountingcpd.

All year round, and on every accountingcpd purchase you make, get 10% off  as a CA ANZ member. Just use code CAANZ101.

Please note you will be directed to accountingcpd to purchase this product

Take your knowledge and application of Power Query to the next level. This course looks at adding custom, index and conditional columns, as well as covering the basics of JSON and M (Mashup).
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.
No assessments required. 

No materials distributed.

No prerequisites.

EVENT DETAILS


Topic: Business Mindset

Sub-Topic: Information & Communication Technology

Format: eLearning

Proficiency Level: Intermediate, Advanced

CPD: Upto 4 hours