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.
Speakers
Laura Graham-Brown's previous sessions
How to improve Q&A in Power BI
In this session we will go through a number of techniques to get closer to that natural language that Q&A visuals offer.
Making Dungeons and Dragons Accessible
Can we make the complex Dungeons and Dragons character sheet accessible using Power BI and low-code solutions? Lots of demos and banter between these speakers
Bringing Power BI into the Dataverse (and bringing Dataverse into Power BI)
Make the most of the data in Dataverse-based Microsoft Power Apps and Dynamics 365 with Power BI.
Gathering Report Requirements
How do we as report builders understand what our customers want and need in a report.
Power BI Charticulator
Come and learn this low-code tool to create your own visuals in Power BI
Power Query is taking over
This session will Power Query which is now a must for the keen citizen developer.