Power Query and Get & Transform: Getting Started - eLearning

Get & Transform, also known as Power Query, enables you to get data from any source and transform that data into a usable format.

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 are a novice Get & Transform user, this course will take you to a level where you are comfortable navigating and using the features of the Get & Transform panel. You will learn how to connect to different sources, including CSV files and web data, as well as understanding different data transformations, such as appending queries, and merging join types.

Upon satisfactory completion of this activity you will be able to:
• Confidently navigate the Get & Transform features.
• Connect different data sources and load them into Power Pivot, Excel or Power Query.
• Append and merge queries for easier analysis.
• Change the structure and layout of tables into a format you can work with.

Benefits:
Learning how to use Power Query and spend less time manipulating data and more time analysing it to gain powerful insights and make better decisions.