If you are wondering, “I don’t know Power Query M, but can I still wrangle my data?” , the answer is yes! Power Query Editor in Power BI Desktop has several options to wrangle your data with little expertise on Power Query M. This session will cover and introduction to Power Query Editor and a demo on how to profile, clean, prepare & enrich data in Power Query Editor.
Profile data : Understand your data
Clean data : Find and replace, drop fields not required, remove outliers
Prep/enrich data : add/compute new fields, structure your data, merge datasets
Type : Light on slides, heavy on demo
This session is perfect for those who want to get started with using Power Query Editor for wrangling data.