Learn Power Query with Microsoft Power BI

Learn Power Query with Microsoft Power BI, available at $49.99, has an average rating of 4.45, with 27 lectures, 1 quizzes, based on 39 reviews, and has 2484 subscribers.

You will learn about You will learn about various Power Query functions and operation in Microsoft Power BI You will learn to perform Data Cleaning operations using Power Query editor You will learn various kinds of Power Bi functions such as Split, Merge, Row deletion, Conditional and Index column and much more You will also learn about Sorting, Time and Date functions This course is ideal for individuals who are This course is primarily for people who are curious to learn Power Query functions in Power BI or People interested in Learning Data Cleaning with Power BI or People interested to learn Data Visualization with Power BI or Anyone interested to advance their data skills and aspiring data scientist It is particularly useful for This course is primarily for people who are curious to learn Power Query functions in Power BI or People interested in Learning Data Cleaning with Power BI or People interested to learn Data Visualization with Power BI or Anyone interested to advance their data skills and aspiring data scientist.

Enroll now: Learn Power Query with Microsoft Power BI

Summary

Title: Learn Power Query with Microsoft Power BI

Price: $49.99

Average Rating: 4.45

Number of Lectures: 27

Number of Quizzes: 1

Number of Published Lectures: 27

Number of Published Quizzes: 1

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

You will learn about various Power Query functions and operation in Microsoft Power BI

You will learn to perform Data Cleaning operations using Power Query editor

You will learn various kinds of Power Bi functions such as Split, Merge, Row deletion, Conditional and Index column and much more

You will also learn about Sorting, Time and Date functions

Who Should Attend

This course is primarily for people who are curious to learn Power Query functions in Power BI

People interested in Learning Data Cleaning with Power BI

People interested to learn Data Visualization with Power BI

Anyone interested to advance their data skills and aspiring data scientist

Target Audiences

This course is primarily for people who are curious to learn Power Query functions in Power BI

People interested in Learning Data Cleaning with Power BI

People interested to learn Data Visualization with Power BI

Anyone interested to advance their data skills and aspiring data scientist

In this course you will be learning about performing various operations on a dataset using Power Query editor in Microsoft Power BI Business Intelligence software. Power Query is widely used in the industry as quick and easy way to perform various kinds of advanced operations on a dataset using just a matter of few clicks. Although it supports advanced programming support with languages like Python and R. Power Query can be used in Microsoft Power BI as well as Microsoft Excel. Here, you will be learning everything on Power BI Query editor.

Power Query can be used for Cleaning and Preparing Dataset suitable for conducting further analysis and finding Insights by creating Visualization charts and Analytics reports in any business intelligence software including Power BI. Power query allows a wide range of functions and operations for data preparation. These process are key components for Data Science and thus Power BI can be effectively used as a BI software for conducting all phases of Data Science. Using Power BI you can clean and prepare your data, create models and drive insights by creating visualization charts and reports. This course is primarily focused on First stage of data science, that is Data cleaning and Preparation with Power Query.

In this course, you will be learning following Power Query functions and operations-

Row deletion and Column Split

Replace Column values

Column Merge

Adding Suffix and Prefix

Converting text to Lowercase and Uppercase

Adding and Transforming columns

Extract Function

Extract based on delimiter

Adding Conditional and Index Column

Date Functions in Power Query

Query Editor options and settings

Date and Time function- Age calculation and more

Time Functions

Sorting

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Resources

Chapter 2: Getting Started with Power Query

Lecture 1: Row deletion and Column SPLIT

Lecture 2: Replace Column Values

Lecture 3: Column MERGE

Chapter 3: Updating Data values

Lecture 1: Adding SUFFIX and PREFIX

Lecture 2: UPPERCASE and Lowercase

Chapter 4: Text Extraction

Lecture 1: Add and Transform Column- Extract function

Lecture 2: Extract text based on delimiter

Chapter 5: Index and Conditional Columns

Lecture 1: Adding Conditional and Index column

Lecture 2: query editor options

Lecture 3: Sorting

Chapter 6: Date and Time Functions

Lecture 1: Date functions in Power Query

Lecture 2: Date and Time function- age and more

Lecture 3: Time function

Chapter 7: Creating Visualization charts

Lecture 1: bar chart

Lecture 2: Line chart

Lecture 3: Ring chart

Lecture 4: Treemap- Inter-Related charts in a dashboard

Chapter 8: Creating Slicers and advanced charts

Lecture 1: Table and Matrix

Lecture 2: Drill Down Table and Matrix

Lecture 3: Slicer- Basics

Lecture 4: Slicers- Date Slicer

Lecture 5: View Data and Export in CSV

Lecture 6: Simple Map and modes

Chapter 9: Removing Null values using python script

Lecture 1: Python script to replace null values

Lecture 2: Append Query- Join tables to bring back lost date data

Chapter 10: Quiz

Chapter 11: Assignment

Instructors

Harshit Srivastava
Cloud Professional | Content Creator | Edupreneur

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 9 votes

4 stars: 11 votes

5 stars: 18 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!