30-days Money-Back Guarantee
Learn Data Cleaning and Formatting with Power Query | Building Analytics Report with PowerBI and Power Query
Updated on Sep, 2026
Business, Business Analytics and Intelligence, Microsoft Power BI
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
In this course, you will be learning about performing various operations on a dataset using the Power Query editor in Microsoft Power BI Business Intelligence software. Power Query is widely used in the industry as a 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 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 the Power BI Query editor.
Power Query can be used for cleaning and preparing a 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 processes 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 the First stage of data science, that is, Data cleaning and Preparation with Power Query.
In this course, you will be learning the following Power Query functions and operations:
Row deletion and Column Split
Replace Column values
Adding Suffix and Prefix
Converting text to Lowercase and Uppercase
Adding and Transforming columns
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
Check out the detailed breakdown of what’s inside the course
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 realize VALUE of Knowledge and Human Life.
Currently I am teaching more than 152,000 students from 189 countries across the world.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.