Data Extract, Transform, and Load in 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

• Data Sources in Power BI
• In this module, you'll set up data sources and explore the different data source capabilities in Power BI.
• Transforming Data in Power BI
• In this module, you'll practice cleaning and transforming data to prepare for data modeling in later courses.
• 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.
• Graded Assessment and Course wrap up
• In this module, you'll be assessed on the key skills covered in the course.