VOOZH about

URL: https://www.coursera.org/learn/extract-transform-and-load-data-in-power-bi

⇱ Extract, Transform and Load Data in Power BI | Coursera


Extract, Transform and Load Data in Power BI

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Extract, Transform and Load Data in Power BI

125,050 already enrolled

Included with

β€’

Learn more

Ask Coursera

Gain insight into a topic and learn the fundamentals.
4.6

1,062 reviews

Beginner level

Recommended experience

Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace
92%
Most learners liked this course

Gain insight into a topic and learn the fundamentals.
4.6

1,062 reviews

Beginner level

Recommended experience

Flexible schedule
2 weeks at 10 hours a week
Learn at your own pace
92%
Most learners liked this course

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. 

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

19 assignments

Taught in English

Build your Data Analysis expertise

This course is part of the Microsoft Power BI Data Analyst Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
  • 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

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.

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

What's included

9 videos12 readings5 assignments

9 videosβ€’Total 52 minutes
  • Course Introductionβ€’5 minutes
  • How combining data sources gives business insightsβ€’5 minutes
  • Setting up a flat data sourceβ€’4 minutes
  • Storage modes in Power BIβ€’7 minutes
  • Configuring storage modes in Power BIβ€’4 minutes
  • Structured vs. unstructured dataβ€’7 minutes
  • What are connectors?β€’7 minutes
  • Triggers and actionsβ€’7 minutes
  • Module summary: Data sources in Power BIβ€’5 minutes
12 readingsβ€’Total 165 minutes
  • Course Syllabusβ€’10 minutes
  • Setting up your Power BI environmentβ€’20 minutes
  • Additional Resources: Data sources in Power BIβ€’10 minutes
  • Data Sources supported by Power BIβ€’10 minutes
  • Local datasets vs. shared datasetsβ€’10 minutes
  • Exercise: Setting up an Excel data sourceβ€’30 minutes
  • Exemplar: Setting up an Excel data sourceβ€’10 minutes
  • Walkthrough: Setting up your storage modeβ€’10 minutes
  • Additional resources: Basic data sourcesβ€’10 minutes
  • Exercise: Implementing triggersβ€’30 minutes
  • Exemplar: Implementing triggersβ€’10 minutes
  • Additional resources: Advanced data sourcesβ€’5 minutes
5 assignmentsβ€’Total 80 minutes
  • Self-review: Setting up an Excel data sourceβ€’10 minutes
  • Knowledge check: Basic data sourcesβ€’15 minutes
  • Self-review: Implementing triggersβ€’10 minutes
  • Knowledge check: Advanced data sourcesβ€’15 minutes
  • Module quiz: Data sources in Power BIβ€’30 minutes

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

What's included

13 videos15 readings7 assignments1 discussion prompt

13 videosβ€’Total 68 minutes
  • Why data needs to be transformedβ€’5 minutes
  • Introduction to Power Query and its interfaceβ€’6 minutes
  • The Applied Steps listβ€’5 minutes
  • Working with columnsβ€’6 minutes
  • Dealing with errors in Power Queryβ€’7 minutes
  • Unpivot and pivot columnsβ€’7 minutes
  • The Importance of data combinationβ€’4 minutes
  • Combining tables with appendβ€’4 minutes
  • What is a join?β€’4 minutes
  • Join typesβ€’4 minutes
  • Combining tables with mergeβ€’8 minutes
  • Identifying a new potential productβ€’3 minutes
  • Module summary: Transforming data in Power BIβ€’5 minutes
15 readingsβ€’Total 195 minutes
  • Data types in Power BIβ€’10 minutes
  • Evaluating and changing column data typesβ€’10 minutes
  • Common data errorsβ€’10 minutes
  • Exercise: Preparing a datasetβ€’30 minutes
  • Exemplar: Preparing a datasetβ€’10 minutes
  • Activity: Apply a pivotβ€’10 minutes
  • Additional Resources: Introduction to transforming data in Power BIβ€’5 minutes
  • The importance of matching column namesβ€’10 minutes
  • Exercise: Appending two tablesβ€’30 minutes
  • Exemplar: Appending two tablesβ€’10 minutes
  • Additional Resources: Advanced data transformations in Power BIβ€’5 minutes
  • Identifying join keysβ€’10 minutes
  • Exercise: Merging two data sourcesβ€’30 minutes
  • Exemplar: Merging two data sourcesβ€’10 minutes
  • Additional resources: Transformations by combining dataβ€’5 minutes
7 assignmentsβ€’Total 110 minutes
  • Self-review: Preparing a datasetβ€’10 minutes
  • Knowledge Check: Introduction to transforming data in Power BIβ€’15 minutes
  • Self-review: Appending two tablesβ€’15 minutes
  • Knowledge Check: Advanced data transformations in Power BIβ€’15 minutes
  • Self-review: Merging two data sourcesβ€’10 minutes
  • Knowledge check: Transformations by combining dataβ€’15 minutes
  • Module quiz: Transforming data in Power BIβ€’30 minutes
1 discussion promptβ€’Total 10 minutes
  • What challenges might you encounter when combining data?β€’10 minutes

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

What's included

12 videos12 readings5 assignments1 discussion prompt

12 videosβ€’Total 58 minutes
  • Introduction to loading dataβ€’4 minutes
  • The Staging Area in Power BIβ€’5 minutes
  • Introduction to data profilingβ€’5 minutes
  • Profiling Data in Power BIβ€’7 minutes
  • Vignette: Bad dataβ€’4 minutes
  • Best practices when working with Power Queryβ€’5 minutes
  • Introduction to dataflowsβ€’5 minutes
  • Introduction to Reference Queriesβ€’4 minutes
  • Reference queries and dataflowsβ€’4 minutes
  • Query parametersβ€’4 minutes
  • Using Advanced Editor to modify codeβ€’6 minutes
  • Module Summary: Advanced ETL in PowerBIβ€’5 minutes
12 readingsβ€’Total 145 minutes
  • End-to-end ETL process and Power BIβ€’10 minutes
  • Additional Resources: Loading data with Power BIβ€’5 minutes
  • Using the Data Profiling Toolsβ€’10 minutes
  • Exercise: Profiling a datasetβ€’30 minutes
  • Exemplar: Profiling a datasetβ€’30 minutes
  • Additional Resources: Data profiling in Power BIβ€’5 minutes
  • Activity: Import a dataset with best practicesβ€’10 minutes
  • Activity: Using reference queriesβ€’10 minutes
  • Helper Queriesβ€’10 minutes
  • Activity: Disabling helper queriesβ€’10 minutes
  • Global options for filesβ€’10 minutes
  • Additional Resources: Advanced queriesβ€’5 minutes
5 assignmentsβ€’Total 85 minutes
  • Knowledge Check: Loading data with Power BIβ€’15 minutes
  • Self-review: Profiling a datasetβ€’10 minutes
  • Knowledge Check: Data profiling in Power BIβ€’15 minutes
  • Knowledge check: Advanced queriesβ€’15 minutes
  • Module Quiz: Advanced ETL in PowerBIβ€’30 minutes
1 discussion promptβ€’Total 10 minutes
  • Which best practices did you find most useful?β€’10 minutes

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

What's included

2 videos4 readings2 assignments1 discussion prompt

2 videosβ€’Total 8 minutes
  • Course Recap: Extract, transform and load data in Power BIβ€’4 minutes
  • Congratulationsβ€’4 minutes
4 readingsβ€’Total 60 minutes
  • About the final project and assessment: Extract, transform and load data in Power BIβ€’10 minutes
  • Final Course Project: Transforming multiple data sourcesβ€’30 minutes
  • Exemplar: Transforming multiple data sourcesβ€’10 minutes
  • Next stepsβ€’10 minutes
2 assignmentsβ€’Total 108 minutes
  • Self-review: Transforming multiple data sourcesβ€’18 minutes
  • Course quiz: Extract, transform and load Data in Power BIβ€’90 minutes
1 discussion promptβ€’Total 10 minutes
  • Reflect on learningβ€’10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings
4.5 (280 ratings)
343 Coursesβ€’2,617,428 learners

Explore more from Data Analysis

Why people choose Coursera for their career

πŸ‘ Image

Felipe M.

Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
πŸ‘ Image

Jennifer J.

Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
πŸ‘ Image

Larry W.

Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
πŸ‘ Image

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

  • 5 stars

    75.44%

  • 4 stars

    15.80%

  • 3 stars

    4.51%

  • 2 stars

    1.88%

  • 1 star

    2.35%

Showing 3 of 1062

RA
Β·

Reviewed on Oct 28, 2023

Great course. Appreciated the instructor's relaxed but direct presentation style!

SV
Β·

Reviewed on Nov 13, 2023

The ETL process was taught in detail and how Power BI provides capabilities to create an End to End ETL process

DD
Β·

Reviewed on Aug 25, 2025

Very insightful and useful for any person who is achieving to become a data analyst

Frequently asked questions

This program is for you:

● If you want to switch or start a career in the field of data analytics.

● If you are interested in the field of data analytics, just beginning to work with business intelligence and data analysis solutions and services, or new to Microsoft Power BI.

You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.

It typically takes 5 months to complete the 8 courses. But some learners may go through the content faster.

Whether you’re looking to start a new career or change your current one, Professional Certificates help you become job ready. Apply your new skills on hands-on projects that showcase your expertise to potential employers and earn a career credential to kickstart your new career.

Once you have completed this Professional Certificate, you’ll have built a foundational knowledge of the key concepts and tools in Power BI and how they apply to a business environment including:

β€’ The ability to implement best practices when conducting Data Analysis.

β€’ The skills to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.

β€’ The ability to provide valuable data insights that help to inform business decisions.

Power BI Data Analysts design, develop, and deploy business analytics dashboards using Microsoft Power BI. Data analysts are essential in helping organizations gain valuable insights into the expanse of data that they have, and they work closely with others in the organization to help reveal valuable information.

Data analysts and business intelligence analysts both help drive data-driven decision-making in their organizations. Data analysts tend to work more closely with the data itself, while business intelligence analysts tend to be more involved in using the results of data analysis to address business needs and recommend solutions. The Power BI data analyst is a combination of both of these roles. They work closely with business stakeholders to identify business requirements and collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI. These are all highly sort after roles.

Prepare for a career as a data analyst using Power BI. The Power BI skills you learn in this program prepare you for an entry-level role as a data analyst. An entry-level role as a data analyst is a great starting point and can be the first step towards building a career as a business intelligence analyst, data scientist or data engineer.

This course is completely online. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.

We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses. The final course contains a practice exam that assesses your knowledge of the content covered in the previous courses. As such, it makes the most sense to take the courses in the order they are presented.

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Financial aid available,