Monthly Subscription Starting at AED 99 + VAT

Extract, Transform and Load Data in Power BI
  • Level Foundation
  • Duration 20 hours
  • Course by Microsoft
  • Offered by

About

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.

Modules

Welcome to the Course

    • 1 Videos
    • 7 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Discussion prompt: What do you hope to learn?

1 Videos

  • Course Introduction

7 Readings

  • Course Syllabus
  • How to be successful in this course
  • How to open an image in a new tab
  • Setting up your Power BI environment
  • New name for Power BI datasets
  • How to locate your downloaded files
  • Additional Resources: Data sources in Power BI

Basic Data Sources

    • 4 Videos
    • 6 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Setting up an Excel data source
  • Knowledge check: Basic data sources

1 Discussions

  • What challenges did you encounter while configuring storage modes?

4 Videos

  • How combining data sources gives business insights
  • Setting up a flat data source
  • Storage modes in Power BI
  • Configuring storage modes in Power BI

6 Readings

  • Data Sources supported by Power BI
  • Local datasets vs. shared datasets
  • Exercise: Setting up an Excel data source
  • Exemplar: Setting up an Excel data source
  • Walkthrough: Setting up your storage mode
  • Additional resources: Basic data sources

Advanced Data Sources

    • 4 Videos
    • 3 Readings
    • 1 Discussion
    • 3 Assignment
Show info about module content

3 Assignment

  • Self-review: Implementing triggers
  • Knowledge check: Advanced data sources
  • Module quiz: Data sources in Power BI

1 Discussions

  • How can stakeholders benefit from triggers and actions?

4 Videos

  • Structured vs. unstructured data
  • What are connectors?
  • Triggers and actions
  • Module summary: Data sources in Power BI

3 Readings

  • Exercise: Implementing triggers
  • Exemplar: Implementing triggers
  • Additional resources: Advanced data sources

Introduction to Transforming Data in Power BI

    • 6 Videos
    • 7 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Preparing a dataset
  • Knowledge Check: Introduction to transforming data in Power BI

6 Videos

  • Why data needs to be transformed
  • Introduction to Power Query and its interface
  • The Applied Steps list
  • Working with columns
  • Dealing with errors in Power Query
  • Unpivot and pivot columns

7 Readings

  • Data types in Power BI
  • Evaluating and changing column data types
  • Common data errors
  • Exercise: Preparing a dataset
  • Exemplar: Preparing a dataset
  • Activity: Apply a pivot
  • Additional Resources: Introduction to transforming data in Power BI

Advanced Data Transformations in Power BI

    • 2 Videos
    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Appending two tables
  • Knowledge Check: Advanced data transformations in Power BI

2 Videos

  • The Importance of data combination
  • Combining tables with append

4 Readings

  • The importance of matching column names
  • Exercise: Appending two tables
  • Exemplar: Appending two tables
  • Additional Resources: Advanced data transformations in Power BI

Transformations by Combining Data

    • 5 Videos
    • 4 Readings
    • 1 Discussion
    • 3 Assignment
Show info about module content

3 Assignment

  • Self-review: Merging two data sources
  • Knowledge check: Transformations by combining data
  • Module quiz: Transforming data in Power BI

1 Discussions

  • What challenges might you encounter when combining data?

5 Videos

  • What is a join?
  • Join types
  • Combining tables with merge
  • Identifying a new potential product
  • Module summary: Transforming data in Power BI

4 Readings

  • Identifying join keys
  • Exercise: Merging two data sources
  • Exemplar: Merging two data sources
  • Additional resources: Transformations by combining data

Loading Data with Power BI

    • 2 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge Check: Loading data with Power BI

2 Videos

  • Introduction to loading data
  • The Staging Area in Power BI

2 Readings

  • End-to-end ETL process and Power BI
  • Additional Resources: Loading data with Power BI

Data Profiling in Power BI

    • 3 Videos
    • 4 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Profiling a dataset
  • Knowledge Check: Data profiling in Power BI

3 Videos

  • Introduction to data profiling
  • Profiling Data in Power BI
  • Vignette: Bad data

4 Readings

  • Using the Data Profiling Tools
  • Exercise: Profiling a dataset
  • Exemplar: Profiling a dataset
  • Additional Resources: Data profiling in Power BI

Advanced Queries

    • 7 Videos
    • 6 Readings
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: Advanced queries
  • Module Quiz: Advanced ETL in PowerBI

1 Discussions

  • Which best practices did you find most useful?

7 Videos

  • Best practices when working with Power Query
  • Introduction to dataflows
  • Introduction to Reference Queries
  • Reference queries and dataflows
  • Query parameters
  • Using Advanced Editor to modify code
  • Module Summary: Advanced ETL in PowerBI

6 Readings

  • Activity: Import a dataset with best practices
  • Activity: Using reference queries
  • Helper Queries
  • Activity: Disabling helper queries
  • Global options for files
  • Additional Resources: Advanced queries

Final project and assessment: Extract Transform and Load Data in Power BI

    • 1 Videos
    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Self-review: Transforming multiple data sources
  • Course quiz: Extract, transform and load Data in Power BI

1 Videos

  • Course Recap: Extract, transform and load data in Power BI

3 Readings

  • About the final project and assessment: Extract, transform and load data in Power BI
  • Final Course Project: Transforming multiple data sources
  • Exemplar: Transforming multiple data sources

Course wrap-up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

1 Videos

  • Congratulations

1 Readings

  • Next steps

Auto Summary

Embark on a foundational journey in data science with the "Extract, Transform and Load Data in Power BI" course. Offered by Coursera, this course is part of the Microsoft Power BI Analyst Professional Certificate. Led by expert instructors, you'll master ETL processes, configure multiple data sources, and cleanse data using Power Query over 1200 minutes of content. Perfect for aspiring data analysts, this course also prepares you for the Microsoft PL-300 exam. Available through Starter and Professional subscriptions.

Microsoft
Instructor

Microsoft