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
This course is part of Microsoft Power BI Data Analyst Professional Certificate
Instructor: Microsoft
125,050 already enrolled
Included with
Learn more
Ask Coursera
1,062 reviews
Recommended experience
1,062 reviews
Recommended experience
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
19 assignments
See how employees at top companies are mastering in-demand skills
Build your Data Analysis expertise
- 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
Offered by
Explore more from Data Analysis
- Status: Free Trial
Course
- Status: Free Trial
Course
- Status: Free Trial
Course
- Status: Free TrialM
Microsoft
Course
Why people choose Coursera for their career
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
Reviewed on Oct 28, 2023
Great course. Appreciated the instructor's relaxed but direct presentation style!
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 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.
More questions
Financial aid available,
