Power BI – Use Power Query to Transform Your Data (2 hours)

Overview

This webcast, part of the 2020 Power BI series, focuses on using Power Query (Get and Transform) to clean, shape and transform your messy data while still allowing you a one-click refresh.

Highlights

Append files
Combine multiple files from a folder
Add custom columns
Unpivot a table
Create a lookup table from a table

Prerequisites

Attended the Prepare Your Data Efficiently for Excel Analysis course or equivalent

Designed For

Anyone who uses or wants to use Excel for data analysis

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

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!