Extract, Transform and Load Data in Power BI

This course is part of Microsoft Power BI Data Analyst Professional Certificate

Instructor: Microsoft

Access provided by Innovecs

114,863 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

1,029 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

4 modules

Gain insight into a topic and learn the fundamentals.

1,029 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.

Skills you'll gain

Tools you'll learn

Power BI

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

19 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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 videos16 readings5 assignments3 discussion prompts

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

16 readings Total 185 minutes

Course Syllabus 10 minutes
How to be successful in this course 10 minutes
How to open an image in a new tab 10 minutes
Setting up your Power BI environment 10 minutes
New name for Power BI datasets 10 minutes
How to locate your downloaded files 10 minutes
Additional Resources: Data sources in Power BI 5 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 5 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

3 discussion prompts Total 30 minutes

Discussion prompt: What do you hope to learn? 10 minutes
What challenges did you encounter while configuring storage modes? 10 minutes
How can stakeholders benefit from triggers and actions? 10 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

(276 ratings)

Microsoft

287 Courses 2,320,610 learners

Offered by

Microsoft

Why people choose Coursera for their career

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."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

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."

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.53%
4 stars
15.72%
3 stars
4.66%
2 stars
1.84%
1 star
2.23%

Showing 3 of 1029

Reviewed on Jan 8, 2024

Focus a little more on examples and hand-on exercises rather than ultra specific definitions or concepts. Some questions are false just because on one word.

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

Reviewed on Nov 7, 2023

Very Good rhythm and structure of the information, but a couple of quizz questions are a bit debatable

View more reviews