Extract, Transform and Load Data in Power BI

Beginner Level
4 hours to complete
Flexible Schedule

Microsoft

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.

Skills You’ll Gain

Data Cleansing Data Validation Data Integration Data Storage Extract, Transform, Load Data Transformation Data Quality Power BI Business Intelligence Data Storage Technologies Data analysis

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile.

Develop Your Specialized Knowledge

Learn new concepts from industry experts

Gain a foundational understanding of a subject or tool

Develop job-relevant skills with hands-on projects

Earn a shareable career certificate from Microsoft

There are 4 modules in this course

In this module, you'll set up data sources and explore the different data source capabilities in Power BI.

In this module, you'll practice cleaning and transforming data to prepare for data modeling in later courses.

In this module, you'll gain an understanding of the load portion of the ETL process and practice data profiling and advanced queries.

In this module, you'll be assessed on the key skills covered in the course.