Advanced Data Transformation with Power Query

This Deep technical session is about applying advanced transformation through M language. M is the formula language of the Power Query. M is much more powerful than the Power Query GUI functions. In this session you will learn more about top functionality of M that does not exists in the GUI, but they are very helpful in ETL implementation. features such as error handling, working with generators, custom functions... would be discussed in this session. You will also see lots of real world live demos. as a sample a date dimension with fiscal calendar attributes and public holidays fetched live would be discussed deeply in this session.
Presented by Reza Rad at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Reza_Rad.jpg

    Reza Rad is an Author, Trainer, Speaker and Senior DW/BI Consultant. He has a BSc in Computer engineering; he has more than 10 years' experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for four continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.rad.pasfu.com .

    He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCTS and MCITP of BI. He is the leader of New Zealand Business Intelligence users group.

    He is a Technical Speaker in SQL Saturday and SQL users groups and Conferences like TechEd and PASS Summit. And He is a Microsoft Certified Trainer.

    http://www.rad.pasfu.com http://rad.pasfu.com/index.php?/feeds/index.rss
  • Video
    The video is not available to view online.