Top 5 Functionalities of Power Query that You Don't Know

Date/Time
Date(s) - 29/07/2015
5:30 pm - 8:00 pm

Location
Microsoft Auckland

Category(ies)

• User Group Meetings

Session Description:

Power BI is hot topic nowadays, Power Query is one of the main components of Power BI. Join this session to learn about applying advanced transformation through M language. M  is the formula language of the Power Query and is much more powerful than the Power Query GUI functions.
In this session, you will learn more about the top functionality of M that does not exist in the GUI, but is very helpful in ETL implementation. Features such as error handling, working with generators, and custom functions will all be discussed.
You will also see lots of real-world live demos, one of which will be sample a date dimension with fiscal calendar attributes and public holidays fetched live.

Speaker:

Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years' experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for five 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: https://www.radacad.com/blog (previously was https://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, MCSE and MCITP of BI. He is the leader of New Zealand Business Intelligence users group.
He is a International Speaker in SQL Saturday and SQL users groups and Conferences like TechEd and PASS Summit. And He is a Microsoft Certified Trainer.