Microsoft Power BI - Use Power Query to Transform Your Data

Clean, shape, and transform your data. This is the fifth course in the Microsoft Power BI series. This course focuses on using Power Query to clean, shape, and transform data while still allowing you a one-click refresh. The course will review various data issues including appending files, combining multiple files from a folder, adding custom columns, un-pivoting data, and creating a lookup table. The course is resented using Excel 2019, but most concepts covered in this course apply to all versions of Excel. This self-study online course is part of the Microsoft Power BI: Power BI Series. Learning Objectives: Use Power Query to solve your data clean-up issues. Determine how Power Query allows you to get more data into Excel. Apply a one-click step to refresh your data. Field of Study: Computer Software and Applications Level: Overview CPE 2