Prepare to be amazed with what you can achieve using Power Query in this demo-heavy session. Power Query is the data extraction, transformation, and mash up tool. It can be accessed through Excel or from Power BI Desktop. There are numerous data transformation features that can be used to solve real-world data preparation challenges. We will show many demos to go through scenarios of preparing data for modelling, and visualization. You will learn how to use features of Power Query such as generators, custom functions, and lots of built-in functions to solve those scenarios. You will also learn some data preparation techniques through Excel itself.
Reza Rad is an author, trainer, speaker, and consultant. He has been a Microsoft Data Platform MVP for six years, specializing in Microsoft Business Intelligence and data movement. Reza has worked with Microsoft BI technologies more than 15 years. He is an MCP, an MCT, and co-leader of the New Zealand Business Intelligence Users Group. He has previously published, and is currently writing, several books. You can find his technical articles on his blog at http://www.radacad.com.
He is author of books: SQL Server Integration Services, Microsoft SQL Server 2014/16 BI, Power BI online book from rookie to rock star, and author of Channel 9 SSIS tutorial video series. he speaks in many conferences listed on his website's presentation section.