In this session we'll see how Power Query, and the M formula language it runs on, can be used to connect to different data sources; and transform, restructure, and combine them into into a Data Model that can then be analyzed in Power Pivot or Power BI.