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鈥檒l also have the opportunity to inspect and analyze ingested data to ensure data integrity. After completing this course, you鈥檒l 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
The Staging Area in Power BI
Loading...
Skills You'll Learn
Data Analysis, Data Validation, Data Manipulation, Query Languages, Power BI, Anomaly Detection, Data Import/Export, Extract, Transform, Load, Data Cleansing, Data Quality, Data Storage, Data Modeling, Data Transformation, Data Integration
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