Clean, Transform & Load Data in Power BI (C63931)

Log In to Register

Cancellation Policy

Please note that this webinar Is from a third party vendor, CPA Crossings. We strongly recommend registering no later than one-hour before the webinar begins. Please contact CPA Crossings webinar hotline if you do Not receive your webinar invitation via email within five minutes after registering:  877-370-2220 ext. 1. Thank you.

Date(s):

08/07/2024

Registration Open:

12:00 AM - 1:30 PM

Time:

1:30 PM - 3:30 PM

Facility:

 Online

Meeting Type:

Webinars

CPE Credit:

2.00

Field(s) Of Study:

Computer Software and Applications (2.00)

Level of Knowledge:

Basic

Price:

Member: $89.00
Nonmember: $109.00

Individual Discounts:

Not Available

Overview

After attending this presentation you will be able to ...

  • Identify the key features and functionalities of Microsoft Power Query.
  • Distinguish between different data transformation techniques in Power Query, including data cleaning, merging, and pivoting.
  • Indicate the best practices for documenting each step in your data transformation process.

Highlights

The major topics that will be covered in this class include:

  • Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.
  • Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.
  • Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.
  • Data Loading: Efficiently loading data into the Power BI data model.
  • Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.

Speaker(s)

Prerequisites

None