Microsoft Power BI - Use Power Query to Transform Your Data

Clean, shape, and transform your data. 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. Outcomes: 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