Power Query: Data Chemistry for the Masses

Share URL
Embed Code
Share by Email
Send to social websites
Report this video as inappropriate You can report this video if you think it to be inappropriate, we will review your submission soon. If your reason is not listed here, like copyright infringements, please contact us directly by email. Select your reason
Sexual Content Violent or Repulsive Content
Hateful or Abusive Content Harmful Dangerous Acts
Child Abuse Spam
Uploaded by Keith on 8/5/2015
ETL Developers have being doing chemistry with data for years in tools like SQL Server Integration Services. These tools require training, experience, and time that few business users have. But in the age of self-service BI, those business users need a way to shape data to support their analysis. This session will show how Power Query can be easily used to take advantage of data's properties to drive the change we need to support our goals. We will discuss/demonstrate: -- The simple process of accessing a wide variety of data sources -- The ease with which simple transformations can be achieved using the Power Query Ribbon -- Power Query's fantastic ability to travel through time to see every step taken with the data -- The foundations of the Power Query Formula Language, informally known as ""M"" -- Using ""M"" to take Power Query WAY beyond what the Ribbon has to offer.
Comment
Login to share your thoughts on this video, if you do not have an account please Register first.