Data Extract, Transform, and Load in Power BI
Microsoft
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
About this Course
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
What You'll Learn
- How to set up a data source and explain and configure storage modes in Power BI.
- How to prepare for data modeling by cleaning and transforming data.
- How to use profiling tools to identify data anomalies.
- How to reference queries and dataflows and use the Advanced Editor to modify code.
Instructors
Microsoft