Microsoft Power BI - Use Power Query to Transform Your Data
Available Anytime
Location:
Online
2Credits
Technical Business
Registration is Open
FICPA Members
Nonmembers
$69.00 Regular Price
Product Code: AI23-PWRBI5
Level: Overview
Vendor: AICPA CPE Division
Field of Study: Computer Software and Applications
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.
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.
Major Topics:
Key Topics
- File maintenance
- Custom columns
- Un-pivoting a table
- Look-up tables