Who is this program for?

<text variant="body1">This program is for you: <text variant="body1">● 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.

What background knowledge is necessary?

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.

How long does it take to complete the Professional Certificate?

<text variant="body1">It typically takes 5 months to complete the 8 courses. But some learners may go through the content faster.

What is the main benefit of a Professional Certificate?

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.

What will I be able to do upon completing the Professional Certificate?

<text variant="body1">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: <text variant="body1">• The ability to implement best practices when conducting Data Analysis. <text variant="body1">• 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.

What does a Power BI analyst do?

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 Analyst, Business Intelligence Analyst and Power BI Analyst: What’s the Difference?

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.

What jobs can I get with Power BI data analytics skills?

<text variant="body1">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.

Will I be able to complete this course online?

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

Do I need to take the courses in specific order?

<text variant="body1">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.

When will I have access to the lectures and assignments?

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.

What will I get if I subscribe to this Certificate?

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.

Extract, Transform and Load Data in Power BI

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Extract, Transform and Load Data in Power BI

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

Instructor: Microsoft

122,552 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

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

91%

of learners achieved a positive career outcome

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.

Module details

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 videosTotal 52 minutes

Course Introduction5 minutes
How combining data sources gives business insights5 minutes
Setting up a flat data source4 minutes
Storage modes in Power BI7 minutes
Configuring storage modes in Power BI4 minutes
Structured vs. unstructured data7 minutes
What are connectors?7 minutes
Triggers and actions7 minutes
Module summary: Data sources in Power BI5 minutes

12 readingsTotal 165 minutes

Course Syllabus10 minutes
Setting up your Power BI environment20 minutes
Additional Resources: Data sources in Power BI10 minutes
Data Sources supported by Power BI10 minutes
Local datasets vs. shared datasets10 minutes
Exercise: Setting up an Excel data source30 minutes
Exemplar: Setting up an Excel data source10 minutes
Walkthrough: Setting up your storage mode10 minutes
Additional resources: Basic data sources10 minutes
Exercise: Implementing triggers30 minutes
Exemplar: Implementing triggers10 minutes
Additional resources: Advanced data sources5 minutes

5 assignmentsTotal 80 minutes

Self-review: Setting up an Excel data source10 minutes
Knowledge check: Basic data sources15 minutes
Self-review: Implementing triggers10 minutes
Knowledge check: Advanced data sources15 minutes
Module quiz: Data sources in Power BI30 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 videosTotal 68 minutes

Why data needs to be transformed5 minutes
Introduction to Power Query and its interface6 minutes
The Applied Steps list5 minutes
Working with columns6 minutes
Dealing with errors in Power Query7 minutes
Unpivot and pivot columns7 minutes
The Importance of data combination4 minutes
Combining tables with append4 minutes
What is a join?4 minutes
Join types4 minutes
Combining tables with merge8 minutes
Identifying a new potential product3 minutes
Module summary: Transforming data in Power BI5 minutes

15 readingsTotal 195 minutes

Data types in Power BI10 minutes
Evaluating and changing column data types10 minutes
Common data errors10 minutes
Exercise: Preparing a dataset30 minutes
Exemplar: Preparing a dataset10 minutes
Activity: Apply a pivot10 minutes
Additional Resources: Introduction to transforming data in Power BI5 minutes
The importance of matching column names10 minutes
Exercise: Appending two tables30 minutes
Exemplar: Appending two tables10 minutes
Additional Resources: Advanced data transformations in Power BI5 minutes
Identifying join keys10 minutes
Exercise: Merging two data sources30 minutes
Exemplar: Merging two data sources10 minutes
Additional resources: Transformations by combining data5 minutes

7 assignmentsTotal 110 minutes

Self-review: Preparing a dataset10 minutes
Knowledge Check: Introduction to transforming data in Power BI15 minutes
Self-review: Appending two tables15 minutes
Knowledge Check: Advanced data transformations in Power BI15 minutes
Self-review: Merging two data sources10 minutes
Knowledge check: Transformations by combining data15 minutes
Module quiz: Transforming data in Power BI30 minutes

1 discussion promptTotal 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 videosTotal 58 minutes

Introduction to loading data4 minutes
The Staging Area in Power BI5 minutes
Introduction to data profiling5 minutes
Profiling Data in Power BI7 minutes
Vignette: Bad data4 minutes
Best practices when working with Power Query5 minutes
Introduction to dataflows5 minutes
Introduction to Reference Queries4 minutes
Reference queries and dataflows4 minutes
Query parameters4 minutes
Using Advanced Editor to modify code6 minutes
Module Summary: Advanced ETL in PowerBI5 minutes

12 readingsTotal 145 minutes

End-to-end ETL process and Power BI10 minutes
Additional Resources: Loading data with Power BI5 minutes
Using the Data Profiling Tools10 minutes
Exercise: Profiling a dataset30 minutes
Exemplar: Profiling a dataset30 minutes
Additional Resources: Data profiling in Power BI5 minutes
Activity: Import a dataset with best practices10 minutes
Activity: Using reference queries10 minutes
Helper Queries10 minutes
Activity: Disabling helper queries10 minutes
Global options for files10 minutes
Additional Resources: Advanced queries5 minutes

5 assignmentsTotal 85 minutes

Knowledge Check: Loading data with Power BI15 minutes
Self-review: Profiling a dataset10 minutes
Knowledge Check: Data profiling in Power BI15 minutes
Knowledge check: Advanced queries15 minutes
Module Quiz: Advanced ETL in PowerBI30 minutes

1 discussion promptTotal 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 videosTotal 8 minutes

Course Recap: Extract, transform and load data in Power BI4 minutes
Congratulations4 minutes

4 readingsTotal 60 minutes

About the final project and assessment: Extract, transform and load data in Power BI10 minutes
Final Course Project: Transforming multiple data sources30 minutes
Exemplar: Transforming multiple data sources10 minutes
Next steps10 minutes