Thanks to all attendees of my session in TechDays 2014 Hong Kong about Advanced Data Transformations with Power Query.
Here is session Title, Description, and presentation file;
Advanced Data Transformations with Power Query
Power Query is the self-service data consolidation tool of the Power BI embedded in Excel. Power Query has ability to fetch data from variety of data source, and apply transformations through Power Query Formula language known as M. This session covers advanced transformation samples of M formulas to solve real world data consolidation challenges. Many of useful Power Query formula functions with live demos will be explored through this session.