Power BI® – Data Cleaning and Transformation – From Raw and Poor to Report-Ready (OnDemand Webinar)

$149.00

SKU: 411445EAU

Description

Learn how to prepare and format data in Power BI for professional looking reports.It’s a known fact that raw data loaded into Power BI is hardly ever reportready and requires ‘cleaning’ to make it useable.Unnecessary rows and columns need to be removed, data that isn’t required needs to be filtered out, dates are never in the right format and often aren’t even dates, columns require splitting or merging, ‘weird’ characters must be removed. These are just a few examples of what is meant by data cleaning.If you’ve mastered the basics of Power BI and the phrase ‘it’s taking too long’ describes how you feel about the time it takes to get your raw data into the right format for your reports, this training is for you.

Date: 2024-10-24 Start Time: End Time:

Learning Objectives

An Introduction to the Power BI® Query Editor

Managing Query Steps

Removing Columns From Your Imported Data

Splitting a Single Column Into Multiple Columns

Applying Filters

Cleaning Date-Based Data

Cleaning Text-Based Data

Calculations Without Formulas • the Power of the Query Editor Ribbon

Unpivot • the Hidden Gem and Unsung Hero of the Query Editor

ASAP PACE ,IAAP ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Mike Thomas-theexceltrainer.co.uk