Data Transformation using Power Query Editor, Power BI Desktop – 1 Day

Pre-requisites
There are no formal pre-requisites required however the material would be appropriate for an intermediate Excel user.
Power Query is a data transformation tool used in both Excel and Power BI Desktop. It is an evolving technology and has undergone substantial revision under Microsoft ownership. Only Excel 2016+ is feature compatible with Power BI Desktop. This course targets the current implementation of Power Query for both Power BI Desktop and Excel.
Data Transformation using Power Query is delivered as a standalone course but those users of Power BI Desktop who are heavily involved in data preparation or anticipate having to correct it should see this as a pre-requisite.

Learning Outcomes
At the completion of this course you should have the skills and knowledge to:

• Assess data and manipulate it to for use within the Data Model for both Excel and Power BI Desktop.
• Understand M syntax, definitions and objects and use them to develop advanced transformation processes.
• Understand and use a variety of operations and functions available within M.
• Use parameterised queries as functions and invoke them.

Additional Course Information

Face-to-Face Available for Canberra or Webinar.

Price: $565 

Available Dates:

27th September 2024

30th October 2024

When registering for this course you are agreeing to the following cancellation/reschedule policy.
Cancellation/Reschedule Policy
To re-schedule or cancel a booking, please notify Wizard with 5 full working days’ notice, prior to the commencement of the course.
*Cancellation is required in writing*
– Should we receive less than 5 full working days notice, the full course costs will be charged.
– We are happy to accept a substitution prior to the commencement of the course.
– Substitutions must have application knowledge at the appropriate level.
– If unable to attend due to sickness, a free se-sit will be offered if a medical certificate can be provided.