AI Engineer - Learn how to integrate AI into software applications
Master Finance Tools - 35% Off CFI (Code CFI35)
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