Next Meeting: Wed, Aug 19 2015
JSSUG Monthly Meeting - August 19, 2015
Event Type: In-Person
Online Meeting URL: None
Monthly user group meeting
UTC : Wed, Aug 19 2015 22:00 - 00:00
Event Time : Wed, Aug 19 2015 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Wed, Aug 19 2015 22:00 - 00:00
3105 Beach Blvd
M Query Basics for Power Query
Devin Knight, BI Consultant Pragmatic Works
Power Query is a powerful data transformation tool that allows for self-service data extraction all within a familiar toolset: Excel. While Power Query does have a user interface that allows for simple transformations to be applied, you may find some scenarios require you to go beyond what is provided in the UI and actually write your own code. M is the query language that powers the data transforms utilized by Power Query. This session will guide you through the basics of using the language and show you some real world applications on why you might need to write your own M.
Devin Knight a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of six SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the Vice President of the local users group (JSSUG).