Webinar: Clean, Transform & Load Data in Power BI

WC261  |  Course  |  Basic  |  Scheduled

Description

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data be

Credits

Number of Credits Type of Credits
2.00 Computer Software & Applications

Designed For

This course is ideal for accounting professionals, financial analysts, and anyone who regularly works with data and seeks to improve their skills in data management and analysis using Power Query.

Prerequisites

None

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.

Objectives

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.

Preparation

Download the handout and practice material prior to course

Notes

Webinar Day - HELP and Assistance Instructions

  1. The session will open 30 minutes prior to the start time. At that time, you will receive a reminder email bringing you to your Attendee Dashboard and a link to join the webinar.
  2. We recommend you log in early to ensure you are ready to go when the presentation begins.
  3. IF YOU ARE HAVING TROUBLE LOGGING INTO THE WEBINAR, please call the CPA Crossings Customer Service Team at (877)-370-2220 Ext. #1.

Prices

Member (Early Bird)
$89.00
Non-Member (Early Bird)
$89.00
Member
$89.00
Non-Member
$89.00
Your Price: $89.00

This is your base price and does not reflect any additional session fees, optional add-ons, or guest registrations.