Laura Graham-Brown
hatfullofdata.blog
Passionate energetic speaker who has been enjoying playing with data for many years. Freelance trainer, speaker and agony aunt. Microsoft MVP
SQLBits 2020
Power Query is taking over
This session will Power Query which is now a must for the keen citizen developer.
An ever-popular tool for data analysts, Power Query first made an appearance in Excel and quickly became the engine behind PowerBI. More recently it has appeared in Microsoft Flow as an extension the SQL connector and a tool for CDS. Providing the ability to transform data on the fly, understanding Power Query and the Language M is now an important skill for the keen citizen developer.
In this session we will look at how to transform data ready for your PowerApp or Flow and how to get Power Query to work it’s magic without having to write complex queries in M. For those that do want to push the boundaries further, we’ll look at the options for diving into the M code itself for more powerful options.