DALL·E .. A detailed digital illustration of a modern workspace focused on data analytics. The workspace includes a large high resolution computer monitor disp

About Course

If you work with data in any capacity, you probably know that the most tedious part of all the tasks is getting the data ready. Nevertheless, it is arguably the most essential part of the analytics process because it lays the foundation for every other aspect.

If you get it wrong at the Data Prep stage, many things will go wrong down the line. That is why the instructor has specified and recommended strictly that all intending students of this course must complete the following course first:

👉🏾Data Analysis and Visualization Course

Don’t worry, it is also free 😉

Microsoft Power Query is an easy-to-use and powerful ETL application with Desktop versions running in Excel and Power BI.

In this course, you will learn and master the use of Power Query to Extract, Transform, Prepare, and Clean dirty data.

Some specific things you will learn are:

  • Connecting to Data Sources
  • Profiling and Exploring Data in Power Query
  • Combining Data with Power Query (Joins and Union)
  • Shaping and Transposing Data with Power Query
  • Dealing with Errors in Power Query
  • Summarizing Data with Group By in Power Query

Show More

What Will You Learn?

  • Gain proficiency in using Microsoft Power Query for effective data extraction.
  • Learn advanced techniques for connecting to various data sources.
  • Develop skills in data profiling and exploration to understand data quality and structure.
  • Master the art of combining data from different sources using Joins and Union methods.
  • Acquire the ability to shape and transpose data for tailored analysis.
  • Enhance your skills in identifying and resolving errors within Power Query.
  • Discover methods for summarizing and grouping data to extract meaningful insights.
  • Understand the process of cleaning and preparing data for accurate analytics.
  • Develop a solid foundation in ETL processes, crucial for data analytics.
  • Equip yourself with practical, hands-on experience in data manipulation and analysis.

Course Content

Introduction

  • Introduction to Data Preparation
    03:02
  • Getting Data into Power Query
    06:34
  • Understanding how Power Query works
    08:24
  • Previewing Column Quality for Errors and Empty values
    03:37
  • Previewing number of Unique and Distinct Values with Column Distribution
    04:16
  • Previewing Column Statistical Summaries with Column Profile
    03:20
  • Setting Data Preview Checks for Entire Dataset
    01:30
  • Intro Quiz

Combining Datasets

Structuring Data in Power Query

Creating New Columns in Power Query

Other Power Query Transformations

Cleaning Dirty Data

This course offers certificate of completion

Add this certificate to your resume, and be the standout candidate recruiters cannot ignore

selected template

Student Ratings & Reviews

No Review Yet
No Review Yet