In this demo-heavy session Reza Rad will show what you can achieve using Power Query, the data extraction, transformation, and mash up tool. Power Query can be accessed through Excel or from Power BI Desktop, and has numerous data transformation features that can be used to solve real-world data preparation challenges.
Reza will use customer case studies to go through scenarios of preparing data for modelling and visualization. In this webinar you will learn:
How to use features of Power Query such as generators and custom functions
What built-in functions are available to solve your data challenges
Data preparation techniques through Excel
... and much more!