Microsoft Power BI - Use Power Query to Transform Your Data
Available Until
**OnDemand**
2.0 Credits
Member Price $59.00
Non-Member Price $69.00
Overview
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.
Highlights
Key Topics
- File maintenance
- Custom columns
- Un-pivoting a table
- Look-up tables
Prerequisites
Attended the Prepare Your Data Efficiently for Excel Analysis course or equivalent
Objectives
Learning 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.
Non-Member Price $69.00
Member Price $59.00