Excel includes a powerful new feature called Power Query also known as Get & Transform, which provides compelling data gathering and cleansing capabilities. This course shows you the many uses of Power Query by explaining what it is, and how its data handling features differ from the Excel functions.
We look at importing data into Power Query from various sources, and work with Power Query formulas called M to perform powerful data analyses. You will merge and cleanse data from multiple tables, and pivot data to examine it from a variety of angles.
At the end of the lesson we look at using Power Query in Power BI Desktop, which has a rich set of features available for data shaping, enabling the creation of sophisticated data models. Looking at steps required to connect to data sources and review basic data cleansing and modelling.
Attendees are required to be Excel users before joining this Power Query course.