Data Extract, Transform, and Load in Power BI

This course is part of Microsoft Power BI and Power Platform for Productivity Specialization

Instructor: Microsoft

Access provided by Abu Dhabi National Oil Company

3,267 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

20 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

20 reviews

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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

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 subject-matter expertise

This course is part of the Microsoft Power BI and Power Platform for Productivity Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

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

There are 4 modules in this course

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.

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