Learn Power Query with Microsoft Power BI

person icon Harshit Srivastava

Learn Power Query with Microsoft Power BI

Learn Data Cleaning and Formatting with Power Query | Building Analytics Report with PowerBI and Power Query

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Harshit Srivastava

architecture icon Business Intelligence,Power BI


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

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


What will you learn in this course:

  • 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


What are the prerequisites for this course?

  • Basic Idea about Microsoft Excel or any other Spreadsheet editor
Learn Power Query with Microsoft Power BI


Check out the detailed breakdown of what’s inside the course

2 Lectures
  • play icon Introduction 01:41 01:41
  • play icon Resources
Getting Started with Power Query
3 Lectures
Updating Data values
2 Lectures
Text Extraction
2 Lectures
Index and Conditional Columns
3 Lectures
Date and Time Functions
3 Lectures
Removing Null values using python script
2 Lectures
Creating Visualization charts
4 Lectures

Instructor Details

Harshit Srivastava

Harshit Srivastava

SME on Cloud, Bluemix

I am Self-Taught developer who had worked on various platforms using varied languages, and involved in various Projects both Open Source and Proprietary.

I have developed Web and Android Applications, chrome Extension, worked on various frameworks, fixed bugs for some projects, and explored numerous others. I think education and learning should be free and open, not be bound with restrictions like attending classes or going to college, People from all age groups, gender, faith, race, nations, etc must get equal privilege. When entire world would act this way like being a single FAMILY, we would truly realise VALUE of Knowledge and Human Life.

Currently I am teaching more than 60,000 students from 163 countries across the world.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us