This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you will learn the process of Extract, Transform and Load or ETL. You will identify how to collect data from and configure multiple sources in Power BI and prepare and clean data using Power Query. You’ll also have the opportunity to inspect and analyze ingested data to ensure data integrity. After completing this course, you’ll be able to: • Identify, explain and configure multiple data sources in Power BI • Clean and transform data using Power Query • Inspect and analyze ingested data to ensure data integrity This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.
Introduction to data profiling
Loading...
Skills You'll Learn
Data Analysis, Data transformation, Data Configuration, power bi, Power Query
Reviews
4.5 (383 ratings)
- 5 stars71.54%
- 4 stars17.75%
- 3 stars5.74%
- 2 stars2.61%
- 1 star2.34%
SM
Dec 13, 2023
Successfully executed ETL processes in Power BI, ensuring seamless data extraction, transformation, and loading for effective analysis
VK
Oct 14, 2023
I already have some experience working with Power Query integrated into MS Excel, but I still found this course quite valuable
From the lesson
Advanced ETL in PowerBI
In this module, you'll gain an understanding of the load portion of the ETL process and practice data profiling and advanced queries.
Taught By
Microsoft