Power BI Advanced - Power Query - 22/05/2024
In Short
- Mechelen
- 650
- 22/05/2024
- 1 day
Any questions?
Get in touch with our expert, we’ll be happy to help and answer all your related questions.
Power Query is a Microsoft ETL (extract, transform and load) tool, that can be used to wrangle data to a more useful format. It can be used in Power Bi Desktop, Excel, Power Bi Dataflows and various Azure products.
In the Power BI Advanced – Power Query training, we will first briefly explore Power Query using the graphical user interface as a recap. More advanced functionality can be unlocked only by coding it yourself, which is easier than one might think backed with some theoretical introduction on how to read (and write) the M (mashup) language that power query employes.
The topics of this one-day course are:
- What, why, where is ETL and Power Query
- No / low code exercise
- Debugging
- Understanding M-Language
- Query folding
- Advanced exercises
The training contains an integrated exercise that turns theory into practice.
It is strongly recommended to have some prior knowledge using the Power Query graphical user interface. Check out or Excel Advanced for Business or Power BI Advanced – Data Model training to gain the prerequisite experience if needed.
At the end of the training you will be equipped to use Power Query effectively. Armed with the knowledge of what is possible using the graphical user interface or via coding and the references to find out the exact syntax, you will be able to build almost any transformation you require.
We can provide a virtual machine with all the required software and files.
If you want to work with on your local machine make sure you have installed:
- Windows (Power BI does not run on Mac)
- Power BI Desktop (Required)
- Excel (Recommended)
- OneDrive (Recommended)
Cancellation conditions
- until 2 weeks upfront: 100% refund
- until 1 week upfront: 50% refund
Looking for more information? Do not hesitate to contact us.
Register here
Register today for this training and we'll get in touch.