We may earn an affiliate commission when you visit our partners.

Extract, Transform and Load Data in Power BI

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.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

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.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Examines essential ETL concepts, including data sources, transformations, and analysis

Prepares learners for the Microsoft PL-300 exam, leading to the Microsoft Power BI Data Analyst certification

Taught by Microsoft, a leading provider of data analytics software

Part of the Microsoft Power BI Analyst Professional Certificate, providing a structured learning path

Requires no prerequisites, making it accessible to learners with varying backgrounds

Emphasizes hands-on practice through Power Query, fostering practical skills

Save this course

Save Extract, Transform and Load Data in Power BI to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Extract, Transform and Load Data in Power BI with these activities:

Read a book on data analysis using Power BI

Show steps

Read a book on data analysis using Power BI to supplement your learning and gain a deeper understanding of the concepts covered in the course.

View Optimizing DAX: Improving DAX performance in... on Amazon

Show steps

Read the book
Take notes on key concepts
Apply the concepts to your own data

Review ETL process

Show steps

Review the steps involved in the ETL process to refresh your knowledge and prepare for the course.

Browse courses on ETL

Show steps

Read an article or blog post about ETL
Watch a video tutorial on the ETL process
Practice using an ETL tool

Join a study group for the course

Show steps

Join a study group for the course to connect with other students and discuss the course material.

Show steps

Find a study group
Attend study group meetings
Discuss the course material
Study together

Three other activities

Expand to see all activities and additional details

Show all six activities

Transform data using Power Query

Show steps

Practice transforming data using Power Query to reinforce your understanding of data manipulation techniques.

Browse courses on Power Query

Show steps

Find a dataset to work with
Load the dataset into Power Query
Transform the data using Power Query functions
Save the transformed data

Explore advanced ETL techniques in Power BI

Show steps

Follow a guided tutorial to explore advanced ETL techniques in Power BI and expand your knowledge of data integration.

Browse courses on Data Profiling

Show steps

Find a guided tutorial on advanced ETL in Power BI
Follow the tutorial step-by-step
Apply the techniques to your own data

Create a Power BI report using the ETL techniques learned

Show steps

Create a Power BI report using the ETL techniques you learned in the course to demonstrate your understanding and apply them directly to data analysis.

Browse courses on Data Visualization

Show steps

Gather data from multiple sources
Transform and clean the data using Power Query
Create a Power BI report
Analyze the data and create visualizations

Career center

Learners who complete Extract, Transform and Load Data in Power BI will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts collect, clean, and interpret data to help businesses make informed decisions. This course provides a solid foundation for a career as a Data Analyst by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts use data to identify and solve business problems. This course can help you build a strong foundation for a career as a Business Analyst by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Business Analyst

Data Scientist

Data Scientists use data to develop predictive models and insights. This course can help you build a strong foundation for a career as a Data Scientist by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Scientist

Data Engineer

Data Engineers design, build, and maintain data systems. This course can help you build a strong foundation for a career as a Data Engineer by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators manage and maintain databases. This course can help you build a strong foundation for a career as a Database Administrator by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Database Administrator

Data Architect

Data Architects design and implement data architectures. This course can help you build a strong foundation for a career as a Data Architect by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Architect

Software Engineer

Software Engineers design, develop, and maintain software applications. This course can help you build a strong foundation for a career as a Software Engineer by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Software Engineer

Information Architect

Information Architects design and manage information systems. This course can help you build a strong foundation for a career as an Information Architect by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Information Architect

Data Modeler

Data Modelers design and implement data models. This course can help you build a strong foundation for a career as a Data Modeler by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Modeler

Data Librarian

Data Librarians manage and curate data. This course can help you build a strong foundation for a career as a Data Librarian by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Librarian

Data Governance Analyst

Data Governance Analysts develop and implement data governance policies. This course can help you build a strong foundation for a career as a Data Governance Analyst by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Governance Analyst

Data Quality Analyst

Data Quality Analysts ensure the quality of data. This course can help you build a strong foundation for a career as a Data Quality Analyst by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Quality Analyst

Data Integration Specialist

Data Integration Specialists integrate data from multiple sources. This course can help you build a strong foundation for a career as a Data Integration Specialist by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Integration Specialist

Data Visualization Specialist

Data Visualization Specialists create visual representations of data. This course may be helpful for aspiring Data Visualization Specialists by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Data Visualization Specialist

Database Designer

Database Designers design and implement databases. This course may be helpful for aspiring Database Designers by teaching you how to extract, transform, and load data using Power BI. You'll learn how to identify and configure multiple data sources, clean and transform data using Power Query, and inspect and analyze ingested data to ensure data integrity.

See salaries and explore the career path for Database Designer

Reading list

We've selected 13 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Extract, Transform and Load Data in Power BI.