April 24, 2025


Webinar


2 CPE

Webinar (CPA Crossings): Clean, Transform & Load Data in Power BI 🗓️

April 24, 2025
Webinar
2 CPE

Webinar (CPA Crossings): Clean, Transform & Load Data in Power BI 🗓️

  • View Bio

    Instructor

    Bryan
    Smith

    View Bio

Learning 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.

Major Topics

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.

CPE Credits Available

2 CPE
2
Computer Software & Applications

Things to Know About This Course

Course Level

  • Basic

Professional Area of Focus

  • Technology

Prerequisites

None

Advanced Preparation

Download the handout and practice material prior to course This webinar is produced by CPA Crossings. You will receive your login link/instructions and Certificate of Attendance directly from this third-party vendor. It is important that you review your COCPA confirmation for details on receiving your login instructions and COA from said vendor.

Intended Audience

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.

Provider

CPA Crossings, LLC

Register For This Event

  • COCPA Member

    $ 89 89
    Join
  • COCPA Non-Member

    $ 116 116
    Your Price

Please login to register.