LARA MELLOR TRAINING & CONSULTANCY

Microsoft Power BI: MORE ADVANCED Querying

Do you need to arrange your data in Microsoft Power BI in a certain layout before creating any visualisations? Would you like to learn some of the more advanced techniques to help you do that?

Using Microsoft Power BI queries can allow you to analyse the data in many different ways and change how the information is formatted without affecting the underlying information.

The ‘more advanced querying’ module of Lara Mellor Training and Consultancy’s Microsoft Power BI training courses is designed to help you to make use of some of the more sophisticated features to rearrange your data so it is in the correct layout and format to be used as a basis for any visualisations.

You will learn:

  • How append and merge queries can amalgamate tables together
  • How to pivot or unpivot your data if the layout is incorrect
  • When group by can be used to summarise your data
  • How to add columns containing basic and more advanced calculations

Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and learn valuable skills that they will be able to use within your business straight away.

Ready to get started?

Get in touch today to book your Microsoft Power BI training.

Remember, you can pick and choose your own modules to be sure your team gets the best out of the training and can learn valuable skills that they’ll be able to use within your business straight away.

INTERESTED IN MULTIPLE COURSES?

If you’re looking to book courses in Word, Excel, PowerPoint or other Microsoft programmes, please get in touch via our general training enquiry form here.