M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code.  Knowledge of this language opens doors that remain closed if you only use the GUI.
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.
See how to use Power Query to build a detail-level reporting solution
Join us to go beneath the UI, to learn how to unlock the full power of the underlying query engine and the formula language, and to truly conquer your data and data-shaping needs.
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
Learn how XLCubed unlocks the value of Multi-dimensional and Tabular SSAS and SQL for power users in Excel; providing pixel perfect delivery of reporting, dashboards for both Web and Mobile and with or without SharePoint.
PowerBi is hot. This session starts with an empty Excel workbook and walks you via Power Pivot and Power Query to Power View and Power Map.
Explore Power Query features to import data from existing Corporate BI systems.
An in-depth session on advanced Power Query functionality and the M language
<<1>>