This video examines advanced design techniques for building queries for Power BI using Power Query and the M formula language. The video demonstrates designing queries to create imported datasets in Power BI Desktop as well as building queries to generate dataflows using Power Query in the browser. You will learn the fundamentals and syntax for writing query logic in M and you will also learn how to utilize advanced query techniques involving query parameters and self-joins as well as using function queries to extract data from a dynamic set of data files.