Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

How to Clean, Merge, and Transform Data in Power BI

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master essential data preparation techniques in this comprehensive 39-minute Power BI tutorial that covers the fundamental skills needed to clean, merge, and transform raw data into analysis-ready datasets. Learn to clean messy data by removing inconsistencies and errors, change data types to ensure proper formatting, and split or merge columns to restructure information effectively. Discover how to maintain data integrity throughout the transformation process and group data for meaningful analysis. Explore advanced techniques for transforming Excel tables into Power BI-compatible formats and unpivot data to convert wide tables into long format for better visualization and analysis. Follow along with downloadable exercise files to practice each technique hands-on, building a strong foundation for creating accurate and reliable Power BI reports and dashboards.

Syllabus

00:00:00 - Course Introduction
00:01:56 - Introduction to Power BI
00:05:49 - Clean Up Data and Change Data Types
00:13:28 - Splitting and Merging Columns
00:18:18 - Data Integrity
00:20:08 - Grouping Data
00:26:46 - Transform Excel Tables
00:35:23 - Unpivot Data

Taught by

Simon Sez IT

Reviews

Start your review of How to Clean, Merge, and Transform Data in Power BI

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.